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.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on EGO_ITEM_PEOPLE_INTF

Line 35: G_ERROR_TABLE_NAME VARCHAR2(99) := 'EGO_ITEM_PEOPLE_INTF';

31:
32: -- Message array size
33: G_MAX_MESSAGE_SIZE PLS_INTEGER := 1000;
34:
35: G_ERROR_TABLE_NAME VARCHAR2(99) := 'EGO_ITEM_PEOPLE_INTF';
36: G_ERROR_ENTITY_CODE VARCHAR2(99) := 'EGO_ITEM_PEOPLE';
37: G_ERROR_FILE_NAME VARCHAR2(99);
38: G_BO_IDENTIFIER VARCHAR2(99) := 'EGO_ITEM_PEOPLE';
39: --

Line 57: G_DATA_SET_ID EGO_ITEM_PEOPLE_INTF.data_set_id%TYPE;

53: G_INSERT_OVERLAP_ERROR NUMBER := -1;
54: --
55: -- variables that will be used across programs
56: --
57: G_DATA_SET_ID EGO_ITEM_PEOPLE_INTF.data_set_id%TYPE;
58: G_FROM_LINE_NUMBER NUMBER;
59: G_TO_LINE_NUMBER NUMBER;
60: G_TRANSACTION_ID NUMBER;
61: G_DEBUG_MODE PLS_INTEGER;

Line 92: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;

88: -- Global variables used for Bulk Processing
89: -- =================================================================
90: -- TYPE g_t_grant_guid_table IS TABLE OF fnd_grants.grant_guid%TYPE INDEX BY BINARY_INTEGER;
91: --
92: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
93: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
94: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
95: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
96: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;

Line 93: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;

89: -- =================================================================
90: -- TYPE g_t_grant_guid_table IS TABLE OF fnd_grants.grant_guid%TYPE INDEX BY BINARY_INTEGER;
91: --
92: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
93: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
94: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
95: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
96: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
97: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

Line 94: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;

90: -- TYPE g_t_grant_guid_table IS TABLE OF fnd_grants.grant_guid%TYPE INDEX BY BINARY_INTEGER;
91: --
92: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
93: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
94: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
95: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
96: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
97: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
98: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;

Line 95: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;

91: --
92: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
93: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
94: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
95: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
96: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
97: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
98: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;
99: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;

Line 96: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;

92: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
93: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
94: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
95: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
96: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
97: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
98: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;
99: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;
100: -- TYPE g_t_grantee_key_table IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;

Line 97: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

93: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
94: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
95: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
96: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
97: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
98: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;
99: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;
100: -- TYPE g_t_grantee_key_table IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
101:

Line 98: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;

94: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
95: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
96: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
97: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
98: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;
99: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;
100: -- TYPE g_t_grantee_key_table IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
101:
102: ----------------------------------------------------------------------

Line 99: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;

95: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
96: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
97: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
98: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;
99: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;
100: -- TYPE g_t_grantee_key_table IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
101:
102: ----------------------------------------------------------------------
103: -- Global variables used for Parsing process.

Line 212: FROM ego_item_people_intf

208: BEGIN
209: IF G_DEBUG_MODE = DEBUG_MODE_DEBUG THEN
210: SELECT COUNT(*)
211: INTO l_error_record_count
212: FROM ego_item_people_intf
213: WHERE data_set_id = G_DATA_SET_ID
214: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
215: AND process_status = G_PS_ERROR;
216:

Line 565: FROM ego_item_people_intf

561: DELETE mtl_interface_errors
562: WHERE table_name = G_ERROR_TABLE_NAME
563: AND transaction_id IN
564: (SELECT transaction_id
565: FROM ego_item_people_intf
566: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
567: AND creation_date <= NVL(p_closed_date, creation_date)
568: );
569: DELETE ego_item_people_intf

Line 569: DELETE ego_item_people_intf

565: FROM ego_item_people_intf
566: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
567: AND creation_date <= NVL(p_closed_date, creation_date)
568: );
569: DELETE ego_item_people_intf
570: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
571: AND creation_date <= NVL(p_closed_date, creation_date);
572:
573: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ERROR THEN

Line 581: FROM ego_item_people_intf

577: DELETE mtl_interface_errors
578: WHERE table_name = G_ERROR_TABLE_NAME
579: AND transaction_id IN
580: (SELECT transaction_id
581: FROM ego_item_people_intf
582: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
583: AND creation_date <= NVL(p_closed_date, creation_date)
584: );
585: DELETE ego_item_people_intf

Line 585: DELETE ego_item_people_intf

581: FROM ego_item_people_intf
582: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
583: AND creation_date <= NVL(p_closed_date, creation_date)
584: );
585: DELETE ego_item_people_intf
586: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
587: AND creation_date <= NVL(p_closed_date, creation_date)
588: AND process_status = G_PS_ERROR;
589:

Line 594: DELETE ego_item_people_intf

590: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS THEN
591: --
592: -- delete all success lines
593: --
594: DELETE ego_item_people_intf
595: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
596: AND creation_date <= NVL(p_closed_date, creation_date)
597: AND process_status = G_PS_SUCCESS;
598: END IF;

Line 645: -- NO ACTION IS PERFORMED ON ego_item_people_intf

641: -- Pre-reqs : NONE
642: --
643: -- FUNCTION : To check if the required grant can be updated
644: -- and updates fnd_grants if required
645: -- NO ACTION IS PERFORMED ON ego_item_people_intf
646: --
647: -- Parameters:
648: -- IN : NONE
649: --

Line 856: -- NO ACTION IS PERFORMED ON ego_item_people_intf

852: -- Pre-reqs : NONE
853: --
854: -- FUNCTION : To check if the required grant is valid for insert
855: -- and inserts the record into fnd_grants if valid
856: -- NO ACTION IS PERFORMED ON ego_item_people_intf
857: --
858: -- Parameters:
859: -- IN : NONE
860: --

Line 1022: FROM ego_item_people_intf

1018: 'UPDATE', ORDER_BY_UPDATE,
1019: 'SYNC', ORDER_BY_SYNC,
1020: 'DELETE', ORDER_BY_DELETE,
1021: ORDER_BY_OTHERS) trans_type
1022: FROM ego_item_people_intf
1023: WHERE data_set_id = G_DATA_SET_ID
1024: AND process_status = G_PS_IN_PROCESS
1025: ORDER BY trans_type, transaction_id
1026: FOR UPDATE OF transaction_id;

Line 1058: FROM ego_item_people_intf

1054:
1055: -- 3578536
1056: CURSOR c_count_ipi_lines (cp_data_set_id IN NUMBER) IS
1057: SELECT COUNT(*)
1058: FROM ego_item_people_intf
1059: WHERE data_set_id = cp_data_set_id
1060: AND process_status = G_PS_IN_PROCESS;
1061:
1062: l_token_tbl_none Error_Handler.Token_Tbl_Type;

Line 1148: UPDATE ego_item_people_intf

1144: ,p_grant_guid => l_grant_guid
1145: ,x_success => l_success
1146: ,x_errorcode => l_return_status
1147: );
1148: UPDATE ego_item_people_intf
1149: SET process_status = G_PS_SUCCESS
1150: WHERE CURRENT OF c_get_ipi_records;
1151: ELSE
1152: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN

Line 1168: UPDATE ego_item_people_intf

1164: , p_entity_index => NULL
1165: , p_entity_code => G_ERROR_ENTITY_CODE
1166: );
1167: END IF;
1168: UPDATE ego_item_people_intf
1169: SET process_status = G_PS_ERROR
1170: WHERE CURRENT OF c_get_ipi_records;
1171: END IF; -- c_get_delete_grantid
1172: CLOSE c_get_delete_grantid;

Line 1194: UPDATE ego_item_people_intf

1190: ,x_return_status => l_return_status
1191: );
1192: IF l_return_status = G_UPDATE_REC_DONE THEN
1193: -- record successfully updated
1194: UPDATE ego_item_people_intf
1195: SET process_status = G_PS_SUCCESS
1196: WHERE CURRENT OF c_get_ipi_records;
1197: ELSIF l_return_status = G_UPDATE_REC_NOT_FOUND THEN
1198: -- no record found for overlap

Line 1199: UPDATE ego_item_people_intf

1195: SET process_status = G_PS_SUCCESS
1196: WHERE CURRENT OF c_get_ipi_records;
1197: ELSIF l_return_status = G_UPDATE_REC_NOT_FOUND THEN
1198: -- no record found for overlap
1199: UPDATE ego_item_people_intf
1200: SET process_status = G_PS_ERROR
1201: WHERE CURRENT OF c_get_ipi_records;
1202: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN
1203: -- overlap will occur if update is done

Line 1204: UPDATE ego_item_people_intf

1200: SET process_status = G_PS_ERROR
1201: WHERE CURRENT OF c_get_ipi_records;
1202: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN
1203: -- overlap will occur if update is done
1204: UPDATE ego_item_people_intf
1205: SET process_status = G_PS_ERROR
1206: WHERE CURRENT OF c_get_ipi_records;
1207: END IF;
1208:

Line 1231: UPDATE ego_item_people_intf

1227: );
1228: IF l_return_status = G_UPDATE_REC_DONE THEN
1229: -- record successfully updated
1230: -- 4669015 setting successful status to 'UPDATE'/'CREATE'
1231: UPDATE ego_item_people_intf
1232: SET process_status = G_PS_SUCCESS,
1233: transaction_type = 'UPDATE'
1234: WHERE CURRENT OF c_get_ipi_records;
1235: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN

Line 1237: UPDATE ego_item_people_intf

1233: transaction_type = 'UPDATE'
1234: WHERE CURRENT OF c_get_ipi_records;
1235: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN
1236: -- overlap will occur if update is done
1237: UPDATE ego_item_people_intf
1238: SET process_status = G_PS_ERROR
1239: WHERE CURRENT OF c_get_ipi_records;
1240: ELSIF l_return_status = G_UPDATE_REC_NOT_FOUND THEN
1241: -- no record found for overlap

Line 1263: UPDATE ego_item_people_intf

1259: );
1260: IF l_return_status = G_INSERT_REC_DONE THEN
1261: -- record successfully inserted
1262: -- 4669015 setting successful status to 'UPDATE'/'CREATE'
1263: UPDATE ego_item_people_intf
1264: SET process_status = G_PS_SUCCESS,
1265: transaction_type = 'CREATE'
1266: WHERE CURRENT OF c_get_ipi_records;
1267: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN

Line 1269: UPDATE ego_item_people_intf

1265: transaction_type = 'CREATE'
1266: WHERE CURRENT OF c_get_ipi_records;
1267: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN
1268: -- insert overlap error
1269: UPDATE ego_item_people_intf
1270: SET process_status = G_PS_ERROR
1271: WHERE CURRENT OF c_get_ipi_records;
1272: END IF;
1273: END IF;

Line 1298: UPDATE ego_item_people_intf

1294: ,x_return_status => l_return_status
1295: );
1296: IF l_return_status = G_INSERT_REC_DONE THEN
1297: -- record successfully inserted
1298: UPDATE ego_item_people_intf
1299: SET process_status = G_PS_SUCCESS
1300: WHERE CURRENT OF c_get_ipi_records;
1301: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN
1302: -- insert overlap error

Line 1303: UPDATE ego_item_people_intf

1299: SET process_status = G_PS_SUCCESS
1300: WHERE CURRENT OF c_get_ipi_records;
1301: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN
1302: -- insert overlap error
1303: UPDATE ego_item_people_intf
1304: SET process_status = G_PS_ERROR
1305: WHERE CURRENT OF c_get_ipi_records;
1306: END IF;
1307:

Line 1485: FROM ego_item_people_intf

1481: WHERE user_id = cp_user_id;
1482:
1483: CURSOR c_count_ipi_lines (cp_data_set_id IN NUMBER) IS
1484: SELECT COUNT(*)
1485: FROM ego_item_people_intf
1486: WHERE data_set_id = cp_data_set_id
1487: AND process_status = G_PS_TO_BE_PROCESSED;
1488:
1489: CURSOR c_get_trans_id_limits (cp_data_set_id IN NUMBER) IS

Line 1491: FROM ego_item_people_intf

1487: AND process_status = G_PS_TO_BE_PROCESSED;
1488:
1489: CURSOR c_get_trans_id_limits (cp_data_set_id IN NUMBER) IS
1490: SELECT MIN(transaction_id), MAX(transaction_id)
1491: FROM ego_item_people_intf
1492: WHERE data_set_id = cp_data_set_id
1493: AND process_status = G_PS_IN_PROCESS;
1494:
1495: CURSOR c_err_mand_params IS

Line 1497: FROM ego_item_people_intf

1493: AND process_status = G_PS_IN_PROCESS;
1494:
1495: CURSOR c_err_mand_params IS
1496: SELECT transaction_id
1497: FROM ego_item_people_intf
1498: WHERE data_set_id = G_DATA_SET_ID
1499: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1500: AND process_status = G_PS_IN_PROCESS
1501: AND request_id = G_REQUEST_ID

Line 1514: FROM ego_item_people_intf

1510: FOR UPDATE OF transaction_id;
1511:
1512: CURSOR c_err_dates IS
1513: SELECT transaction_id
1514: FROM ego_item_people_intf
1515: WHERE data_set_id = G_DATA_SET_ID
1516: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1517: AND process_status = G_PS_IN_PROCESS
1518: AND request_id = G_REQUEST_ID

Line 1527: FROM ego_item_people_intf

1523: -- Select records to flag missing or invalid Transaction_Types
1524: --
1525: CURSOR c_err_transaction_type IS
1526: SELECT transaction_id, transaction_type
1527: FROM ego_item_people_intf
1528: WHERE data_set_id = G_DATA_SET_ID
1529: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1530: AND process_status = G_PS_IN_PROCESS
1531: AND request_id = G_REQUEST_ID

Line 1540: FROM ego_item_people_intf

1536: -- Select records with missing/invalid grantee type
1537: --
1538: CURSOR c_err_grantee_type IS
1539: SELECT transaction_id, grantee_type
1540: FROM ego_item_people_intf
1541: WHERE data_set_id = G_DATA_SET_ID
1542: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1543: AND process_status = G_PS_IN_PROCESS
1544: AND request_id = G_REQUEST_ID

Line 1553: FROM ego_item_people_intf

1549: -- Select records to flag missing or invalid grantee_party_id
1550: --
1551: CURSOR c_err_grantee_id IS
1552: SELECT transaction_id, grantee_party_id, grantee_name, grantee_type
1553: FROM ego_item_people_intf
1554: WHERE data_set_id = G_DATA_SET_ID
1555: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1556: AND process_status = G_PS_IN_PROCESS
1557: AND request_id = G_REQUEST_ID

Line 1566: FROM ego_item_people_intf

1562: -- Select records to flag missing or invalid role_id
1563: --
1564: CURSOR c_err_role_id IS
1565: SELECT transaction_id, internal_role_id, display_role_name, internal_role_name
1566: FROM ego_item_people_intf
1567: WHERE data_set_id = G_DATA_SET_ID
1568: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1569: AND process_status = G_PS_IN_PROCESS
1570: AND request_id = G_REQUEST_ID

Line 1581: -- FROM ego_item_people_intf

1577:
1578: -- bug 4628705
1579: -- CURSOR c_err_org_id IS
1580: -- SELECT transaction_id, organization_id, organization_code
1581: -- FROM ego_item_people_intf
1582: -- WHERE data_set_id = G_DATA_SET_ID
1583: -- AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1584: -- AND process_status = G_PS_IN_PROCESS
1585: -- AND organization_id IS NULL

Line 1594: -- FROM ego_item_people_intf

1590: -- -- Select records for valid item numbers
1591: -- --
1592: -- CURSOR c_get_item_number IS
1593: -- SELECT transaction_id, inventory_item_id, item_number, organization_id, organization_code
1594: -- FROM ego_item_people_intf
1595: -- WHERE data_set_id = G_DATA_SET_ID
1596: -- AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1597: -- AND process_status = G_PS_IN_PROCESS
1598: -- AND organization_id IS NOT NULL

Line 1618: -- FROM ego_item_people_intf

1614:
1615: -- bug 4628705
1616: -- CURSOR c_err_item_id IS
1617: -- SELECT transaction_id, item_number, inventory_item_id, organization_code
1618: -- FROM ego_item_people_intf
1619: -- WHERE data_set_id = G_DATA_SET_ID
1620: -- AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1621: -- AND process_status = G_INT_ITEM_VAL_ERROR
1622: -- AND process_status = G_PS_IN_PROCESS

Line 1630: FROM ego_item_people_intf

1626: -- bug 4628705
1627: CURSOR c_err_records IS
1628: SELECT transaction_id, item_number, inventory_item_id,
1629: organization_code, organization_id
1630: FROM ego_item_people_intf
1631: WHERE data_set_id = G_DATA_SET_ID
1632: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1633: AND request_id = G_REQUEST_ID
1634: AND process_status IN (G_INT_ORG_VAL_ERROR, G_INT_ITEM_VAL_ERROR);

Line 1641: FROM ego_item_people_intf

1637: -- Select records to flag where user does not have privilege
1638: --
1639: CURSOR c_err_access_items IS
1640: SELECT transaction_id, item_number, organization_code
1641: FROM ego_item_people_intf
1642: WHERE data_set_id = G_DATA_SET_ID
1643: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1644: AND process_status = G_PS_ERROR
1645: AND request_id = G_REQUEST_ID

Line 1671: l_transaction_id ego_item_people_intf.transaction_id%TYPE;

1667: l_transaction_id_min NUMBER;
1668: l_transaction_id_max NUMBER;
1669:
1670: l_column_name VARCHAR2(99);
1671: l_transaction_id ego_item_people_intf.transaction_id%TYPE;
1672: l_msg_name VARCHAR2(99);
1673: l_msg_text VARCHAR2(999) := NULL;
1674: l_msg_type VARCHAR2(10) := 'E';
1675: l_sysdate DATE;

Line 1804: UPDATE ego_item_people_intf

1800: -- setting up the records for processing
1801: -----------------------------------------------------------------------
1802: Write_Debug('Setting the Start Date to SysDate if NULL.');
1803: l_sysdate := SYSDATE;
1804: UPDATE ego_item_people_intf
1805: SET creation_date = NVL(creation_date,l_sysdate),
1806: last_update_date = l_sysdate,
1807: last_updated_by = G_USER_ID,
1808: last_update_login = G_LOGIN_ID,

Line 1862: UPDATE ego_item_people_intf

1858: -------------------------------------------------------------------------
1859: -- check for mandatory data to be present before flagging error
1860: -------------------------------------------------------------------------
1861: FOR cr IN c_err_mand_params LOOP
1862: UPDATE ego_item_people_intf
1863: SET process_status = G_PS_ERROR
1864: WHERE CURRENT OF c_err_mand_params;
1865: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1866: l_msg_name := 'EGO_INTF_MAND_PARAM_MISSING';

Line 1892: UPDATE ego_item_people_intf

1888: -------------------------------------------------------------------------
1889: -- check the correct start and end dates in the records
1890: -------------------------------------------------------------------------
1891: FOR cr IN c_err_dates LOOP
1892: UPDATE ego_item_people_intf
1893: SET process_status = G_PS_ERROR
1894: WHERE CURRENT OF c_err_dates;
1895: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1896: l_msg_name := 'EGO_IPI_INVALID_DATES';

Line 1923: UPDATE ego_item_people_intf

1919: -- find the error records with invalid transaction_type
1920: -- valid transaction_types are CREATE, UPDATE, SYNC, DELETE
1921: -------------------------------------------------------------------------
1922: FOR cr IN c_err_transaction_type LOOP
1923: UPDATE ego_item_people_intf
1924: SET process_status = G_PS_ERROR
1925: WHERE CURRENT OF c_err_transaction_type;
1926: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1927: IF ( cr.transaction_type IS NULL ) THEN

Line 1979: UPDATE ego_item_people_intf

1975: -------------------------------------------------------------------------
1976: -- validation for grantee_type and grantee_name combination
1977: -------------------------------------------------------------------------
1978: FOR cr IN c_err_grantee_type LOOP
1979: UPDATE ego_item_people_intf
1980: SET process_status = G_PS_ERROR
1981: WHERE CURRENT OF c_err_grantee_type;
1982: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1983: IF ( cr.grantee_type IS NULL ) THEN

Line 2043: UPDATE ego_item_people_intf eipi

2039:
2040: -------------------------------------------------------------------------
2041: -- Update the grantee_party id column for the people
2042: -------------------------------------------------------------------------
2043: UPDATE ego_item_people_intf eipi
2044: SET (eipi.grantee_party_id) =
2045: ( SELECT person_id
2046: FROM ego_people_v
2047: WHERE UPPER(user_name) = UPPER(eipi.grantee_name)

Line 2061: UPDATE ego_item_people_intf eipi

2057:
2058: -------------------------------------------------------------------------
2059: --Update the grantee_party id column for the groups
2060: -------------------------------------------------------------------------
2061: UPDATE ego_item_people_intf eipi
2062: SET eipi.grantee_party_id =
2063: ( SELECT group_id
2064: FROM ego_groups_v
2065: WHERE group_name = eipi.grantee_name

Line 2080: UPDATE ego_item_people_intf eipi

2076: -------------------------------------------------------------------------
2077: --Update the grantee_party id column for the Companies
2078: --Company can be Enterprise / External Customer / External Supplier
2079: -------------------------------------------------------------------------
2080: UPDATE ego_item_people_intf eipi
2081: SET eipi.grantee_party_id =
2082: ( SELECT company_id
2083: FROM ego_companies_v
2084: WHERE company_name = eipi.grantee_name

Line 2098: UPDATE ego_item_people_intf eipi

2094:
2095: -------------------------------------------------------------------------
2096: --Update the grantee_party id column for the All Users
2097: -------------------------------------------------------------------------
2098: UPDATE ego_item_people_intf eipi
2099: SET eipi.grantee_party_id = G_ALL_USERS_PARTY_ID
2100: WHERE eipi.data_set_id = G_DATA_SET_ID
2101: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2102: AND eipi.process_status = G_PS_IN_PROCESS

Line 2114: UPDATE ego_item_people_intf

2110: -- For missing grantee_party_id, update process_status and log an error.
2111: -- Also, assign transaction_id, request_id
2112: -------------------------------------------------------------------------
2113: FOR cr IN c_err_grantee_id LOOP
2114: UPDATE ego_item_people_intf
2115: SET process_status = G_PS_ERROR
2116: WHERE CURRENT OF c_err_grantee_id;
2117: -------------------------------------------------------------------------
2118: -- Grantee Name check

Line 2182: UPDATE ego_item_people_intf eipi

2178: -- Fix for Bug# 3050477.
2179: -- Reference to EGO_OBJECT_ROLES is removed.
2180: -- bug 4930322 modified the query to avoid full table scans
2181: -------------------------------------------------------------------------
2182: UPDATE ego_item_people_intf eipi
2183: SET (eipi.internal_role_id, eipi.internal_role_name ) =
2184: ( SELECT roles.menu_id internal_role_id,
2185: roles.menu_name internal_role_name
2186: FROM (

Line 2211: UPDATE ego_item_people_intf

2207: -------------------------------------------------------------------------
2208: -- For missing roles, update process_status and log an error.
2209: -------------------------------------------------------------------------
2210: FOR cr IN c_err_role_id LOOP
2211: UPDATE ego_item_people_intf
2212: SET process_status = G_PS_ERROR
2213: WHERE CURRENT OF c_err_role_id;
2214:
2215: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN

Line 2266: UPDATE ego_item_people_intf eipi

2262:
2263: Write_Debug('Updating the Organization Id column in Intf table');
2264: --Update the organization id column
2265:
2266: UPDATE ego_item_people_intf eipi
2267: SET eipi.process_status = G_INT_ORG_VAL_ERROR
2268: WHERE eipi.data_set_id = G_DATA_SET_ID
2269: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2270: AND eipi.process_status = G_PS_IN_PROCESS

Line 2290: UPDATE ego_item_people_intf eipi

2286: )
2287: )
2288: );
2289:
2290: UPDATE ego_item_people_intf eipi
2291: SET organization_code =
2292: ( SELECT mp.organization_code
2293: FROM mtl_parameters mp
2294: WHERE mp.organization_id = eipi.organization_id

Line 2301: UPDATE ego_item_people_intf eipi

2297: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2298: AND eipi.process_status = G_PS_IN_PROCESS
2299: AND eipi.organization_id IS NOT NULL;
2300:
2301: UPDATE ego_item_people_intf eipi
2302: SET organization_id =
2303: ( SELECT mp.organization_id
2304: FROM mtl_parameters mp
2305: WHERE mp.organization_code = eipi.organization_code

Line 2342: -- UPDATE ego_item_people_intf

2338: -- , data_set => cr.organization_id
2339: -- )
2340: -- THEN
2341: -- l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;
2342: -- UPDATE ego_item_people_intf
2343: -- SET inventory_item_id = l_inventory_item_id
2344: -- WHERE CURRENT OF c_get_item_number;
2345: --
2346: -- --------------------------------------------------------------------

Line 2368: -- UPDATE ego_item_people_intf

2364: -- );
2365: -- FETCH c_get_grant_privileges INTO l_inventory_item_id;
2366: -- IF c_get_grant_privileges%NOTFOUND THEN
2367: -- -- the user cannot grant privileges on this item
2368: -- UPDATE ego_item_people_intf
2369: -- SET process_status = G_PS_ERROR
2370: -- WHERE CURRENT OF c_get_item_number;
2371: -- l_msg_name := 'EGO_IPI_CANNOT_GRANT';
2372: -- l_token_tbl_three(1).token_name := 'USER';

Line 2400: -- UPDATE ego_item_people_intf

2396: -- Write_Debug('Erroring out Invalid Item Number records');
2397: -- --
2398: -- -- invalid item number
2399: -- --
2400: -- UPDATE ego_item_people_intf
2401: -- SET process_status = G_PS_ERROR
2402: -- WHERE CURRENT OF c_get_item_number;
2403: -- IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
2404: -- IF ( cr.inventory_item_id IS NULL ) THEN

Line 2451: UPDATE ego_item_people_intf eipi

2447: -- END IF;
2448: -- END LOOP; -- c_get_item_number
2449:
2450: --Update the inventory_item_id column
2451: UPDATE ego_item_people_intf eipi
2452: SET process_status = G_INT_ITEM_VAL_ERROR
2453: WHERE eipi.data_set_id = G_DATA_SET_ID
2454: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2455: AND eipi.process_status = G_PS_IN_PROCESS

Line 2473: UPDATE ego_item_people_intf eipi

2469: AND item.concatenated_segments = eipi.item_number)
2470: )
2471: );
2472:
2473: UPDATE ego_item_people_intf eipi
2474: SET item_number =
2475: (Select concatenated_segments
2476: from mtl_system_items_b_kfv item
2477: where item.organization_id = eipi.organization_id

Line 2484: UPDATE ego_item_people_intf eipi

2480: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2481: AND eipi.process_status = G_PS_IN_PROCESS
2482: AND eipi.inventory_item_id IS NOT NULL;
2483:
2484: UPDATE ego_item_people_intf eipi
2485: SET inventory_item_id =
2486: (Select inventory_item_id
2487: from mtl_system_items_b_kfv item
2488: where item.organization_id = eipi.organization_id

Line 2501: -- UPDATE ego_item_people_intf

2497: --
2498: Write_Debug('Flashing messages for all invalid item records');
2499: FOR cr IN c_err_records LOOP
2500:
2501: -- UPDATE ego_item_people_intf
2502: -- SET process_status = G_PS_ERROR
2503: -- WHERE CURRENT OF c_err_item_id;
2504:
2505: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN

Line 2561: UPDATE ego_item_people_intf eipi

2557: -- mark all item numbers on which privilege is not available
2558: --
2559:
2560: Write_Debug('Checking for access privilege on items to be granted ');
2561: UPDATE ego_item_people_intf eipi
2562: SET process_status = G_PS_ERROR
2563: WHERE eipi.data_set_id = G_DATA_SET_ID
2564: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2565: AND eipi.process_status = G_PS_IN_PROCESS

Line 2610: UPDATE ego_item_people_intf eipi

2606: END IF; -- check for full access on items.
2607: -- bug 3710151 ends
2608:
2609: -- setting all error records to status error
2610: UPDATE ego_item_people_intf eipi
2611: SET eipi.process_status = G_PS_ERROR
2612: WHERE eipi.data_set_id = G_DATA_SET_ID
2613: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2614: AND eipi.process_status IN (G_INT_ITEM_VAL_ERROR

Line 2645: ' FROM EGO_ITEM_PEOPLE_INTF INTF, MTL_INTERFACE_ERRORS MIERR '||

2641: ----------------------------------------------------------------
2642: l_err_msg_sql := 'SELECT INTF.ITEM_NUMBER as ITEM_NUMBER, '||
2643: ' INTF.ORGANIZATION_CODE as ORGANIZATION_CODE, '||
2644: ' MIERR.ERROR_MESSAGE as ERROR_MESSAGE '||
2645: ' FROM EGO_ITEM_PEOPLE_INTF INTF, MTL_INTERFACE_ERRORS MIERR '||
2646: ' WHERE MIERR.TRANSACTION_ID = INTF.TRANSACTION_ID '||
2647: ' AND MIERR.REQUEST_ID = INTF.REQUEST_ID '||
2648: ' AND MIERR.request_id = :1';
2649:

Line 2652: ,p_table_name => 'EGO_ITEM_PEOPLE_INTF'

2648: ' AND MIERR.request_id = :1';
2649:
2650: EGO_ITEM_OPEN_INTERFACE_PVT.Write_Error_into_ConcurrentLog
2651: (p_entity_name => 'EGO_ITEM_PEOPLE'
2652: ,p_table_name => 'EGO_ITEM_PEOPLE_INTF'
2653: ,p_selectQuery => l_err_msg_sql
2654: ,p_request_id => G_REQUEST_ID
2655: ,x_return_status => l_return_status
2656: ,x_msg_count => l_msg_count