DBA Data[Home] [Help]

APPS.OE_EXT_CREDIT_EXPOSURE_PVT dependencies on OE_EXPOSURE_INTERFACE_S

Line 1183: SET exposure_interface_id = OE_EXPOSURE_INTERFACE_S.NextVal,

1179: IF l_org_id IS NOT NULL THEN
1180: MO_GLOBAL.set_policy_context('S', l_org_id);
1181:
1182: UPDATE oe_exposure_interface
1183: SET exposure_interface_id = OE_EXPOSURE_INTERFACE_S.NextVal,
1184: import_status_code = G_PROCESSING,
1185: request_id = G_request_id
1186: WHERE exposure_source_code = NVL(p_exposure_source_code, exposure_source_code)
1187: AND NVL(batch_id, -99) = NVL(p_batch_id, NVL(batch_id,-99))

Line 1210: SET exposure_interface_id = OE_EXPOSURE_INTERFACE_S.NextVal,

1206:
1207: MO_GLOBAL.set_policy_context('S', l_org_id);
1208:
1209: UPDATE oe_exposure_interface
1210: SET exposure_interface_id = OE_EXPOSURE_INTERFACE_S.NextVal,
1211: import_status_code = G_PROCESSING,
1212: request_id = G_request_id
1213: WHERE exposure_source_code = NVL(p_exposure_source_code, exposure_source_code)
1214: AND NVL(batch_id, -99) = NVL(p_batch_id, NVL(batch_id,-99))

Line 1232: -- SET exposure_interface_id = OE_EXPOSURE_INTERFACE_S.NextVal,

1228: --
1229: -- Select exposure rows for processing and assign an exposure_interface_id
1230: --
1231: -- UPDATE oe_exposure_interface
1232: -- SET exposure_interface_id = OE_EXPOSURE_INTERFACE_S.NextVal,
1233: -- import_status_code = G_PROCESSING,
1234: -- request_id = G_request_id
1235: -- WHERE exposure_source_code = NVL(p_exposure_source_code, exposure_source_code)
1236: -- AND NVL(batch_id, -99) = NVL(p_batch_id, NVL(batch_id,-99))