DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on GME_BATCH_HEADER

Line 1573: , p_batch_id IN gme_batch_header.batch_id%TYPE

1569: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1570: , x_return_status OUT NOCOPY VARCHAR2
1571: , x_msg_count OUT NOCOPY NUMBER
1572: , x_msg_data OUT NOCOPY VARCHAR2
1573: , p_batch_id IN gme_batch_header.batch_id%TYPE
1574: )
1575: RETURN BOOLEAN
1576: IS
1577:

Line 1591: l_batch_id IN gme_batch_header.batch_id%TYPE

1587: **********/
1588:
1589: CURSOR c_get_period_info
1590: (
1591: l_batch_id IN gme_batch_header.batch_id%TYPE
1592: )
1593: IS
1594: SELECT count(1)
1595: FROM cm_cmpt_dtl cst,

Line 1598: gme_batch_header bh

1594: SELECT count(1)
1595: FROM cm_cmpt_dtl cst,
1596: cm_acst_led aled,
1597: gme_material_details md,
1598: gme_batch_header bh
1599: WHERE bh.batch_id = l_batch_id
1600: AND bh.batch_id = md.batch_id
1601: AND md.material_detail_id = aled.transline_id
1602: AND aled.source_ind = 0