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_CHANGE_PEOPLE_IMPORT_PKG dependencies on ENG_CHANGE_PEOPLE_INTF

Line 40: G_ERROR_TABLE_NAME VARCHAR2(99) := 'ENG_CHANGE_PEOPLE_INTF';

36:
37: -- Message array size
38: G_MAX_MESSAGE_SIZE PLS_INTEGER := 1000;
39:
40: G_ERROR_TABLE_NAME VARCHAR2(99) := 'ENG_CHANGE_PEOPLE_INTF';
41: G_ERROR_ENTITY_CODE VARCHAR2(99) := 'EGO_CHANGE_PEOPLE';
42: G_ERROR_FILE_NAME VARCHAR2(99);
43: G_BO_IDENTIFIER VARCHAR2(99) := 'EGO_CHANGE_PEOPLE';
44: --

Line 62: G_DATA_SET_ID ENG_CHANGE_PEOPLE_INTF.data_set_id%TYPE;

58: G_INSERT_OVERLAP_ERROR NUMBER := -1;
59: --
60: -- variables that will be used across programs
61: --
62: G_DATA_SET_ID ENG_CHANGE_PEOPLE_INTF.data_set_id%TYPE;
63: G_FROM_LINE_NUMBER NUMBER;
64: G_TO_LINE_NUMBER NUMBER;
65: G_TRANSACTION_ID NUMBER;
66: G_DEBUG_MODE PLS_INTEGER;

Line 128: FROM ENG_CHANGE_PEOPLE_INTF

124: BEGIN
125: IF G_DEBUG_MODE = DEBUG_MODE_DEBUG THEN
126: SELECT COUNT(*)
127: INTO l_error_record_count
128: FROM ENG_CHANGE_PEOPLE_INTF
129: WHERE data_set_id = G_DATA_SET_ID
130: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
131: AND process_status = G_PS_ERROR;
132: END IF;

Line 425: -- NO ACTION IS PERFORMED ON eng_change_people_intf

421: -- Pre-reqs : NONE
422: --
423: -- FUNCTION : To check if the required grant can be updated
424: -- and updates fnd_grants if required
425: -- NO ACTION IS PERFORMED ON eng_change_people_intf
426: --
427: -- Parameters:
428: -- IN : NONE
429: --

Line 626: -- NO ACTION IS PERFORMED ON eng_change_people_intf

622: -- Pre-reqs : NONE
623: --
624: -- FUNCTION : To check if the required grant is valid for insert
625: -- and inserts the record into fnd_grants if valid
626: -- NO ACTION IS PERFORMED ON eng_change_people_intf
627: --
628: -- Parameters:
629: -- IN : NONE
630: --

Line 787: FROM eng_change_people_intf

783: 'UPDATE', ORDER_BY_UPDATE,
784: 'SYNC', ORDER_BY_SYNC,
785: 'DELETE', ORDER_BY_DELETE,
786: ORDER_BY_OTHERS) trans_type
787: FROM eng_change_people_intf
788: WHERE data_set_id = G_DATA_SET_ID
789: AND process_status = G_PS_IN_PROCESS
790: ORDER BY trans_type, transaction_id;
791:

Line 899: UPDATE eng_change_people_intf

895: ,p_grant_guid => l_grant_guid
896: ,x_success => l_success
897: ,x_errorcode => l_return_status
898: );
899: UPDATE eng_change_people_intf
900: SET process_status = G_PS_SUCCESS
901: WHERE transaction_id = cr.transaction_id;
902: ELSE
903: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN

Line 919: UPDATE eng_change_people_intf

915: , p_entity_index => NULL
916: , p_entity_code => G_ERROR_ENTITY_CODE
917: );
918: END IF;
919: UPDATE eng_change_people_intf
920: SET process_status = G_PS_ERROR
921: WHERE transaction_id = cr.transaction_id;
922: END IF; -- c_get_delete_grantid
923: CLOSE c_get_delete_grantid;

Line 945: UPDATE eng_change_people_intf

941: ,x_return_status => l_return_status
942: );
943: IF l_return_status = G_UPDATE_REC_DONE THEN
944: -- record successfully updated
945: UPDATE eng_change_people_intf
946: SET process_status = G_PS_SUCCESS
947: WHERE transaction_id = cr.transaction_id;
948: ELSIF l_return_status = G_UPDATE_REC_NOT_FOUND THEN
949: -- no record found for overlap

Line 950: UPDATE eng_change_people_intf

946: SET process_status = G_PS_SUCCESS
947: WHERE transaction_id = cr.transaction_id;
948: ELSIF l_return_status = G_UPDATE_REC_NOT_FOUND THEN
949: -- no record found for overlap
950: UPDATE eng_change_people_intf
951: SET process_status = G_PS_ERROR
952: WHERE transaction_id = cr.transaction_id;
953: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN
954: -- overlap will occur if update is done

Line 955: UPDATE eng_change_people_intf

951: SET process_status = G_PS_ERROR
952: WHERE transaction_id = cr.transaction_id;
953: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN
954: -- overlap will occur if update is done
955: UPDATE eng_change_people_intf
956: SET process_status = G_PS_ERROR
957: WHERE transaction_id = cr.transaction_id;
958: END IF;
959:

Line 981: UPDATE eng_change_people_intf

977: ,x_return_status => l_return_status
978: );
979: IF l_return_status = G_UPDATE_REC_DONE THEN
980: -- record successfully updated
981: UPDATE eng_change_people_intf
982: SET process_status = G_PS_SUCCESS
983: WHERE transaction_id = cr.transaction_id;
984: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN
985: -- overlap will occur if update is done

Line 986: UPDATE eng_change_people_intf

982: SET process_status = G_PS_SUCCESS
983: WHERE transaction_id = cr.transaction_id;
984: ELSIF l_return_status = G_UPDATE_OVERLAP_ERROR THEN
985: -- overlap will occur if update is done
986: UPDATE eng_change_people_intf
987: SET process_status = G_PS_ERROR
988: WHERE transaction_id = cr.transaction_id;
989: ELSIF l_return_status = G_UPDATE_REC_NOT_FOUND THEN
990: -- no record found for overlap

Line 1011: UPDATE eng_change_people_intf

1007: ,x_return_status => l_return_status
1008: );
1009: IF l_return_status = G_INSERT_REC_DONE THEN
1010: -- record successfully inserted
1011: UPDATE eng_change_people_intf
1012: SET process_status = G_PS_SUCCESS
1013: WHERE transaction_id = cr.transaction_id;
1014: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN
1015: -- insert overlap error

Line 1016: UPDATE eng_change_people_intf

1012: SET process_status = G_PS_SUCCESS
1013: WHERE transaction_id = cr.transaction_id;
1014: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN
1015: -- insert overlap error
1016: UPDATE eng_change_people_intf
1017: SET process_status = G_PS_ERROR
1018: WHERE transaction_id = cr.transaction_id;
1019: END IF;
1020: END IF;

Line 1045: UPDATE eng_change_people_intf

1041: ,x_return_status => l_return_status
1042: );
1043: IF l_return_status = G_INSERT_REC_DONE THEN
1044: -- record successfully inserted
1045: UPDATE eng_change_people_intf
1046: SET process_status = G_PS_SUCCESS
1047: WHERE transaction_id = cr.transaction_id;
1048: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN
1049: -- insert overlap error

Line 1050: UPDATE eng_change_people_intf

1046: SET process_status = G_PS_SUCCESS
1047: WHERE transaction_id = cr.transaction_id;
1048: ELSIF l_return_status = G_INSERT_OVERLAP_ERROR THEN
1049: -- insert overlap error
1050: UPDATE eng_change_people_intf
1051: SET process_status = G_PS_ERROR
1052: WHERE transaction_id = cr.transaction_id;
1053: END IF;
1054:

Line 1133: FROM eng_change_people_intf

1129: AND employee.person_id = users.employee_id;
1130:
1131: CURSOR c_count_cpi_lines (cp_data_set_id IN NUMBER) IS
1132: SELECT COUNT(*)
1133: FROM eng_change_people_intf
1134: WHERE data_set_id = cp_data_set_id
1135: AND process_status = G_PS_TO_BE_PROCESSED;
1136:
1137: CURSOR c_get_trans_id_limits (cp_data_set_id IN NUMBER) IS

Line 1139: FROM eng_change_people_intf

1135: AND process_status = G_PS_TO_BE_PROCESSED;
1136:
1137: CURSOR c_get_trans_id_limits (cp_data_set_id IN NUMBER) IS
1138: SELECT MIN(transaction_id), MAX(transaction_id)
1139: FROM eng_change_people_intf
1140: WHERE data_set_id = cp_data_set_id
1141: AND process_status = G_PS_TO_BE_PROCESSED;
1142:
1143: CURSOR c_err_dates IS

Line 1145: FROM eng_change_people_intf

1141: AND process_status = G_PS_TO_BE_PROCESSED;
1142:
1143: CURSOR c_err_dates IS
1144: SELECT transaction_id,start_date,end_date
1145: FROM eng_change_people_intf
1146: WHERE data_set_id = G_DATA_SET_ID
1147: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1148: AND process_status = G_PS_IN_PROCESS
1149: AND start_date > NVL(end_date,(start_date + 1));

Line 1156: FROM eng_change_people_intf

1152: -- Select records to flag missing or invalid Transaction_Types
1153: --
1154: CURSOR c_err_transaction_type IS
1155: SELECT transaction_id, transaction_type
1156: FROM eng_change_people_intf
1157: WHERE data_set_id = G_DATA_SET_ID
1158: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1159: AND process_status = G_PS_IN_PROCESS
1160: AND transaction_type NOT IN ('CREATE', 'UPDATE', 'DELETE', 'SYNC');

Line 1168: FROM eng_change_people_intf

1164: -- Select records with missing/invalid grantee type
1165: --
1166: CURSOR c_err_grantee_type IS
1167: SELECT transaction_id, grantee_type
1168: FROM eng_change_people_intf
1169: WHERE data_set_id = G_DATA_SET_ID
1170: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1171: AND process_status = G_PS_IN_PROCESS
1172: AND (grantee_type IS NULL OR grantee_type NOT IN ('USER', 'GROUP', 'COMPANY', 'GLOBAL'));

Line 1179: FROM eng_change_people_intf

1175: -- Select records to flag missing or invalid grantee_party_id
1176: --
1177: CURSOR c_err_grantee_id IS
1178: SELECT transaction_id, grantee_party_id, grantee_name, grantee_type
1179: FROM eng_change_people_intf
1180: WHERE data_set_id = G_DATA_SET_ID
1181: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1182: AND process_status = G_PS_IN_PROCESS
1183: AND grantee_party_id IS NULL;

Line 1190: FROM eng_change_people_intf

1186: -- Select records to flag missing or invalid role_id
1187: --
1188: CURSOR c_err_role_id IS
1189: SELECT transaction_id, internal_role_id, display_role_name, internal_role_name
1190: FROM eng_change_people_intf
1191: WHERE data_set_id = G_DATA_SET_ID
1192: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1193: AND process_status = G_PS_IN_PROCESS
1194: AND internal_role_id IS NULL;

Line 1201: FROM eng_change_people_intf

1197: -- Select records to flag missing or invalid organization_id
1198: --
1199: CURSOR c_err_org_id IS
1200: SELECT transaction_id, organization_id, organization_code
1201: FROM eng_change_people_intf
1202: WHERE data_set_id = G_DATA_SET_ID
1203: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1204: AND process_status = G_PS_IN_PROCESS
1205: AND organization_id IS NULL;

Line 1215: FROM eng_change_people_intf

1211: -- Updated the cursor to get the valid change_mgmt_type_codes from
1212: -- the ENG_CHANGE_ORDER_TYPES_VL
1213: CURSOR c_err_chg_mgmt_type_code IS
1214: SELECT transaction_id, change_mgmt_type_code
1215: FROM eng_change_people_intf
1216: WHERE data_set_id = G_DATA_SET_ID
1217: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1218: AND process_status = G_PS_IN_PROCESS
1219: AND (change_mgmt_type_code IS NULL OR

Line 1230: FROM eng_change_people_intf

1226: -- Select records for valid change numbers
1227: --
1228: CURSOR c_err_change_id IS
1229: SELECT transaction_id,organization_code,change_mgmt_type_code,change_notice
1230: FROM eng_change_people_intf
1231: WHERE data_set_id = G_DATA_SET_ID
1232: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1233: AND process_status = G_PS_IN_PROCESS
1234: AND change_id IS NULL;

Line 1267: l_transaction_id eng_change_people_intf.transaction_id%TYPE;

1263: l_transaction_id_min PLS_INTEGER;
1264: l_transaction_id_max PLS_INTEGER;
1265:
1266: l_column_name VARCHAR2(99);
1267: l_transaction_id eng_change_people_intf.transaction_id%TYPE;
1268: l_msg_name VARCHAR2(99);
1269: l_msg_text VARCHAR2(999) := NULL;
1270: l_msg_type VARCHAR2(10) := 'E';
1271: l_sysdate DATE;

Line 1454: UPDATE eng_change_people_intf

1450: -- as the first error is reported and the record is flagged as error
1451: --
1452: -- setting up the status for record processing
1453: l_sysdate := SYSDATE;
1454: UPDATE eng_change_people_intf
1455: SET
1456: -- login_user_id = G_USER_ID,
1457: -- login_party_id = l_login_party_id,
1458: creation_date = l_sysdate,

Line 1470: UPDATE eng_change_people_intf

1466: AND transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER;
1467:
1468: -- check the correct start and dates in the records
1469: FOR cr IN c_err_dates LOOP
1470: UPDATE eng_change_people_intf
1471: SET process_status = G_PS_ERROR
1472: WHERE transaction_id = cr.transaction_id;
1473: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1474: l_msg_name := 'ENG_CPI_INVALID_DATES';

Line 1501: UPDATE eng_change_people_intf

1497:
1498: -- find the error records with invalid transaction_type
1499: -- valid transaction_types are CREATE, UPDATE, SYNC, DELETE
1500: FOR cr IN c_err_transaction_type LOOP
1501: UPDATE eng_change_people_intf
1502: SET process_status = G_PS_ERROR
1503: WHERE transaction_id = cr.transaction_id;
1504: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1505: IF ( cr.transaction_type IS NULL ) THEN

Line 1552: UPDATE eng_change_people_intf

1548: --
1549: -- validation for grantee_type and grantee_name combination
1550: --
1551: FOR cr IN c_err_grantee_type LOOP
1552: UPDATE eng_change_people_intf
1553: SET process_status = G_PS_ERROR
1554: WHERE transaction_id = cr.transaction_id;
1555: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1556: IF ( cr.grantee_type IS NULL ) THEN

Line 1603: UPDATE eng_change_people_intf ecpi

1599:
1600: --Update the grantee_party id column for the people
1601: -- Fix to 4925242. Replaced upper(user_name) = upper(ecpi.grantee_name)
1602: -- with user_name = upper(ecpi.grantee_name)
1603: UPDATE eng_change_people_intf ecpi
1604: -- SET (ecpi.grantee_party_id, ecpi.grantee_name) =
1605: -- ( SELECT person_id, person_name
1606: SET (ecpi.grantee_party_id) =
1607: ( SELECT person_id

Line 1620: UPDATE eng_change_people_intf ecpi

1616: AND ecpi.grantee_type IS NOT NULL
1617: AND ecpi.grantee_type = 'USER';
1618:
1619: --Update the grantee_party id column for the groups
1620: UPDATE eng_change_people_intf ecpi
1621: SET ecpi.grantee_party_id =
1622: ( SELECT group_id
1623: FROM ego_groups_v
1624: WHERE upper(group_name) = upper(ecpi.grantee_name)

Line 1635: UPDATE eng_change_people_intf ecpi

1631: AND ecpi.grantee_type = 'GROUP';
1632:
1633: --Update the grantee_party id column for the Companies
1634: --Company can be Enterprise / External Customer / External Supplier
1635: UPDATE eng_change_people_intf ecpi
1636: SET ecpi.grantee_party_id =
1637: ( SELECT company_id
1638: FROM ego_companies_v
1639: WHERE upper(company_name) = upper(ecpi.grantee_name)

Line 1650: UPDATE eng_change_people_intf ecpi

1646: AND ecpi.grantee_type = 'COMPANY';
1647:
1648: --Update the grantee_party id column for the Companies
1649: --Company can be Enterprise / External Customer / External Supplier
1650: UPDATE eng_change_people_intf ecpi
1651: SET ecpi.grantee_party_id = G_ALL_USERS_PARTY_ID
1652: WHERE ecpi.data_set_id = G_DATA_SET_ID
1653: AND ecpi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1654: AND ecpi.process_status = G_PS_IN_PROCESS

Line 1662: UPDATE eng_change_people_intf

1658:
1659: -- For missing grantee_party_id, update process_status and log an error.
1660: -- Also, assign transaction_id, request_id
1661: FOR cr IN c_err_grantee_id LOOP
1662: UPDATE eng_change_people_intf
1663: SET process_status = G_PS_ERROR
1664: WHERE transaction_id = cr.transaction_id;
1665: -- Grantee Name check
1666: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN

Line 1714: UPDATE eng_change_people_intf ecpi

1710: --1) Retrieve and store the Display and Internal Role Names and Role Ids
1711: -- and store in a temp table. This is done by initialise_roles()
1712: --2) Verify the roles from the temporary table.
1713: --
1714: UPDATE eng_change_people_intf ecpi
1715: SET (ecpi.internal_role_id, ecpi.internal_role_name ) =
1716: ( SELECT role.internal_role_id,
1717: role.internal_role_name
1718: FROM eng_change_roles_temp role

Line 1733: UPDATE eng_change_people_intf

1729: );
1730:
1731: -- For missing roles, update process_status and log an error.
1732: FOR cr IN c_err_role_id LOOP
1733: UPDATE eng_change_people_intf
1734: SET process_status = G_PS_ERROR
1735: WHERE transaction_id = cr.transaction_id;
1736: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1737: IF ( cr.display_role_name IS NULL ) THEN

Line 1780: UPDATE eng_change_people_intf ecpi

1776: END IF;
1777: END LOOP; -- c_err_role_id
1778:
1779: --Update the organization id column
1780: UPDATE eng_change_people_intf ecpi
1781: SET ecpi.organization_id =
1782: ( SELECT mp.organization_id
1783: FROM mtl_parameters mp
1784: WHERE mp.organization_code = ecpi.organization_code

Line 1800: UPDATE eng_change_people_intf

1796: -- For missing organization_id, update process_status and log an error.
1797: -- Also, assign transaction_id, request_id
1798:
1799: FOR cr IN c_err_org_id LOOP
1800: UPDATE eng_change_people_intf
1801: SET process_status = G_PS_ERROR
1802: WHERE transaction_id = cr.transaction_id;
1803: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1804: IF ( cr.organization_code IS NULL ) THEN

Line 1857: UPDATE eng_change_people_intf

1853: -- valid change_mgmt_type_codes are available in the ENG_CHANGE_ORDER_TYPES table.
1854: -- Table ENG_CHANGE_MGMT_TYPES has been obsoleted.
1855:
1856: FOR cr IN c_err_chg_mgmt_type_code LOOP
1857: UPDATE eng_change_people_intf
1858: SET process_status = G_PS_ERROR
1859: WHERE transaction_id = cr.transaction_id;
1860: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1861: IF ( cr.change_mgmt_type_code IS NULL ) THEN

Line 1906: UPDATE eng_change_people_intf ecpi

1902: END IF;
1903: END LOOP; -- error Change Mgmt Type Codes
1904:
1905:
1906: UPDATE eng_change_people_intf ecpi
1907: SET ecpi.change_id =
1908: ( SELECT change_id
1909: FROM eng_engineering_changes eec
1910: WHERE ecpi.change_notice = eec.change_notice

Line 1929: UPDATE eng_change_people_intf

1925: -- For missing organization_id, update process_status and log an error.
1926: -- Also, assign transaction_id, request_id
1927:
1928: FOR cr IN c_err_change_id LOOP
1929: UPDATE eng_change_people_intf
1930: SET process_status = G_PS_ERROR
1931: WHERE transaction_id = cr.transaction_id;
1932: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1933: IF ( cr.change_notice IS NULL ) THEN

Line 2086: FROM eng_change_people_intf

2082: DELETE mtl_interface_errors
2083: WHERE table_name = G_ERROR_TABLE_NAME
2084: AND transaction_id IN
2085: ( SELECT transaction_id
2086: FROM eng_change_people_intf
2087: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
2088: AND creation_date <= NVL(p_closed_date, creation_date)
2089: );
2090: DELETE eng_change_people_intf

Line 2090: DELETE eng_change_people_intf

2086: FROM eng_change_people_intf
2087: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
2088: AND creation_date <= NVL(p_closed_date, creation_date)
2089: );
2090: DELETE eng_change_people_intf
2091: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
2092: AND creation_date <= NVL(p_closed_date, creation_date);
2093: ELSIF p_delete_line_type = DELETE_ERROR THEN
2094: --

Line 2101: FROM eng_change_people_intf

2097: DELETE mtl_interface_errors
2098: WHERE table_name = G_ERROR_TABLE_NAME
2099: AND transaction_id IN
2100: ( SELECT transaction_id
2101: FROM eng_change_people_intf
2102: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
2103: AND creation_date <= NVL(p_closed_date, creation_date)
2104: );
2105: DELETE eng_change_people_intf

Line 2105: DELETE eng_change_people_intf

2101: FROM eng_change_people_intf
2102: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
2103: AND creation_date <= NVL(p_closed_date, creation_date)
2104: );
2105: DELETE eng_change_people_intf
2106: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
2107: AND creation_date <= NVL(p_closed_date, creation_date)
2108: AND process_status = G_PS_ERROR;
2109: ELSIF p_delete_line_type = DELETE_SUCCESS THEN

Line 2113: DELETE eng_change_people_intf

2109: ELSIF p_delete_line_type = DELETE_SUCCESS THEN
2110: --
2111: -- delete all success lines
2112: --
2113: DELETE eng_change_people_intf
2114: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
2115: AND creation_date <= NVL(p_closed_date, creation_date)
2116: AND process_status = G_PS_SUCCESS;
2117: END IF;