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 99: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;

95: -- Global variables used for Bulk Processing
96: -- =================================================================
97: -- TYPE g_t_grant_guid_table IS TABLE OF fnd_grants.grant_guid%TYPE INDEX BY BINARY_INTEGER;
98: --
99: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
100: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
101: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
102: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
103: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;

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

96: -- =================================================================
97: -- TYPE g_t_grant_guid_table IS TABLE OF fnd_grants.grant_guid%TYPE INDEX BY BINARY_INTEGER;
98: --
99: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
100: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
101: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
102: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
103: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
104: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

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

97: -- TYPE g_t_grant_guid_table IS TABLE OF fnd_grants.grant_guid%TYPE INDEX BY BINARY_INTEGER;
98: --
99: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
100: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
101: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
102: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
103: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
104: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
105: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;

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

98: --
99: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
100: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
101: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
102: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
103: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
104: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
105: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;
106: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;

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

99: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
100: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
101: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
102: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
103: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
104: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
105: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;
106: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;
107: -- TYPE g_t_grantee_key_table IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;

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

100: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
101: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
102: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
103: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
104: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
105: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;
106: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;
107: -- TYPE g_t_grantee_key_table IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
108:

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

101: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;
102: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
103: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
104: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
105: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;
106: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;
107: -- TYPE g_t_grantee_key_table IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
108:
109: ----------------------------------------------------------------------

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

102: -- TYPE g_t_grantee_type_table IS TABLE OF ego_item_people_intf.grantee_type%TYPE INDEX BY BINARY_INTEGER;
103: -- TYPE g_t_grantee_name_table IS TABLE OF ego_item_people_intf.grantee_name%TYPE INDEX BY BINARY_INTEGER;
104: -- TYPE g_t_inventory_item_id_table IS TABLE OF ego_item_people_intf.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
105: -- TYPE g_t_internal_role_id_table IS TABLE OF ego_item_people_intf.internal_role_id%TYPE INDEX BY BINARY_INTEGER;
106: -- TYPE g_t_grantee_party_id_table IS TABLE OF ego_item_people_intf.grantee_party_id%TYPE INDEX BY BINARY_INTEGER;
107: -- TYPE g_t_grantee_key_table IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
108:
109: ----------------------------------------------------------------------
110: -- Global variables used for Parsing process.

Line 341: FROM ego_item_people_intf

337: BEGIN
338: IF G_DEBUG_MODE = DEBUG_MODE_DEBUG THEN
339: SELECT COUNT(*)
340: INTO l_error_record_count
341: FROM ego_item_people_intf
342: WHERE data_set_id = G_DATA_SET_ID
343: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
344: AND process_status = G_PS_ERROR;
345:

Line 807: FROM ego_item_people_intf

803: DELETE mtl_interface_errors
804: WHERE table_name = G_ERROR_TABLE_NAME
805: AND transaction_id IN
806: (SELECT transaction_id
807: FROM ego_item_people_intf
808: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
809: AND creation_date <= NVL(p_closed_date, creation_date)
810: );
811: DELETE ego_item_people_intf

Line 811: DELETE ego_item_people_intf

807: FROM ego_item_people_intf
808: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
809: AND creation_date <= NVL(p_closed_date, creation_date)
810: );
811: DELETE ego_item_people_intf
812: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
813: AND creation_date <= NVL(p_closed_date, creation_date);
814:
815: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ERROR THEN

Line 823: FROM ego_item_people_intf

819: DELETE mtl_interface_errors
820: WHERE table_name = G_ERROR_TABLE_NAME
821: AND transaction_id IN
822: (SELECT transaction_id
823: FROM ego_item_people_intf
824: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
825: AND creation_date <= NVL(p_closed_date, creation_date)
826: );
827: DELETE ego_item_people_intf

Line 827: DELETE ego_item_people_intf

823: FROM ego_item_people_intf
824: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
825: AND creation_date <= NVL(p_closed_date, creation_date)
826: );
827: DELETE ego_item_people_intf
828: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
829: AND creation_date <= NVL(p_closed_date, creation_date)
830: AND process_status = G_PS_ERROR;
831:

Line 836: DELETE ego_item_people_intf

832: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS THEN
833: --
834: -- delete all success lines
835: --
836: DELETE ego_item_people_intf
837: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
838: AND creation_date <= NVL(p_closed_date, creation_date)
839: AND process_status = G_PS_SUCCESS;
840: END IF;

Line 887: -- NO ACTION IS PERFORMED ON ego_item_people_intf

883: -- Pre-reqs : NONE
884: --
885: -- FUNCTION : To check if the required grant can be updated
886: -- and updates fnd_grants if required
887: -- NO ACTION IS PERFORMED ON ego_item_people_intf
888: --
889: -- Parameters:
890: -- IN : NONE
891: --

Line 1098: -- NO ACTION IS PERFORMED ON ego_item_people_intf

1094: -- Pre-reqs : NONE
1095: --
1096: -- FUNCTION : To check if the required grant is valid for insert
1097: -- and inserts the record into fnd_grants if valid
1098: -- NO ACTION IS PERFORMED ON ego_item_people_intf
1099: --
1100: -- Parameters:
1101: -- IN : NONE
1102: --

Line 1264: FROM ego_item_people_intf

1260: 'UPDATE', ORDER_BY_UPDATE,
1261: 'SYNC', ORDER_BY_SYNC,
1262: 'DELETE', ORDER_BY_DELETE,
1263: ORDER_BY_OTHERS) trans_type
1264: FROM ego_item_people_intf
1265: WHERE data_set_id = G_DATA_SET_ID
1266: AND process_status = G_PS_IN_PROCESS
1267: ORDER BY trans_type, transaction_id
1268: FOR UPDATE OF transaction_id;

Line 1301: FROM ego_item_people_intf

1297:
1298: -- 3578536
1299: CURSOR c_count_ipi_lines (cp_data_set_id IN NUMBER) IS
1300: SELECT COUNT(*)
1301: FROM ego_item_people_intf
1302: WHERE data_set_id = cp_data_set_id
1303: AND process_status = G_PS_IN_PROCESS;
1304:
1305: l_token_tbl_none Error_Handler.Token_Tbl_Type;

Line 1391: UPDATE ego_item_people_intf

1387: ,p_grant_guid => l_grant_guid
1388: ,x_success => l_success
1389: ,x_errorcode => l_return_status
1390: );
1391: UPDATE ego_item_people_intf
1392: SET process_status = G_PS_SUCCESS
1393: WHERE CURRENT OF c_get_ipi_records;
1394: ELSE
1395: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN

Line 1411: UPDATE ego_item_people_intf

1407: , p_entity_index => NULL
1408: , p_entity_code => G_ERROR_ENTITY_CODE
1409: );
1410: END IF;
1411: UPDATE ego_item_people_intf
1412: SET process_status = G_PS_ERROR
1413: WHERE CURRENT OF c_get_ipi_records;
1414: END IF; -- c_get_delete_grantid
1415: CLOSE c_get_delete_grantid;

Line 1437: UPDATE ego_item_people_intf

1433: ,x_return_status => l_return_status
1434: );
1435: IF l_return_status = G_UPDATE_REC_DONE THEN
1436: -- record successfully updated
1437: UPDATE ego_item_people_intf
1438: SET process_status = G_PS_SUCCESS
1439: WHERE CURRENT OF c_get_ipi_records;
1440: ELSIF l_return_status = G_UPDATE_REC_NOT_FOUND THEN
1441: -- no record found for overlap

Line 1442: UPDATE ego_item_people_intf

1438: SET process_status = G_PS_SUCCESS
1439: WHERE CURRENT OF c_get_ipi_records;
1440: ELSIF l_return_status = G_UPDATE_REC_NOT_FOUND THEN
1441: -- no record found for overlap
1442: UPDATE ego_item_people_intf
1443: SET process_status = G_PS_ERROR
1444: WHERE CURRENT OF c_get_ipi_records;
1445: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN
1446: -- overlap will occur if update is done

Line 1447: UPDATE ego_item_people_intf

1443: SET process_status = G_PS_ERROR
1444: WHERE CURRENT OF c_get_ipi_records;
1445: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN
1446: -- overlap will occur if update is done
1447: UPDATE ego_item_people_intf
1448: SET process_status = G_PS_ERROR
1449: WHERE CURRENT OF c_get_ipi_records;
1450: END IF;
1451:

Line 1474: UPDATE ego_item_people_intf

1470: );
1471: IF l_return_status = G_UPDATE_REC_DONE THEN
1472: -- record successfully updated
1473: -- 4669015 setting successful status to 'UPDATE'/'CREATE'
1474: UPDATE ego_item_people_intf
1475: SET process_status = G_PS_SUCCESS,
1476: transaction_type = 'UPDATE'
1477: WHERE CURRENT OF c_get_ipi_records;
1478: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN

Line 1480: UPDATE ego_item_people_intf

1476: transaction_type = 'UPDATE'
1477: WHERE CURRENT OF c_get_ipi_records;
1478: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN
1479: -- overlap will occur if update is done
1480: UPDATE ego_item_people_intf
1481: SET process_status = G_PS_ERROR
1482: WHERE CURRENT OF c_get_ipi_records;
1483: ELSIF l_return_status = G_UPDATE_REC_NOT_FOUND THEN
1484: -- no record found for overlap

Line 1506: UPDATE ego_item_people_intf

1502: );
1503: IF l_return_status = G_INSERT_REC_DONE THEN
1504: -- record successfully inserted
1505: -- 4669015 setting successful status to 'UPDATE'/'CREATE'
1506: UPDATE ego_item_people_intf
1507: SET process_status = G_PS_SUCCESS,
1508: transaction_type = 'CREATE'
1509: WHERE CURRENT OF c_get_ipi_records;
1510: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN

Line 1512: UPDATE ego_item_people_intf

1508: transaction_type = 'CREATE'
1509: WHERE CURRENT OF c_get_ipi_records;
1510: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN
1511: -- insert overlap error
1512: UPDATE ego_item_people_intf
1513: SET process_status = G_PS_ERROR
1514: WHERE CURRENT OF c_get_ipi_records;
1515: END IF;
1516: END IF;

Line 1541: UPDATE ego_item_people_intf

1537: ,x_return_status => l_return_status
1538: );
1539: IF l_return_status = G_INSERT_REC_DONE THEN
1540: -- record successfully inserted
1541: UPDATE ego_item_people_intf
1542: SET process_status = G_PS_SUCCESS
1543: WHERE CURRENT OF c_get_ipi_records;
1544: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN
1545: -- insert overlap error

Line 1546: UPDATE ego_item_people_intf

1542: SET process_status = G_PS_SUCCESS
1543: WHERE CURRENT OF c_get_ipi_records;
1544: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN
1545: -- insert overlap error
1546: UPDATE ego_item_people_intf
1547: SET process_status = G_PS_ERROR
1548: WHERE CURRENT OF c_get_ipi_records;
1549: END IF;
1550:

Line 1731: FROM ego_item_people_intf

1727: WHERE user_id = cp_user_id;
1728:
1729: CURSOR c_count_ipi_lines (cp_data_set_id IN NUMBER) IS
1730: SELECT COUNT(*)
1731: FROM ego_item_people_intf
1732: WHERE data_set_id = cp_data_set_id
1733: AND process_status = G_PS_TO_BE_PROCESSED;
1734:
1735: CURSOR c_get_trans_id_limits (cp_data_set_id IN NUMBER) IS

Line 1737: FROM ego_item_people_intf

1733: AND process_status = G_PS_TO_BE_PROCESSED;
1734:
1735: CURSOR c_get_trans_id_limits (cp_data_set_id IN NUMBER) IS
1736: SELECT MIN(transaction_id), MAX(transaction_id)
1737: FROM ego_item_people_intf
1738: WHERE data_set_id = cp_data_set_id
1739: AND process_status = G_PS_IN_PROCESS;
1740:
1741: CURSOR c_err_mand_params IS

Line 1743: FROM ego_item_people_intf

1739: AND process_status = G_PS_IN_PROCESS;
1740:
1741: CURSOR c_err_mand_params IS
1742: SELECT transaction_id
1743: FROM ego_item_people_intf
1744: WHERE data_set_id = G_DATA_SET_ID
1745: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1746: AND process_status = G_PS_IN_PROCESS
1747: AND request_id = G_REQUEST_ID

Line 1760: FROM ego_item_people_intf

1756: FOR UPDATE OF transaction_id;
1757:
1758: CURSOR c_err_dates IS
1759: SELECT transaction_id
1760: FROM ego_item_people_intf
1761: WHERE data_set_id = G_DATA_SET_ID
1762: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1763: AND process_status = G_PS_IN_PROCESS
1764: AND request_id = G_REQUEST_ID

Line 1773: FROM ego_item_people_intf

1769: -- Select records to flag missing or invalid Transaction_Types
1770: --
1771: CURSOR c_err_transaction_type IS
1772: SELECT transaction_id, transaction_type
1773: FROM ego_item_people_intf
1774: WHERE data_set_id = G_DATA_SET_ID
1775: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1776: AND process_status = G_PS_IN_PROCESS
1777: AND request_id = G_REQUEST_ID

Line 1786: FROM ego_item_people_intf

1782: -- Select records with missing/invalid grantee type
1783: --
1784: CURSOR c_err_grantee_type IS
1785: SELECT transaction_id, grantee_type
1786: FROM ego_item_people_intf
1787: WHERE data_set_id = G_DATA_SET_ID
1788: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1789: AND process_status = G_PS_IN_PROCESS
1790: AND request_id = G_REQUEST_ID

Line 1799: FROM ego_item_people_intf

1795: -- Select records to flag missing or invalid grantee_party_id
1796: --
1797: CURSOR c_err_grantee_id IS
1798: SELECT transaction_id, grantee_party_id, grantee_name, grantee_type
1799: FROM ego_item_people_intf
1800: WHERE data_set_id = G_DATA_SET_ID
1801: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1802: AND process_status = G_PS_IN_PROCESS
1803: AND request_id = G_REQUEST_ID

Line 1812: FROM ego_item_people_intf

1808: -- Select records to flag missing or invalid role_id
1809: --
1810: CURSOR c_err_role_id IS
1811: SELECT transaction_id, internal_role_id, display_role_name, internal_role_name
1812: FROM ego_item_people_intf
1813: WHERE data_set_id = G_DATA_SET_ID
1814: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1815: AND process_status = G_PS_IN_PROCESS
1816: AND request_id = G_REQUEST_ID

Line 1827: -- FROM ego_item_people_intf

1823:
1824: -- bug 4628705
1825: -- CURSOR c_err_org_id IS
1826: -- SELECT transaction_id, organization_id, organization_code
1827: -- FROM ego_item_people_intf
1828: -- WHERE data_set_id = G_DATA_SET_ID
1829: -- AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1830: -- AND process_status = G_PS_IN_PROCESS
1831: -- AND organization_id IS NULL

Line 1840: -- FROM ego_item_people_intf

1836: -- -- Select records for valid item numbers
1837: -- --
1838: -- CURSOR c_get_item_number IS
1839: -- SELECT transaction_id, inventory_item_id, item_number, organization_id, organization_code
1840: -- FROM ego_item_people_intf
1841: -- WHERE data_set_id = G_DATA_SET_ID
1842: -- AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1843: -- AND process_status = G_PS_IN_PROCESS
1844: -- AND organization_id IS NOT NULL

Line 1864: -- FROM ego_item_people_intf

1860:
1861: -- bug 4628705
1862: -- CURSOR c_err_item_id IS
1863: -- SELECT transaction_id, item_number, inventory_item_id, organization_code
1864: -- FROM ego_item_people_intf
1865: -- WHERE data_set_id = G_DATA_SET_ID
1866: -- AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1867: -- AND process_status = G_INT_ITEM_VAL_ERROR
1868: -- AND process_status = G_PS_IN_PROCESS

Line 1876: FROM ego_item_people_intf

1872: -- bug 4628705
1873: CURSOR c_err_records IS
1874: SELECT transaction_id, item_number, inventory_item_id,
1875: organization_code, organization_id
1876: FROM ego_item_people_intf
1877: WHERE data_set_id = G_DATA_SET_ID
1878: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1879: AND request_id = G_REQUEST_ID
1880: AND process_status IN (G_INT_ORG_VAL_ERROR, G_INT_ITEM_VAL_ERROR);

Line 1887: FROM ego_item_people_intf

1883: -- Select records to flag where user does not have privilege
1884: --
1885: CURSOR c_err_access_items IS
1886: SELECT transaction_id, item_number, organization_code
1887: FROM ego_item_people_intf
1888: WHERE data_set_id = G_DATA_SET_ID
1889: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1890: AND process_status = G_PS_ERROR
1891: AND request_id = G_REQUEST_ID

Line 1917: l_transaction_id ego_item_people_intf.transaction_id%TYPE;

1913: l_transaction_id_min NUMBER;
1914: l_transaction_id_max NUMBER;
1915:
1916: l_column_name VARCHAR2(99);
1917: l_transaction_id ego_item_people_intf.transaction_id%TYPE;
1918: l_msg_name VARCHAR2(99);
1919: l_msg_text VARCHAR2(999) := NULL;
1920: l_msg_type VARCHAR2(10) := 'E';
1921: l_sysdate DATE;

Line 2076: UPDATE ego_item_people_intf

2072: -- setting up the records for processing
2073: -----------------------------------------------------------------------
2074: Write_Debug('Setting the Start Date to SysDate if NULL.');
2075: l_sysdate := SYSDATE;
2076: UPDATE ego_item_people_intf
2077: SET creation_date = NVL(creation_date,l_sysdate),
2078: last_update_date = l_sysdate,
2079: last_updated_by = G_USER_ID,
2080: last_update_login = G_LOGIN_ID,

Line 2134: UPDATE ego_item_people_intf

2130: -------------------------------------------------------------------------
2131: -- check for mandatory data to be present before flagging error
2132: -------------------------------------------------------------------------
2133: FOR cr IN c_err_mand_params LOOP
2134: UPDATE ego_item_people_intf
2135: SET process_status = G_PS_ERROR
2136: WHERE CURRENT OF c_err_mand_params;
2137: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
2138: l_msg_name := 'EGO_INTF_MAND_PARAM_MISSING';

Line 2164: UPDATE ego_item_people_intf

2160: -------------------------------------------------------------------------
2161: -- check the correct start and end dates in the records
2162: -------------------------------------------------------------------------
2163: FOR cr IN c_err_dates LOOP
2164: UPDATE ego_item_people_intf
2165: SET process_status = G_PS_ERROR
2166: WHERE CURRENT OF c_err_dates;
2167: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
2168: l_msg_name := 'EGO_IPI_INVALID_DATES';

Line 2195: UPDATE ego_item_people_intf

2191: -- find the error records with invalid transaction_type
2192: -- valid transaction_types are CREATE, UPDATE, SYNC, DELETE
2193: -------------------------------------------------------------------------
2194: FOR cr IN c_err_transaction_type LOOP
2195: UPDATE ego_item_people_intf
2196: SET process_status = G_PS_ERROR
2197: WHERE CURRENT OF c_err_transaction_type;
2198: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
2199: IF ( cr.transaction_type IS NULL ) THEN

Line 2251: UPDATE ego_item_people_intf

2247: -------------------------------------------------------------------------
2248: -- validation for grantee_type and grantee_name combination
2249: -------------------------------------------------------------------------
2250: FOR cr IN c_err_grantee_type LOOP
2251: UPDATE ego_item_people_intf
2252: SET process_status = G_PS_ERROR
2253: WHERE CURRENT OF c_err_grantee_type;
2254: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
2255: IF ( cr.grantee_type IS NULL ) THEN

Line 2315: UPDATE ego_item_people_intf eipi

2311:
2312: -------------------------------------------------------------------------
2313: -- Update the grantee_party id column for the people
2314: -------------------------------------------------------------------------
2315: UPDATE ego_item_people_intf eipi
2316: SET (eipi.grantee_party_id) =
2317: ( SELECT person_id
2318: FROM ego_people_v
2319: WHERE UPPER(user_name) = UPPER(eipi.grantee_name)

Line 2333: UPDATE ego_item_people_intf eipi

2329:
2330: -------------------------------------------------------------------------
2331: --Update the grantee_party id column for the groups
2332: -------------------------------------------------------------------------
2333: UPDATE ego_item_people_intf eipi
2334: SET eipi.grantee_party_id =
2335: ( SELECT group_id
2336: FROM ego_groups_v
2337: WHERE group_name = eipi.grantee_name

Line 2352: UPDATE ego_item_people_intf eipi

2348: -------------------------------------------------------------------------
2349: --Update the grantee_party id column for the Companies
2350: --Company can be Enterprise / External Customer / External Supplier
2351: -------------------------------------------------------------------------
2352: UPDATE ego_item_people_intf eipi
2353: SET eipi.grantee_party_id =
2354: ( SELECT company_id
2355: FROM ego_companies_v
2356: WHERE company_name = eipi.grantee_name

Line 2370: UPDATE ego_item_people_intf eipi

2366:
2367: -------------------------------------------------------------------------
2368: --Update the grantee_party id column for the All Users
2369: -------------------------------------------------------------------------
2370: UPDATE ego_item_people_intf eipi
2371: SET eipi.grantee_party_id = G_ALL_USERS_PARTY_ID
2372: WHERE eipi.data_set_id = G_DATA_SET_ID
2373: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2374: AND eipi.process_status = G_PS_IN_PROCESS

Line 2386: UPDATE ego_item_people_intf

2382: -- For missing grantee_party_id, update process_status and log an error.
2383: -- Also, assign transaction_id, request_id
2384: -------------------------------------------------------------------------
2385: FOR cr IN c_err_grantee_id LOOP
2386: UPDATE ego_item_people_intf
2387: SET process_status = G_PS_ERROR
2388: WHERE CURRENT OF c_err_grantee_id;
2389: -------------------------------------------------------------------------
2390: -- Grantee Name check

Line 2454: UPDATE ego_item_people_intf eipi

2450: -- Fix for Bug# 3050477.
2451: -- Reference to EGO_OBJECT_ROLES is removed.
2452: -- bug 4930322 modified the query to avoid full table scans
2453: -------------------------------------------------------------------------
2454: UPDATE ego_item_people_intf eipi
2455: SET (eipi.internal_role_id, eipi.internal_role_name ) =
2456: ( SELECT roles.menu_id internal_role_id,
2457: roles.menu_name internal_role_name
2458: FROM (

Line 2483: UPDATE ego_item_people_intf

2479: -------------------------------------------------------------------------
2480: -- For missing roles, update process_status and log an error.
2481: -------------------------------------------------------------------------
2482: FOR cr IN c_err_role_id LOOP
2483: UPDATE ego_item_people_intf
2484: SET process_status = G_PS_ERROR
2485: WHERE CURRENT OF c_err_role_id;
2486:
2487: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN

Line 2538: UPDATE ego_item_people_intf eipi

2534:
2535: Write_Debug('Updating the Organization Id column in Intf table');
2536: --Update the organization id column
2537:
2538: UPDATE ego_item_people_intf eipi
2539: SET eipi.process_status = G_INT_ORG_VAL_ERROR
2540: WHERE eipi.data_set_id = G_DATA_SET_ID
2541: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2542: AND eipi.process_status = G_PS_IN_PROCESS

Line 2562: UPDATE ego_item_people_intf eipi

2558: )
2559: )
2560: );
2561:
2562: UPDATE ego_item_people_intf eipi
2563: SET organization_code =
2564: ( SELECT mp.organization_code
2565: FROM mtl_parameters mp
2566: WHERE mp.organization_id = eipi.organization_id

Line 2573: UPDATE ego_item_people_intf eipi

2569: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2570: AND eipi.process_status = G_PS_IN_PROCESS
2571: AND eipi.organization_id IS NOT NULL;
2572:
2573: UPDATE ego_item_people_intf eipi
2574: SET organization_id =
2575: ( SELECT mp.organization_id
2576: FROM mtl_parameters mp
2577: WHERE mp.organization_code = eipi.organization_code

Line 2614: -- UPDATE ego_item_people_intf

2610: -- , data_set => cr.organization_id
2611: -- )
2612: -- THEN
2613: -- l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;
2614: -- UPDATE ego_item_people_intf
2615: -- SET inventory_item_id = l_inventory_item_id
2616: -- WHERE CURRENT OF c_get_item_number;
2617: --
2618: -- --------------------------------------------------------------------

Line 2640: -- UPDATE ego_item_people_intf

2636: -- );
2637: -- FETCH c_get_grant_privileges INTO l_inventory_item_id;
2638: -- IF c_get_grant_privileges%NOTFOUND THEN
2639: -- -- the user cannot grant privileges on this item
2640: -- UPDATE ego_item_people_intf
2641: -- SET process_status = G_PS_ERROR
2642: -- WHERE CURRENT OF c_get_item_number;
2643: -- l_msg_name := 'EGO_IPI_CANNOT_GRANT';
2644: -- l_token_tbl_three(1).token_name := 'USER';

Line 2672: -- UPDATE ego_item_people_intf

2668: -- Write_Debug('Erroring out Invalid Item Number records');
2669: -- --
2670: -- -- invalid item number
2671: -- --
2672: -- UPDATE ego_item_people_intf
2673: -- SET process_status = G_PS_ERROR
2674: -- WHERE CURRENT OF c_get_item_number;
2675: -- IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
2676: -- IF ( cr.inventory_item_id IS NULL ) THEN

Line 2723: UPDATE ego_item_people_intf eipi

2719: -- END IF;
2720: -- END LOOP; -- c_get_item_number
2721:
2722: --Update the inventory_item_id column
2723: UPDATE ego_item_people_intf eipi
2724: SET process_status = G_INT_ITEM_VAL_ERROR
2725: WHERE eipi.data_set_id = G_DATA_SET_ID
2726: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2727: AND eipi.process_status = G_PS_IN_PROCESS

Line 2745: UPDATE ego_item_people_intf eipi

2741: AND item.concatenated_segments = eipi.item_number)
2742: )
2743: );
2744:
2745: UPDATE ego_item_people_intf eipi
2746: SET item_number =
2747: (Select concatenated_segments
2748: from mtl_system_items_b_kfv item
2749: where item.organization_id = eipi.organization_id

Line 2756: UPDATE ego_item_people_intf eipi

2752: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2753: AND eipi.process_status = G_PS_IN_PROCESS
2754: AND eipi.inventory_item_id IS NOT NULL;
2755:
2756: UPDATE ego_item_people_intf eipi
2757: SET inventory_item_id =
2758: (Select inventory_item_id
2759: from mtl_system_items_b_kfv item
2760: where item.organization_id = eipi.organization_id

Line 2773: -- UPDATE ego_item_people_intf

2769: --
2770: Write_Debug('Flashing messages for all invalid item records');
2771: FOR cr IN c_err_records LOOP
2772:
2773: -- UPDATE ego_item_people_intf
2774: -- SET process_status = G_PS_ERROR
2775: -- WHERE CURRENT OF c_err_item_id;
2776:
2777: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN

Line 2843: ' UPDATE ego_item_people_intf eipi '

2839: l_company_info := get_company_info (p_party_id => l_orig_system_id);
2840: l_group_info := get_group_info(p_party_id => l_orig_system_id);
2841:
2842: l_update_sql :=
2843: ' UPDATE ego_item_people_intf eipi '
2844: || ' SET process_status = :e' --|| G_PS_ERROR
2845: || ' WHERE eipi.data_set_id = :d' -- || G_DATA_SET_ID
2846: || ' AND eipi.transaction_id BETWEEN :f AND :t' --|| G_FROM_LINE_NUMBER || ' AND ' || G_TO_LINE_NUMBER
2847: || ' AND eipi.process_status = :p' --|| G_PS_IN_PROCESS

Line 2979: UPDATE ego_item_people_intf eipi

2975: END IF; -- check for full access on items.
2976: -- bug 3710151 ends
2977:
2978: -- setting all error records to status error
2979: UPDATE ego_item_people_intf eipi
2980: SET eipi.process_status = G_PS_ERROR
2981: WHERE eipi.data_set_id = G_DATA_SET_ID
2982: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
2983: AND eipi.process_status IN (G_INT_ITEM_VAL_ERROR

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

3010: ----------------------------------------------------------------
3011: l_err_msg_sql := 'SELECT INTF.ITEM_NUMBER as ITEM_NUMBER, '||
3012: ' INTF.ORGANIZATION_CODE as ORGANIZATION_CODE, '||
3013: ' MIERR.ERROR_MESSAGE as ERROR_MESSAGE '||
3014: ' FROM EGO_ITEM_PEOPLE_INTF INTF, MTL_INTERFACE_ERRORS MIERR '||
3015: ' WHERE MIERR.TRANSACTION_ID = INTF.TRANSACTION_ID '||
3016: ' AND MIERR.REQUEST_ID = INTF.REQUEST_ID '||
3017: ' AND MIERR.request_id = :1';
3018:

Line 3021: ,p_table_name => 'EGO_ITEM_PEOPLE_INTF'

3017: ' AND MIERR.request_id = :1';
3018:
3019: EGO_ITEM_OPEN_INTERFACE_PVT.Write_Error_into_ConcurrentLog
3020: (p_entity_name => 'EGO_ITEM_PEOPLE'
3021: ,p_table_name => 'EGO_ITEM_PEOPLE_INTF'
3022: ,p_selectQuery => l_err_msg_sql
3023: ,p_request_id => G_REQUEST_ID
3024: ,x_return_status => l_return_status
3025: ,x_msg_count => l_msg_count