DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONSET_PKG dependencies on IBY_TRXNSUMM_TRXNID_S

Line 66: SELECT iby_trxnsumm_trxnid_s.NEXTVAL

62: IF ((transaction_id_in_out = '') OR
63: (transaction_id_in_out = -1) OR
64: (transaction_id_in_out IS NULL))
65: THEN
66: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
67: INTO transaction_id
68: FROM dual;
69: transaction_id_in_out := transaction_id;
70: ELSE

Line 307: SELECT iby_trxnsumm_trxnid_s.NEXTVAL

303:
304: IF (counter = 0)
305: THEN
306:
307: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
308: INTO transaction_id
309: FROM dual;
310:
311: ELSE

Line 584: SELECT iby_trxnsumm_trxnid_s.NEXTVAL

580: FROM dual;
581: IF ((transaction_id_in_out = '') OR
582: (transaction_id_in_out IS NULL))
583: THEN
584: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
585: INTO transaction_id
586: FROM dual;
587: transaction_id_in_out := transaction_id;
588: ELSE

Line 825: SELECT iby_trxnsumm_trxnid_s.NEXTVAL

821:
822: IF (counter = 0)
823: THEN
824:
825: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
826: INTO transaction_id
827: FROM dual;
828:
829: ELSE

Line 1036: SELECT iby_trxnsumm_trxnid_s.NEXTVAL

1032: -- generate trxn_id and transaction_id
1033: SELECT iby_trxnsumm_mid_s.NEXTVAL
1034: INTO trxn_mid
1035: FROM dual;
1036: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
1037: INTO transaction_id
1038: FROM dual;
1039: transaction_id_in_out := transaction_id;
1040:

Line 1314: -- SELECT iby_trxnsumm_trxnid_s.NEXTVAL

1310: -- generate trxn_id and transaction_id
1311: SELECT iby_trxnsumm_mid_s.NEXTVAL
1312: INTO trxn_mid
1313: FROM dual;
1314: -- SELECT iby_trxnsumm_trxnid_s.NEXTVAL
1315: -- INTO transaction_id
1316: -- FROM dual;
1317: -- transaction_id_in_out := transaction_id;
1318: -- No previous transaction, so get parent split_id

Line 1576: --SELECT iby_trxnsumm_trxnid_s.NEXTVAL

1572: -- generate trxn_id and transaction_id
1573: SELECT iby_trxnsumm_mid_s.NEXTVAL
1574: INTO trxn_mid
1575: FROM dual;
1576: --SELECT iby_trxnsumm_trxnid_s.NEXTVAL
1577: -- INTO transaction_id
1578: -- FROM dual;
1579: --transaction_id_in_out := transaction_id;
1580: