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_IMPORT_PVT dependencies on FND_GLOBAL

Line 68: WHERE USER_ID = FND_GLOBAL.USER_ID;

64: IF G_PARTY_NAME IS NULL THEN
65: BEGIN
66: SELECT PARTY_ID INTO l_party_id
67: FROM ego_user_v
68: WHERE USER_ID = FND_GLOBAL.USER_ID;
69: EXCEPTION WHEN OTHERS THEN
70: RETURN NULL;
71: END;
72:

Line 92: l_user_id NUMBER := FND_GLOBAL.USER_ID;

88: PROCEDURE Err_null_ssxref_ssid( p_data_set_id IN NUMBER )
89: IS
90: l_msg_text VARCHAR2(4000);
91: l_err_text VARCHAR2(4000);
92: l_user_id NUMBER := FND_GLOBAL.USER_ID;
93: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
94: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
95: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
96: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 93: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

89: IS
90: l_msg_text VARCHAR2(4000);
91: l_err_text VARCHAR2(4000);
92: l_user_id NUMBER := FND_GLOBAL.USER_ID;
93: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
94: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
95: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
96: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
97: dumm_status VARCHAR2(100);

Line 94: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

90: l_msg_text VARCHAR2(4000);
91: l_err_text VARCHAR2(4000);
92: l_user_id NUMBER := FND_GLOBAL.USER_ID;
93: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
94: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
95: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
96: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
97: dumm_status VARCHAR2(100);
98:

Line 95: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

91: l_err_text VARCHAR2(4000);
92: l_user_id NUMBER := FND_GLOBAL.USER_ID;
93: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
94: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
95: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
96: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
97: dumm_status VARCHAR2(100);
98:
99: CURSOR c_ssxref_null_msii IS

Line 96: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

92: l_user_id NUMBER := FND_GLOBAL.USER_ID;
93: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
94: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
95: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
96: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
97: dumm_status VARCHAR2(100);
98:
99: CURSOR c_ssxref_null_msii IS
100: SELECT

Line 3174: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

3170: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE_DESC := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE_DESC;
3171: l_merged_rows( l_mrow_ix ).CONFIRM_STATUS := l_new_rows( i ).CONFIRM_STATUS;
3172: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3173: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3174: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3175: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3176: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3177: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3178: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

Line 3175: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

3171: l_merged_rows( l_mrow_ix ).CONFIRM_STATUS := l_new_rows( i ).CONFIRM_STATUS;
3172: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3173: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3174: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3175: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3176: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3177: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3178: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3179: END IF; --IF l_new_row_idx > 0 THEN

Line 3176: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

3172: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3173: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3174: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3175: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3176: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3177: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3178: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3179: END IF; --IF l_new_row_idx > 0 THEN
3180: EXIT WHEN c_target_rows%NOTFOUND;

Line 3204: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

3200: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE_DESC := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE_DESC;
3201: l_merged_rows( l_mrow_ix ).CONFIRM_STATUS := l_new_rows( i ).CONFIRM_STATUS;
3202: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3203: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3204: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3205: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3206: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3207: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3208: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

Line 3205: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

3201: l_merged_rows( l_mrow_ix ).CONFIRM_STATUS := l_new_rows( i ).CONFIRM_STATUS;
3202: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3203: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3204: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3205: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3206: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3207: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3208: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3209: END IF; --IF l_new_row_idx > 0 THEN

Line 3206: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

3202: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3203: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3204: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3205: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3206: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3207: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3208: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3209: END IF; --IF l_new_row_idx > 0 THEN
3210: l_cur_rank := old_row.RNK;

Line 3851: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

3847: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_ID := l_new_rows( i ).SOURCE_SYSTEM_ID;
3848: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
3849: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3850: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3851: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3852: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3853: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3854: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3855: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

Line 3852: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

3848: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
3849: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3850: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3851: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3852: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3853: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3854: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3855: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3856: END IF; --IF l_new_row_idx > 0 THEN

Line 3853: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

3849: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3850: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3851: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3852: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3853: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3854: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3855: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3856: END IF; --IF l_new_row_idx > 0 THEN
3857: l_cur_rank := l_old_rows( idx ).RNK;

Line 3980: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

3976: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_ID := l_new_rows( i ).SOURCE_SYSTEM_ID;
3977: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
3978: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3979: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3980: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3981: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3982: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3983: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3984: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

Line 3981: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

3977: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
3978: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3979: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3980: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3981: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3982: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3983: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3984: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3985: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN

Line 3982: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

3978: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3979: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3980: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3981: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3982: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3983: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3984: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3985: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN
3986: END LOOP; -- loop over old rows

Line 4122: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

4118: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_ID := l_new_rows( i ).SOURCE_SYSTEM_ID;
4119: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
4120: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4121: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4122: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4123: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4124: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4125: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4126: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

Line 4123: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

4119: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
4120: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4121: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4122: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4123: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4124: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4125: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4126: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4127: END IF; --IF l_new_row_idx > 0 THEN

Line 4124: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

4120: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4121: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4122: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4123: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4124: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4125: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4126: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4127: END IF; --IF l_new_row_idx > 0 THEN
4128: l_cur_rank := l_old_rows( idx ).RNK;

Line 4235: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

4231: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_ID := l_new_rows( i ).SOURCE_SYSTEM_ID;
4232: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
4233: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4234: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4235: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4236: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4237: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4238: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4239: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

Line 4236: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

4232: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
4233: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4234: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4235: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4236: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4237: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4238: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4239: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4240: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN

Line 4237: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

4233: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4234: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4235: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4236: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4237: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4238: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4239: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4240: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN
4241: END LOOP; -- loop over old rows

Line 4399: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

4395: l_merged_rows( l_mrow_ix ).PK5_VALUE := l_new_rows( i ).PK5_VALUE;
4396: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4397: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4398: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4399: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4400: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4401: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4402: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4403: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

Line 4400: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

4396: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4397: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4398: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4399: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4400: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4401: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4402: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4403: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4404: END IF; --IF l_new_row_idx > 0 THEN

Line 4401: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

4397: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4398: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4399: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4400: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4401: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4402: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4403: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4404: END IF; --IF l_new_row_idx > 0 THEN
4405: l_cur_rank := l_old_rows( idx ).RNK;

Line 4559: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

4555: l_merged_rows( l_mrow_ix ).PK5_VALUE := l_new_rows( i ).PK5_VALUE;
4556: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4557: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4558: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4559: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4560: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4561: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4562: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4563: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

Line 4560: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

4556: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4557: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4558: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4559: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4560: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4561: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4562: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4563: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4564: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN

Line 4561: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

4557: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4558: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4559: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4560: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4561: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4562: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4563: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4564: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN
4565: END LOOP; -- loop over old rows

Line 4717: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

4713: l_merged_rows( l_mrow_ix ).DATA_LEVEL_ID := l_new_rows( i ).DATA_LEVEL_ID;
4714: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4715: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4716: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4717: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4718: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4719: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4720: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4721: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

Line 4718: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

4714: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4715: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4716: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4717: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4718: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4719: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4720: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4721: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4722: END IF; --IF l_new_row_idx > 0 THEN

Line 4719: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

4715: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4716: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4717: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4718: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4719: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4720: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4721: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4722: END IF; --IF l_new_row_idx > 0 THEN
4723: l_cur_rank := l_old_rows( idx ).RNK;

Line 4869: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

4865: l_merged_rows( l_mrow_ix ).DATA_LEVEL_ID := l_new_rows( i ).DATA_LEVEL_ID;
4866: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4867: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4868: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4869: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4870: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4871: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4872: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4873: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

Line 4870: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

4866: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4867: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4868: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4869: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4870: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4871: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4872: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4873: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4874: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN

Line 4871: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

4867: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4868: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4869: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4870: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4871: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4872: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4873: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4874: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN
4875: END LOOP; -- loop over old rows

Line 5050: AND intf.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

5046: AND intf.PROCESS_FLAG IN (5,7)
5047: AND intf.GLOBAL_TRADE_ITEM_NUMBER IS NOT NULL
5048: AND c.INVENTORY_ITEM_ID(+) = intf.INVENTORY_ITEM_ID
5049: AND c.UOM_CODE(+) = intf.PRIMARY_UOM_CODE
5050: AND intf.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
5051: AND c.CROSS_REFERENCE_TYPE(+) = 'GTIN';
5052:
5053: l_gtin NUMBER;
5054: l_msg_text VARCHAR2(4000);

Line 5056: l_user_id NUMBER := FND_GLOBAL.USER_ID;

5052:
5053: l_gtin NUMBER;
5054: l_msg_text VARCHAR2(4000);
5055: dumm_status VARCHAR2(100);
5056: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5057: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5058: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5059: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5060: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 5057: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

5053: l_gtin NUMBER;
5054: l_msg_text VARCHAR2(4000);
5055: dumm_status VARCHAR2(100);
5056: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5057: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5058: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5059: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5060: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5061: l_err_text VARCHAR2(4000);

Line 5058: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

5054: l_msg_text VARCHAR2(4000);
5055: dumm_status VARCHAR2(100);
5056: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5057: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5058: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5059: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5060: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5061: l_err_text VARCHAR2(4000);
5062: l_error BOOLEAN;

Line 5059: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

5055: dumm_status VARCHAR2(100);
5056: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5057: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5058: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5059: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5060: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5061: l_err_text VARCHAR2(4000);
5062: l_error BOOLEAN;
5063: l_rowid ROWID;

Line 5060: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5056: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5057: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5058: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5059: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5060: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5061: l_err_text VARCHAR2(4000);
5062: l_error BOOLEAN;
5063: l_rowid ROWID;
5064: l_xref_id NUMBER;

Line 5458: l_user_id NUMBER := FND_GLOBAL.USER_ID;

5454: RETURN BOOLEAN
5455: IS
5456: l_rowid ROWID;
5457: l_xref_id NUMBER;
5458: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5459: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5460: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5461: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5462: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 5459: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

5455: IS
5456: l_rowid ROWID;
5457: l_xref_id NUMBER;
5458: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5459: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5460: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5461: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5462: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5463: l_raise_event BOOLEAN;

Line 5460: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

5456: l_rowid ROWID;
5457: l_xref_id NUMBER;
5458: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5459: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5460: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5461: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5462: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5463: l_raise_event BOOLEAN;
5464: l_msg_data VARCHAR2(4000);

Line 5461: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

5457: l_xref_id NUMBER;
5458: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5459: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5460: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5461: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5462: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5463: l_raise_event BOOLEAN;
5464: l_msg_data VARCHAR2(4000);
5465: l_return_status VARCHAR2(10);

Line 5462: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5458: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5459: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5460: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5461: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5462: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5463: l_raise_event BOOLEAN;
5464: l_msg_data VARCHAR2(4000);
5465: l_return_status VARCHAR2(10);
5466: l_msg_text VARCHAR2(4000);

Line 5575: AND msi.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

5571: WHERE msi.PROCESS_FLAG IN (5, 7)
5572: AND msi.SET_PROCESS_ID = p_data_set_id
5573: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5574: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL
5575: AND msi.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
5576: AND NOT EXISTS (SELECT NULL
5577: FROM MTL_CROSS_REFERENCES_B mcr
5578: WHERE mcr.SOURCE_SYSTEM_ID = msi.SOURCE_SYSTEM_ID
5579: AND mcr.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'

Line 5600: AND msi.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

5596: WHERE msi.PROCESS_FLAG IN (5, 7)
5597: AND msi.SET_PROCESS_ID = p_data_set_id
5598: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5599: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL
5600: AND msi.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
5601: AND mcr.SOURCE_SYSTEM_ID = msi.SOURCE_SYSTEM_ID
5602: AND mcr.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
5603: AND mcr.CROSS_REFERENCE = msi.SOURCE_SYSTEM_REFERENCE
5604: AND mcr.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID

Line 5670: l_user_id NUMBER := FND_GLOBAL.USER_ID;

5666: l_xref_event_name CONSTANT VARCHAR2(100) := 'oracle.apps.ego.item.postXrefChange';
5667: l_ss_id NUMBER;
5668: l_raise_event BOOLEAN;
5669: l_raise_bus_event BOOLEAN;
5670: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5671: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5672: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5673: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5674: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 5671: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

5667: l_ss_id NUMBER;
5668: l_raise_event BOOLEAN;
5669: l_raise_bus_event BOOLEAN;
5670: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5671: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5672: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5673: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5674: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5675: l_msg_data VARCHAR2(4000);

Line 5672: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

5668: l_raise_event BOOLEAN;
5669: l_raise_bus_event BOOLEAN;
5670: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5671: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5672: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5673: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5674: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5675: l_msg_data VARCHAR2(4000);
5676: l_err_text VARCHAR2(4000);

Line 5673: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

5669: l_raise_bus_event BOOLEAN;
5670: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5671: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5672: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5673: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5674: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5675: l_msg_data VARCHAR2(4000);
5676: l_err_text VARCHAR2(4000);
5677: l_return_status VARCHAR2(10);

Line 5674: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5670: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5671: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5672: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5673: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5674: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5675: l_msg_data VARCHAR2(4000);
5676: l_err_text VARCHAR2(4000);
5677: l_return_status VARCHAR2(10);
5678: l_msg_text VARCHAR2(4000);

Line 5717: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

5713: IF l_inventory_item_id IS NOT NULL THEN
5714: UPDATE MTL_CROSS_REFERENCES_TL
5715: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5716: LAST_UPDATE_DATE = SYSDATE,
5717: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5718: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
5719: SOURCE_LANG = USERENV('LANG')
5720: WHERE CROSS_REFERENCE_ID = i.CROSS_REFERENCE_ID
5721: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 5718: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

5714: UPDATE MTL_CROSS_REFERENCES_TL
5715: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5716: LAST_UPDATE_DATE = SYSDATE,
5717: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5718: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
5719: SOURCE_LANG = USERENV('LANG')
5720: WHERE CROSS_REFERENCE_ID = i.CROSS_REFERENCE_ID
5721: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
5722:

Line 5842: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

5838: IF l_inventory_item_id IS NOT NULL THEN
5839: UPDATE MTL_CROSS_REFERENCES_TL
5840: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5841: LAST_UPDATE_DATE = SYSDATE,
5842: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5843: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
5844: SOURCE_LANG = USERENV('LANG')
5845: WHERE CROSS_REFERENCE_ID = i.CROSS_REFERENCE_ID
5846: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 5843: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

5839: UPDATE MTL_CROSS_REFERENCES_TL
5840: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5841: LAST_UPDATE_DATE = SYSDATE,
5842: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5843: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
5844: SOURCE_LANG = USERENV('LANG')
5845: WHERE CROSS_REFERENCE_ID = i.CROSS_REFERENCE_ID
5846: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
5847:

Line 7508: l_user_id NUMBER := FND_GLOBAL.USER_ID;

7504: AND PROCESS_STATUS = 3.475;
7505:
7506: l_msg_text VARCHAR2(4000);
7507: dumm_status VARCHAR2(100);
7508: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7509: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7510: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7511: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7512: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 7509: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

7505:
7506: l_msg_text VARCHAR2(4000);
7507: dumm_status VARCHAR2(100);
7508: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7509: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7510: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7511: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7512: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7513: l_err_text VARCHAR2(4000);

Line 7510: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

7506: l_msg_text VARCHAR2(4000);
7507: dumm_status VARCHAR2(100);
7508: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7509: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7510: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7511: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7512: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7513: l_err_text VARCHAR2(4000);
7514:

Line 7511: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

7507: dumm_status VARCHAR2(100);
7508: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7509: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7510: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7511: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7512: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7513: l_err_text VARCHAR2(4000);
7514:
7515: TYPE ROW_IDS IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 7512: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

7508: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7509: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7510: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7511: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7512: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7513: l_err_text VARCHAR2(4000);
7514:
7515: TYPE ROW_IDS IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
7516: TYPE ROW_IDENTIFIERS IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 7736: l_user_id NUMBER := FND_GLOBAL.USER_ID;

7732: AND PROCESS_STATUS = 3.475;
7733:
7734: l_msg_text VARCHAR2(4000);
7735: dumm_status VARCHAR2(100);
7736: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 7737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

7733:
7734: l_msg_text VARCHAR2(4000);
7735: dumm_status VARCHAR2(100);
7736: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7741: l_err_text VARCHAR2(4000);

Line 7738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

7734: l_msg_text VARCHAR2(4000);
7735: dumm_status VARCHAR2(100);
7736: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7741: l_err_text VARCHAR2(4000);
7742:

Line 7739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

7735: dumm_status VARCHAR2(100);
7736: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7741: l_err_text VARCHAR2(4000);
7742:
7743: TYPE ROW_IDS IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 7740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

7736: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7741: l_err_text VARCHAR2(4000);
7742:
7743: TYPE ROW_IDS IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
7744: TYPE ROW_IDENTIFIERS IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 7912: l_user_id NUMBER := FND_GLOBAL.USER_ID;

7908:
7909:
7910: l_msg_text VARCHAR2(4000);
7911: dumm_status VARCHAR2(100);
7912: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7913: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7914: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7915: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7916: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 7913: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

7909:
7910: l_msg_text VARCHAR2(4000);
7911: dumm_status VARCHAR2(100);
7912: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7913: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7914: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7915: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7916: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7917: l_err_text VARCHAR2(4000);

Line 7914: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

7910: l_msg_text VARCHAR2(4000);
7911: dumm_status VARCHAR2(100);
7912: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7913: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7914: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7915: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7916: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7917: l_err_text VARCHAR2(4000);
7918: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;

Line 7915: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

7911: dumm_status VARCHAR2(100);
7912: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7913: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7914: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7915: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7916: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7917: l_err_text VARCHAR2(4000);
7918: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;
7919: l_org_id EGO_IMPORT_BATCHES_B.ORGANIZATION_ID%TYPE;

Line 7916: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

7912: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7913: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7914: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7915: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7916: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7917: l_err_text VARCHAR2(4000);
7918: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;
7919: l_org_id EGO_IMPORT_BATCHES_B.ORGANIZATION_ID%TYPE;
7920: l_item_id NUMBER;

Line 9377: l_user_id NUMBER := FND_GLOBAL.USER_ID;

9373: IS
9374: l_org_id NUMBER;
9375: l_transaction_id NUMBER;
9376: dumm_status VARCHAR2(100);
9377: l_user_id NUMBER := FND_GLOBAL.USER_ID;
9378: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
9379: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
9380: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9381: l_err_text VARCHAR2(4000);

Line 9378: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

9374: l_org_id NUMBER;
9375: l_transaction_id NUMBER;
9376: dumm_status VARCHAR2(100);
9377: l_user_id NUMBER := FND_GLOBAL.USER_ID;
9378: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
9379: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
9380: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9381: l_err_text VARCHAR2(4000);
9382: BEGIN

Line 9379: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

9375: l_transaction_id NUMBER;
9376: dumm_status VARCHAR2(100);
9377: l_user_id NUMBER := FND_GLOBAL.USER_ID;
9378: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
9379: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
9380: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9381: l_err_text VARCHAR2(4000);
9382: BEGIN
9383: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

Line 9380: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

9376: dumm_status VARCHAR2(100);
9377: l_user_id NUMBER := FND_GLOBAL.USER_ID;
9378: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
9379: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
9380: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9381: l_err_text VARCHAR2(4000);
9382: BEGIN
9383: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9384: SET REQUEST_ID = p_request_id

Line 12314: UPDATE SET LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE,

12310: MERGE INTO EGO_IMPORT_EXCLUDED_SS_ITEMS
12311: USING dual
12312: ON (SOURCE_SYSTEM_ID = p_source_system_id AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference)
12313: WHEN matched THEN
12314: UPDATE SET LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE,
12315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12316: WHEN NOT matched THEN
12317: INSERT VALUES (p_source_system_id, p_source_system_reference, 1, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.LOGIN_ID);
12318: END IF;

Line 12315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

12311: USING dual
12312: ON (SOURCE_SYSTEM_ID = p_source_system_id AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference)
12313: WHEN matched THEN
12314: UPDATE SET LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE,
12315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12316: WHEN NOT matched THEN
12317: INSERT VALUES (p_source_system_id, p_source_system_reference, 1, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.LOGIN_ID);
12318: END IF;
12319:

Line 12317: INSERT VALUES (p_source_system_id, p_source_system_reference, 1, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.LOGIN_ID);

12313: WHEN matched THEN
12314: UPDATE SET LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE,
12315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12316: WHEN NOT matched THEN
12317: INSERT VALUES (p_source_system_id, p_source_system_reference, 1, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.LOGIN_ID);
12318: END IF;
12319:
12320: errmsg := NULL;
12321: retcode := 'S';

Line 12782: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID);

12778: TAG
12779: FROM FND_LOOKUP_VALUES_VL
12780: WHERE LOOKUP_TYPE='EGO_PDH_ENTITY_TYPES'
12781: AND VIEW_APPLICATION_ID = 0
12782: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID);
12783:
12784:
12785: TYPE TABLE_TAG_TYPE IS TABLE OF VARCHAR2(150) INDEX BY VARCHAR2(30);
12786: TYPE TABLE_MEANING_TYPE IS TABLE OF VARCHAR2(80) INDEX BY VARCHAR2(30);