eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_EXT_CREDIT_EXPOSURE_PVT dependencies on OE_EXPOSURE_INTERFACE

Line 98: ( p_exposure_rec IN oe_exposure_interface%ROWTYPE

94: -- DESCRIPTION: This function returns TRUE if the currency code is a
95: -- valid currency code and FALSE otherwise.
96: --=====================================================================
97: FUNCTION Is_Currency_Valid
98: ( p_exposure_rec IN oe_exposure_interface%ROWTYPE
99: )
100: RETURN BOOLEAN
101: IS
102: l_return_value BOOLEAN := TRUE;

Line 150: ( p_exposure_rec IN oe_exposure_interface%ROWTYPE

146: -- bill-to address and customer information.
147: --=====================================================================
148:
149: FUNCTION Address_Value_To_ID
150: ( p_exposure_rec IN oe_exposure_interface%ROWTYPE
151: ) RETURN NUMBER
152: IS
153:
154: CURSOR c_bill_to_site_use_id (p_bill_to_state VARCHAR2) IS

Line 464: ( p_exposure_rec IN oe_exposure_interface%ROWTYPE

460: -- DESCRIPTION: This procedure validate the bill-to site use ID if provided.
461: -- else it validate the other parameters and derive the site use ID.
462: --=====================================================================
463: PROCEDURE Get_Bill_To_Site_Use_ID
464: ( p_exposure_rec IN oe_exposure_interface%ROWTYPE
465: ,x_return_status OUT NOCOPY VARCHAR2
466: ,x_bill_to_site_use_id OUT NOCOPY NUMBER
467: ,x_org_id OUT NOCOPY NUMBER
468: ,x_bill_to_customer_id OUT NOCOPY NUMBER

Line 474: l_exposure_rec oe_exposure_interface%ROWTYPE;

470: IS
471: l_bill_to_site_use_id NUMBER;
472: l_bill_to_customer_id NUMBER;
473: l_message_text VARCHAR2(2000);
474: l_exposure_rec oe_exposure_interface%ROWTYPE;
475: BEGIN
476: OE_DEBUG_PUB.Add('OEXVECEB: In Get_Bill_To_Site_Use_ID', 4);
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:

Line 636: FROM oe_exposure_interface

632: IS
633:
634: CURSOR c_exposure_source IS
635: SELECT distinct exposure_source_code
636: FROM oe_exposure_interface
637: WHERE request_id = G_request_id
638: AND import_status_code = G_PROCESSING;
639:
640: CURSOR c_multi_op_code

Line 641: (p_exposure_source_code oe_exposure_interface.exposure_source_code%TYPE) IS

637: WHERE request_id = G_request_id
638: AND import_status_code = G_PROCESSING;
639:
640: CURSOR c_multi_op_code
641: (p_exposure_source_code oe_exposure_interface.exposure_source_code%TYPE) IS
642: SELECT COUNT(distinct operation_code)
643: FROM oe_exposure_interface
644: WHERE request_id = G_request_id
645: AND import_status_code = G_PROCESSING

Line 643: FROM oe_exposure_interface

639:
640: CURSOR c_multi_op_code
641: (p_exposure_source_code oe_exposure_interface.exposure_source_code%TYPE) IS
642: SELECT COUNT(distinct operation_code)
643: FROM oe_exposure_interface
644: WHERE request_id = G_request_id
645: AND import_status_code = G_PROCESSING
646: AND exposure_source_code = p_exposure_source_code
647: HAVING COUNT(distinct operation_code) > 1;

Line 650: (p_exposure_source_code oe_exposure_interface.exposure_source_code%TYPE) IS

646: AND exposure_source_code = p_exposure_source_code
647: HAVING COUNT(distinct operation_code) > 1;
648:
649: CURSOR c_invalid_op_code
650: (p_exposure_source_code oe_exposure_interface.exposure_source_code%TYPE) IS
651: SELECT distinct operation_code
652: FROM oe_exposure_interface
653: WHERE request_id = G_request_id
654: AND import_status_code = G_PROCESSING

Line 652: FROM oe_exposure_interface

648:
649: CURSOR c_invalid_op_code
650: (p_exposure_source_code oe_exposure_interface.exposure_source_code%TYPE) IS
651: SELECT distinct operation_code
652: FROM oe_exposure_interface
653: WHERE request_id = G_request_id
654: AND import_status_code = G_PROCESSING
655: AND operation_code NOT IN ('INSERT', 'UPDATE');
656:

Line 657: l_exposure_soure_code oe_exposure_interface.exposure_source_code%TYPE;

653: WHERE request_id = G_request_id
654: AND import_status_code = G_PROCESSING
655: AND operation_code NOT IN ('INSERT', 'UPDATE');
656:
657: l_exposure_soure_code oe_exposure_interface.exposure_source_code%TYPE;
658: l_op_code_count NUMBER := 0;
659: l_operation_code oe_exposure_interface.operation_code%TYPE;
660: l_message_text oe_exp_interface_errors.error_message%TYPE;
661: l_source_valid NUMBER;

Line 659: l_operation_code oe_exposure_interface.operation_code%TYPE;

655: AND operation_code NOT IN ('INSERT', 'UPDATE');
656:
657: l_exposure_soure_code oe_exposure_interface.exposure_source_code%TYPE;
658: l_op_code_count NUMBER := 0;
659: l_operation_code oe_exposure_interface.operation_code%TYPE;
660: l_message_text oe_exp_interface_errors.error_message%TYPE;
661: l_source_valid NUMBER;
662: l_any_op_code_errors BOOLEAN := FALSE;
663: BEGIN

Line 696: UPDATE oe_exposure_interface

692: , p_batch_id => NULL
693: , p_error_message_name => 'OE_CC_IMP_SOURCE_INVALID'
694: , p_error_message_text => l_message_text
695: );
696: UPDATE oe_exposure_interface
697: SET import_status_code = G_ERROR
698: WHERE exposure_source_code = l_row.exposure_source_code
699: AND request_id = G_request_id;
700:

Line 749: UPDATE oe_exposure_interface

745: );
746: --
747: -- update import_status_code if errors found
748: --
749: UPDATE oe_exposure_interface
750: SET import_status_code = G_ERROR
751: WHERE exposure_source_code = l_row.exposure_source_code
752: AND request_id = G_request_id;
753:

Line 787: FROM oe_exposure_interface

783: PROCEDURE Validate_Exposure
784: IS
785: CURSOR c_rows_to_process IS
786: SELECT *
787: FROM oe_exposure_interface
788: WHERE request_id = G_request_id
789: AND import_status_code = G_PROCESSING;
790:
791: l_bill_to_site_use_id NUMBER;

Line 852: UPDATE oe_exposure_interface

848: END IF;
849:
850: IF l_any_errors THEN
851: OE_DEBUG_PUB.Add('Validation Errors Found', 5);
852: UPDATE oe_exposure_interface
853: SET import_status_code = G_ERROR
854: WHERE exposure_interface_id = l_exposure_rec.exposure_interface_id;
855: ELSE
856: -- Update status code and IDs and Who Columns

Line 859: UPDATE oe_exposure_interface

855: ELSE
856: -- Update status code and IDs and Who Columns
857: OE_DEBUG_PUB.Add(
858: 'No Validation Errors Found. Updating the interface table...', 5);
859: UPDATE oe_exposure_interface
860: SET import_status_code = G_VALIDATED,
861: bill_to_site_use_id = l_bill_to_site_use_id,
862: bill_to_customer_id = l_bill_to_customer_id,
863: last_update_login = G_login_id,

Line 908: ( p_exposure_rec IN oe_exposure_interface%ROWTYPE

904: --IN
905: --OUT
906: --=====================================================================
907: PROCEDURE Insert_Exposure
908: ( p_exposure_rec IN oe_exposure_interface%ROWTYPE
909: )
910: IS
911: CURSOR c_summary_row IS
912: SELECT rowid

Line 977: ( p_exposure_rec IN oe_exposure_interface%ROWTYPE

973: --IN
974: --OUT
975: --=====================================================================
976: PROCEDURE Update_Exposure
977: ( p_exposure_rec IN oe_exposure_interface%ROWTYPE
978: )
979: IS
980: CURSOR c_summary_exposure IS
981: SELECT rowid, balance

Line 1057: FROM oe_exposure_interface

1053: PROCEDURE Import_Exposure
1054: IS
1055: CURSOR c_valid_exposures IS
1056: SELECT *
1057: FROM oe_exposure_interface
1058: WHERE request_id = G_request_id
1059: AND import_status_code = G_VALIDATED
1060: ORDER BY exposure_source_code;
1061:

Line 1075: UPDATE oe_exposure_interface

1071:
1072: --
1073: -- Set status to complete after updating/inserting
1074: --
1075: UPDATE oe_exposure_interface
1076: SET import_status_code = 'COMPLETE'
1077: WHERE exposure_interface_id = l_exposure_rec.exposure_interface_id;
1078:
1079: l_commitsize_count := l_commitsize_count + 1;

Line 1182: UPDATE oe_exposure_interface

1178:
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)

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 1209: UPDATE oe_exposure_interface

1205: END IF;
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)

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 1231: -- UPDATE oe_exposure_interface

1227:
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)

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))

Line 1246: FROM oe_exposure_interface

1242: -- Count the number of rows selected for processing
1243: --
1244: SELECT count(1)
1245: INTO l_num_rows_to_process
1246: FROM oe_exposure_interface
1247: WHERE request_id = G_request_id
1248: AND import_status_code = G_PROCESSING;
1249:
1250: --

Line 1270: FROM oe_exposure_interface

1266: -- l_validated to TRUE.
1267: --
1268: SELECT count(1)
1269: INTO l_num_rows_validated
1270: FROM oe_exposure_interface
1271: WHERE request_id = G_request_id
1272: AND import_status_code = G_VALIDATED;
1273:
1274: --

Line 1284: FROM oe_exposure_interface

1280: --
1281: IF l_num_rows_validated < l_num_rows_to_process THEN
1282: SELECT count(1)
1283: INTO l_num_rows_failed
1284: FROM oe_exposure_interface
1285: WHERE request_id = G_request_id
1286: AND import_status_code = G_ERROR;
1287: END IF;
1288:

Line 1293: UPDATE oe_exposure_interface

1289: IF p_validate_only = 'Y' THEN
1290: -- bug 234505. Reset the import_status_code to NULL
1291: -- since only status of NULL records will be selected
1292: -- for processing in next import run.
1293: UPDATE oe_exposure_interface
1294: SET import_status_code = NULL
1295: WHERE request_id = G_request_id
1296: AND import_status_code = G_VALIDATED;
1297:

Line 1306: FROM oe_exposure_interface

1302: -- Count the number of exposure rows loaded. Default is 0.
1303: --
1304: SELECT count(1)
1305: INTO l_num_rows_imported
1306: FROM oe_exposure_interface
1307: WHERE request_id = G_request_id
1308: AND import_status_code = G_COMPLETE;
1309:
1310: --

Line 1314: FROM oe_exposure_interface

1310: --
1311: -- Delete exposure from the interface table after they are imported.
1312: --
1313: DELETE
1314: FROM oe_exposure_interface
1315: WHERE request_id = G_request_id
1316: AND import_status_code = G_COMPLETE;
1317: END IF;
1318: --