APPS.EGO_TA_BULKLOAD_PVT dependencies on DUAL

Line 1944: FROM dual;

1940: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
1941: SELECT Decode(p_ta_intf_tbl(i).transaction_type,'CREATE','Create_Transaction_Attribute',
1942: 'UPDATE','Update_Transaction_Attribute',
1943: 'DELETE','Delete_Transaction_Attribute') INTO G_TOKEN_TBL(4).Token_Value
1944: FROM dual;
1945:
1946: /* added p_addto_fnd_stack because in case of error ICC API will rollback the TA
1947: so messages will also get rollback. So if it get added to stack we can print and insert
1948: to interface_error table again*/

Line 2007: FROM dual;

2003:
2004: /*Sets the transaction_id*/
2005: SELECT mtl_system_items_interface_s.NEXTVAL,Upper(p_ta_intf_tbl(i).transaction_type)
2006: INTO p_ta_intf_tbl(i).transaction_id,p_ta_intf_tbl(i).transaction_type
2007: FROM dual;
2008:
2009: /* if not a valid transaction type*/
2010: IF p_ta_intf_tbl(i).transaction_type NOT IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC) THEN
2011: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Transaction Type '