APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_RTP_TRANS_T

Line 1830: FROM jai_rtp_trans_t )

1826: SELECT rowid
1827: FROM jai_rcv_transactions
1828: WHERE transaction_id IN
1829: ( SELECT transaction_id
1830: FROM jai_rtp_trans_t )
1831: FOR UPDATE OF transaction_id ;
1832:
1833: lock_rcv_rec_trans c_lock_rcv_trans%ROWTYPE ;
1834: BEGIN

Line 1839: INTO JAI_RTP_TRANS_T

1835: IF p_shipment_header_id is null THEN
1836: IF p_transaction_type IS NOT NULL THEN
1837: IF p_parent_trx_type IS NOT NULL THEN
1838: INSERT
1839: INTO JAI_RTP_TRANS_T
1840: (TRANSACTION_ID,
1841: PROCESS_FLAG,
1842: CENVAT_RG_FLAG,
1843: PROCESS_MESSAGE,

Line 1883: INTO JAI_RTP_TRANS_T

1879: )
1880: ) ;
1881: ELSE -- p_parent_trx_type IS NOT NULL
1882: INSERT
1883: INTO JAI_RTP_TRANS_T
1884: (TRANSACTION_ID,
1885: PROCESS_FLAG,
1886: CENVAT_RG_FLAG,
1887: PROCESS_MESSAGE,

Line 1929: INTO JAI_RTP_TRANS_T

1925: END IF ; --IF p_parent_trx_type IS NOT NULL
1926:
1927: ELSE --IF p_transaction_type IS NOT NULL
1928: INSERT
1929: INTO JAI_RTP_TRANS_T
1930: (TRANSACTION_ID,
1931: PROCESS_FLAG,
1932: CENVAT_RG_FLAG,
1933: PROCESS_MESSAGE,

Line 1972: INTO JAI_RTP_TRANS_T

1968: ) ;
1969: END IF ; --IF p_transaction_type IS NOT NULL
1970: ELSE
1971: INSERT
1972: INTO JAI_RTP_TRANS_T
1973: (TRANSACTION_ID,
1974: PROCESS_FLAG,
1975: CENVAT_RG_FLAG,
1976: PROCESS_MESSAGE,

Line 2310: FOR trx IN (SELECT * FROM JAI_RTP_TRANS_T ORDER BY transaction_id) LOOP

2306: ja_in_get_transactions ; -- internal procedure call ; -- added by Sanjikum for bug #4929410
2307:
2308: --FOR trx IN c_get_transactions LOOP
2309: --commented the above and added the below by Sanjikum for Bug#4929410
2310: FOR trx IN (SELECT * FROM JAI_RTP_TRANS_T ORDER BY transaction_id) LOOP
2311:
2312: BEGIN
2313:
2314: lv_common_err_mesg := null;