DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on GME_BATCH_HEADER

Line 1751: , p_batch_id IN gme_batch_header.batch_id%TYPE

1747: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1748: , x_return_status OUT NOCOPY VARCHAR2
1749: , x_msg_count OUT NOCOPY NUMBER
1750: , x_msg_data OUT NOCOPY VARCHAR2
1751: , p_batch_id IN gme_batch_header.batch_id%TYPE
1752: )
1753: RETURN BOOLEAN
1754: IS
1755:

Line 1769: l_batch_id IN gme_batch_header.batch_id%TYPE

1765: **********/
1766:
1767: CURSOR c_get_period_info
1768: (
1769: l_batch_id IN gme_batch_header.batch_id%TYPE
1770: )
1771: IS
1772: SELECT count(1)
1773: FROM cm_cmpt_dtl cst,

Line 1776: gme_batch_header bh

1772: SELECT count(1)
1773: FROM cm_cmpt_dtl cst,
1774: cm_acst_led aled,
1775: gme_material_details md,
1776: gme_batch_header bh
1777: WHERE bh.batch_id = l_batch_id
1778: AND bh.batch_id = md.batch_id
1779: AND md.material_detail_id = aled.transline_id
1780: AND aled.source_ind = 0