APPS.EGO_AG_BULKLOAD_PVT dependencies on DUAL

Line 3862: FROM dual;

3858:
3859: /*Sets the transaction_id*/
3860: SELECT mtl_system_items_interface_s.nextval
3861: INTO P_ag_tbl(i).transaction_id
3862: FROM dual;
3863:
3864: lv_smt := 2;
3865:
3866: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');

Line 3948: FROM dual;

3944:
3945: /*Sets the transaction_id*/
3946: SELECT mtl_system_items_interface_s.nextval
3947: INTO P_agdl_tbl(i).transaction_id
3948: FROM dual;
3949:
3950: lv_smt := 2;
3951:
3952: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');

Line 5216: FROM dual;

5212: FOR i IN p_ag_tbl.FIRST.. p_ag_tbl.LAST LOOP
5213: /*Convert transaction type to upper case*/
5214: SELECT Upper(P_ag_tbl(i).transaction_type)
5215: INTO P_ag_tbl(i).transaction_type
5216: FROM dual;
5217:
5218: IF ( P_ag_tbl(i).transaction_type = G_OPR_CREATE
5219: OR P_ag_tbl(i).transaction_type = G_OPR_UPDATE
5220: OR P_ag_tbl(i).transaction_type = G_OPR_DELETE

Line 5260: FROM dual;

5256: FOR i IN p_agdl_tbl.FIRST.. p_agdl_tbl.LAST LOOP
5257: /*Convert transaction type to upper case*/
5258: SELECT Upper(P_agdl_tbl(i).transaction_type)
5259: INTO P_agdl_tbl(i).transaction_type
5260: FROM dual;
5261:
5262: IF ( P_agdl_tbl(i).transaction_type = G_OPR_CREATE
5263: OR P_agdl_tbl(i).transaction_type = G_OPR_UPDATE
5264: OR P_agdl_tbl(i).transaction_type = G_OPR_SYNC) THEN

Line 5919: FROM dual;

5915: FOR i IN p_attr_tbl.FIRST.. p_attr_tbl.LAST LOOP
5916: /*Convert transaction type to upper case*/
5917: SELECT Upper(P_attr_tbl(i).transaction_type)
5918: INTO P_attr_tbl(i).transaction_type
5919: FROM dual;
5920:
5921: /*Check for invalid transaction type in the Attribute table*/
5922: IF ( P_attr_tbl(i).transaction_type = G_OPR_CREATE
5923: OR P_attr_tbl(i).transaction_type = G_OPR_UPDATE