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 1696: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1692:
1693: --bug 14347548 add for compilation error start
1694: l_msg_text VARCHAR2(4000);
1695: dumm_status VARCHAR2(100);
1696: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1697: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1698: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1699: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1700: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 1697: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

1693: --bug 14347548 add for compilation error start
1694: l_msg_text VARCHAR2(4000);
1695: dumm_status VARCHAR2(100);
1696: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1697: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1698: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1699: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1700: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1701: l_err_text VARCHAR2(4000);

Line 1698: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

1694: l_msg_text VARCHAR2(4000);
1695: dumm_status VARCHAR2(100);
1696: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1697: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1698: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1699: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1700: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1701: l_err_text VARCHAR2(4000);
1702: --bug 14347548 add for compilation error end

Line 1699: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1695: dumm_status VARCHAR2(100);
1696: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1697: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1698: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1699: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1700: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1701: l_err_text VARCHAR2(4000);
1702: --bug 14347548 add for compilation error end
1703:

Line 1700: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1696: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1697: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1698: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1699: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1700: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1701: l_err_text VARCHAR2(4000);
1702: --bug 14347548 add for compilation error end
1703:
1704:

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

3232: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE_DESC := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE_DESC;
3233: l_merged_rows( l_mrow_ix ).CONFIRM_STATUS := l_new_rows( i ).CONFIRM_STATUS;
3234: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3235: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3236: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3237: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3238: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3239: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3240: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

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

3233: l_merged_rows( l_mrow_ix ).CONFIRM_STATUS := l_new_rows( i ).CONFIRM_STATUS;
3234: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3235: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3236: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3237: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3238: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3239: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3240: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3241: END IF; --IF l_new_row_idx > 0 THEN

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

3234: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3235: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3236: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3237: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3238: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3239: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3240: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3241: END IF; --IF l_new_row_idx > 0 THEN
3242: EXIT WHEN c_target_rows%NOTFOUND;

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

3262: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE_DESC := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE_DESC;
3263: l_merged_rows( l_mrow_ix ).CONFIRM_STATUS := l_new_rows( i ).CONFIRM_STATUS;
3264: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3265: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3266: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3267: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3268: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3269: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3270: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

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

3263: l_merged_rows( l_mrow_ix ).CONFIRM_STATUS := l_new_rows( i ).CONFIRM_STATUS;
3264: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3265: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3266: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3267: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3268: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3269: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3270: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3271: END IF; --IF l_new_row_idx > 0 THEN

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

3264: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3265: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3266: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3267: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3268: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3269: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3270: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3271: END IF; --IF l_new_row_idx > 0 THEN
3272: l_cur_rank := old_row.RNK;

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

3909: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_ID := l_new_rows( i ).SOURCE_SYSTEM_ID;
3910: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
3911: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3912: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3913: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3914: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3915: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3916: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3917: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

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

3910: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
3911: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3912: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3913: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3914: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3915: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3916: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3917: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3918: END IF; --IF l_new_row_idx > 0 THEN

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

3911: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
3912: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
3913: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
3914: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
3915: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
3916: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
3917: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
3918: END IF; --IF l_new_row_idx > 0 THEN
3919: l_cur_rank := l_old_rows( idx ).RNK;

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

4038: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_ID := l_new_rows( i ).SOURCE_SYSTEM_ID;
4039: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
4040: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4041: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4042: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4043: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4044: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4045: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4046: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

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

4039: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
4040: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4041: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4042: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4043: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4044: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4045: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4046: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4047: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN

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

4040: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4041: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4042: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4043: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4044: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4045: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4046: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4047: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN
4048: END LOOP; -- loop over old rows

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

4180: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_ID := l_new_rows( i ).SOURCE_SYSTEM_ID;
4181: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
4182: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4183: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4184: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4185: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4186: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4187: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4188: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

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

4181: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
4182: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4183: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4184: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4185: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4186: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4187: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4188: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4189: END IF; --IF l_new_row_idx > 0 THEN

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

4182: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4183: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4184: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4185: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4186: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4187: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4188: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4189: END IF; --IF l_new_row_idx > 0 THEN
4190: l_cur_rank := l_old_rows( idx ).RNK;

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

4293: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_ID := l_new_rows( i ).SOURCE_SYSTEM_ID;
4294: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
4295: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4296: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4297: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4298: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4299: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4300: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4301: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

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

4294: l_merged_rows( l_mrow_ix ).SOURCE_SYSTEM_REFERENCE := l_new_rows( i ).SOURCE_SYSTEM_REFERENCE;
4295: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4296: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4297: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4298: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4299: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4300: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4301: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4302: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN

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

4295: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4296: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4297: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4298: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4299: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4300: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4301: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4302: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN
4303: END LOOP; -- loop over old rows

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

4460: l_merged_rows( l_mrow_ix ).PK5_VALUE := l_new_rows( i ).PK5_VALUE;
4461: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4462: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4463: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4464: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4465: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4466: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4467: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4468: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

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

4461: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4462: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4463: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4464: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4465: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4466: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4467: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4468: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4469: END IF; --IF l_new_row_idx > 0 THEN

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

4462: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4463: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4464: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4465: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4466: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4467: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4468: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4469: END IF; --IF l_new_row_idx > 0 THEN
4470: l_cur_rank := l_old_rows( idx ).RNK;

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

4620: l_merged_rows( l_mrow_ix ).PK5_VALUE := l_new_rows( i ).PK5_VALUE;
4621: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4622: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4623: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4624: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4625: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4626: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4627: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4628: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

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

4621: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4622: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4623: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4624: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4625: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4626: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4627: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4628: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4629: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN

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

4622: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4623: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4624: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4625: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4626: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4627: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4628: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4629: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN
4630: END LOOP; -- loop over old rows

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

4778: l_merged_rows( l_mrow_ix ).DATA_LEVEL_ID := l_new_rows( i ).DATA_LEVEL_ID;
4779: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4780: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4781: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4782: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4783: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4784: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4785: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4786: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

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

4779: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4780: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4781: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4782: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4783: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4784: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4785: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4786: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4787: END IF; --IF l_new_row_idx > 0 THEN

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

4780: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4781: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4782: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4783: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4784: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4785: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4786: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4787: END IF; --IF l_new_row_idx > 0 THEN
4788: l_cur_rank := l_old_rows( idx ).RNK;

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

4930: l_merged_rows( l_mrow_ix ).DATA_LEVEL_ID := l_new_rows( i ).DATA_LEVEL_ID;
4931: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4932: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4933: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4934: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4935: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4936: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4937: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4938: END LOOP; --FOR i IN 1..l_new_row_idx LOOP

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

4931: l_merged_rows( l_mrow_ix ).ROW_IDENTIFIER := l_new_rows( i ).ROW_IDENTIFIER;
4932: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4933: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4934: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4935: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4936: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4937: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4938: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4939: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN

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

4932: l_merged_rows( l_mrow_ix ).CREATED_BY := l_new_rows( i ).CREATED_BY;
4933: l_merged_rows( l_mrow_ix ).LAST_UPDATED_BY := l_new_rows( i ).LAST_UPDATED_BY;
4934: l_merged_rows( l_mrow_ix ).REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
4935: l_merged_rows( l_mrow_ix ).PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
4936: l_merged_rows( l_mrow_ix ).PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
4937: l_merged_rows( l_mrow_ix ).PROGRAM_UPDATE_DATE := SYSDATE;
4938: END LOOP; --FOR i IN 1..l_new_row_idx LOOP
4939: END IF; --IF idx = l_old_rows.LAST AND l_new_row_idx > 0 THEN
4940: END LOOP; -- loop over old rows

Line 5116: AND intf.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

5112: AND intf.PROCESS_FLAG IN (5,7)
5113: AND intf.GLOBAL_TRADE_ITEM_NUMBER IS NOT NULL
5114: AND c.INVENTORY_ITEM_ID(+) = intf.INVENTORY_ITEM_ID
5115: AND c.UOM_CODE(+) = intf.PRIMARY_UOM_CODE
5116: AND intf.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
5117: AND c.CROSS_REFERENCE_TYPE(+) = 'GTIN';
5118:
5119: l_gtin NUMBER;
5120: l_msg_text VARCHAR2(4000);

Line 5122: l_user_id NUMBER := FND_GLOBAL.USER_ID;

5118:
5119: l_gtin NUMBER;
5120: l_msg_text VARCHAR2(4000);
5121: dumm_status VARCHAR2(100);
5122: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5123: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5124: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5125: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5126: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 5123: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

5119: l_gtin NUMBER;
5120: l_msg_text VARCHAR2(4000);
5121: dumm_status VARCHAR2(100);
5122: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5123: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5124: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5125: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5126: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5127: l_err_text VARCHAR2(4000);

Line 5124: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

5120: l_msg_text VARCHAR2(4000);
5121: dumm_status VARCHAR2(100);
5122: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5123: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5124: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5125: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5126: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5127: l_err_text VARCHAR2(4000);
5128: l_error BOOLEAN;

Line 5125: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

5121: dumm_status VARCHAR2(100);
5122: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5123: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5124: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5125: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5126: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5127: l_err_text VARCHAR2(4000);
5128: l_error BOOLEAN;
5129: l_rowid ROWID;

Line 5126: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5122: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5123: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5124: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5125: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5126: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5127: l_err_text VARCHAR2(4000);
5128: l_error BOOLEAN;
5129: l_rowid ROWID;
5130: l_xref_id NUMBER;

Line 5524: l_user_id NUMBER := FND_GLOBAL.USER_ID;

5520: RETURN BOOLEAN
5521: IS
5522: l_rowid ROWID;
5523: l_xref_id NUMBER;
5524: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5525: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5526: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5527: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5528: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 5525: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

5521: IS
5522: l_rowid ROWID;
5523: l_xref_id NUMBER;
5524: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5525: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5526: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5527: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5528: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5529: l_raise_event BOOLEAN;

Line 5526: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

5522: l_rowid ROWID;
5523: l_xref_id NUMBER;
5524: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5525: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5526: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5527: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5528: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5529: l_raise_event BOOLEAN;
5530: l_msg_data VARCHAR2(4000);

Line 5527: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

5523: l_xref_id NUMBER;
5524: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5525: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5526: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5527: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5528: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5529: l_raise_event BOOLEAN;
5530: l_msg_data VARCHAR2(4000);
5531: l_return_status VARCHAR2(10);

Line 5528: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5524: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5525: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5526: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5527: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5528: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5529: l_raise_event BOOLEAN;
5530: l_msg_data VARCHAR2(4000);
5531: l_return_status VARCHAR2(10);
5532: l_msg_text VARCHAR2(4000);

Line 5641: AND msi.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

5637: WHERE msi.PROCESS_FLAG IN (5, 7)
5638: AND msi.SET_PROCESS_ID = p_data_set_id
5639: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5640: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL
5641: AND msi.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
5642: AND NOT EXISTS (SELECT NULL
5643: FROM MTL_CROSS_REFERENCES_B mcr
5644: WHERE mcr.SOURCE_SYSTEM_ID = msi.SOURCE_SYSTEM_ID
5645: AND mcr.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'

Line 5666: AND msi.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

5662: WHERE msi.PROCESS_FLAG IN (5, 7)
5663: AND msi.SET_PROCESS_ID = p_data_set_id
5664: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5665: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL
5666: AND msi.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
5667: AND mcr.SOURCE_SYSTEM_ID = msi.SOURCE_SYSTEM_ID
5668: AND mcr.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
5669: AND mcr.CROSS_REFERENCE = msi.SOURCE_SYSTEM_REFERENCE
5670: AND mcr.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID

Line 5736: l_user_id NUMBER := FND_GLOBAL.USER_ID;

5732: l_xref_event_name CONSTANT VARCHAR2(100) := 'oracle.apps.ego.item.postXrefChange';
5733: l_ss_id NUMBER;
5734: l_raise_event BOOLEAN;
5735: l_raise_bus_event BOOLEAN;
5736: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 5737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

5733: l_ss_id NUMBER;
5734: l_raise_event BOOLEAN;
5735: l_raise_bus_event BOOLEAN;
5736: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5741: l_msg_data VARCHAR2(4000);

Line 5738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

5734: l_raise_event BOOLEAN;
5735: l_raise_bus_event BOOLEAN;
5736: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5741: l_msg_data VARCHAR2(4000);
5742: l_err_text VARCHAR2(4000);

Line 5739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

5735: l_raise_bus_event BOOLEAN;
5736: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5741: l_msg_data VARCHAR2(4000);
5742: l_err_text VARCHAR2(4000);
5743: l_return_status VARCHAR2(10);

Line 5740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5736: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5737: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5738: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5739: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5740: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5741: l_msg_data VARCHAR2(4000);
5742: l_err_text VARCHAR2(4000);
5743: l_return_status VARCHAR2(10);
5744: l_msg_text VARCHAR2(4000);

Line 5783: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

5779: IF l_inventory_item_id IS NOT NULL THEN
5780: UPDATE MTL_CROSS_REFERENCES_TL
5781: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5782: LAST_UPDATE_DATE = SYSDATE,
5783: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5784: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
5785: SOURCE_LANG = USERENV('LANG')
5786: WHERE CROSS_REFERENCE_ID = i.CROSS_REFERENCE_ID
5787: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 5784: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

5780: UPDATE MTL_CROSS_REFERENCES_TL
5781: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5782: LAST_UPDATE_DATE = SYSDATE,
5783: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5784: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
5785: SOURCE_LANG = USERENV('LANG')
5786: WHERE CROSS_REFERENCE_ID = i.CROSS_REFERENCE_ID
5787: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
5788:

Line 5908: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

5904: IF l_inventory_item_id IS NOT NULL THEN
5905: UPDATE MTL_CROSS_REFERENCES_TL
5906: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5907: LAST_UPDATE_DATE = SYSDATE,
5908: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5909: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
5910: SOURCE_LANG = USERENV('LANG')
5911: WHERE CROSS_REFERENCE_ID = i.CROSS_REFERENCE_ID
5912: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 5909: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

5905: UPDATE MTL_CROSS_REFERENCES_TL
5906: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5907: LAST_UPDATE_DATE = SYSDATE,
5908: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5909: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
5910: SOURCE_LANG = USERENV('LANG')
5911: WHERE CROSS_REFERENCE_ID = i.CROSS_REFERENCE_ID
5912: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
5913:

Line 7605: l_user_id NUMBER := FND_GLOBAL.USER_ID;

7601: AND PROCESS_STATUS = 3.475;
7602:
7603: l_msg_text VARCHAR2(4000);
7604: dumm_status VARCHAR2(100);
7605: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7606: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7607: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7608: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7609: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 7606: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

7602:
7603: l_msg_text VARCHAR2(4000);
7604: dumm_status VARCHAR2(100);
7605: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7606: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7607: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7608: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7609: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7610: l_err_text VARCHAR2(4000);

Line 7607: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

7603: l_msg_text VARCHAR2(4000);
7604: dumm_status VARCHAR2(100);
7605: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7606: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7607: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7608: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7609: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7610: l_err_text VARCHAR2(4000);
7611:

Line 7608: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

7604: dumm_status VARCHAR2(100);
7605: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7606: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7607: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7608: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7609: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7610: l_err_text VARCHAR2(4000);
7611:
7612: TYPE ROW_IDS IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 7609: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

7605: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7606: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7607: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7608: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7609: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7610: l_err_text VARCHAR2(4000);
7611:
7612: TYPE ROW_IDS IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
7613: TYPE ROW_IDENTIFIERS IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 7837: l_user_id NUMBER := FND_GLOBAL.USER_ID;

7833: AND PROCESS_STATUS = 3.475;
7834:
7835: l_msg_text VARCHAR2(4000);
7836: dumm_status VARCHAR2(100);
7837: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7838: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7839: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7840: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7841: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 7838: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

7834:
7835: l_msg_text VARCHAR2(4000);
7836: dumm_status VARCHAR2(100);
7837: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7838: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7839: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7840: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7841: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7842: l_err_text VARCHAR2(4000);

Line 7839: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

7835: l_msg_text VARCHAR2(4000);
7836: dumm_status VARCHAR2(100);
7837: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7838: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7839: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7840: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7841: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7842: l_err_text VARCHAR2(4000);
7843:

Line 7840: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

7836: dumm_status VARCHAR2(100);
7837: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7838: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7839: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7840: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7841: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7842: l_err_text VARCHAR2(4000);
7843:
7844: TYPE ROW_IDS IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 7841: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

7837: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7838: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7839: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
7840: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
7841: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7842: l_err_text VARCHAR2(4000);
7843:
7844: TYPE ROW_IDS IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
7845: TYPE ROW_IDENTIFIERS IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 8014: l_user_id NUMBER := FND_GLOBAL.USER_ID;

8010:
8011:
8012: l_msg_text VARCHAR2(4000);
8013: dumm_status VARCHAR2(100);
8014: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8015: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8016: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
8017: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
8018: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 8015: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

8011:
8012: l_msg_text VARCHAR2(4000);
8013: dumm_status VARCHAR2(100);
8014: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8015: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8016: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
8017: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
8018: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
8019: l_err_text VARCHAR2(4000);

Line 8016: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

8012: l_msg_text VARCHAR2(4000);
8013: dumm_status VARCHAR2(100);
8014: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8015: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8016: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
8017: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
8018: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
8019: l_err_text VARCHAR2(4000);
8020: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;

Line 8017: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

8013: dumm_status VARCHAR2(100);
8014: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8015: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8016: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
8017: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
8018: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
8019: l_err_text VARCHAR2(4000);
8020: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;
8021: l_org_id EGO_IMPORT_BATCHES_B.ORGANIZATION_ID%TYPE;

Line 8018: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

8014: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8015: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8016: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
8017: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
8018: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
8019: l_err_text VARCHAR2(4000);
8020: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;
8021: l_org_id EGO_IMPORT_BATCHES_B.ORGANIZATION_ID%TYPE;
8022: l_item_id NUMBER;

Line 9480: l_user_id NUMBER := FND_GLOBAL.USER_ID;

9476: IS
9477: l_org_id NUMBER;
9478: l_transaction_id NUMBER;
9479: dumm_status VARCHAR2(100);
9480: l_user_id NUMBER := FND_GLOBAL.USER_ID;
9481: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
9482: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
9483: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9484: l_err_text VARCHAR2(4000);

Line 9481: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

9477: l_org_id NUMBER;
9478: l_transaction_id NUMBER;
9479: dumm_status VARCHAR2(100);
9480: l_user_id NUMBER := FND_GLOBAL.USER_ID;
9481: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
9482: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
9483: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9484: l_err_text VARCHAR2(4000);
9485: BEGIN

Line 9482: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

9478: l_transaction_id NUMBER;
9479: dumm_status VARCHAR2(100);
9480: l_user_id NUMBER := FND_GLOBAL.USER_ID;
9481: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
9482: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
9483: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9484: l_err_text VARCHAR2(4000);
9485: BEGIN
9486: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

Line 9483: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

9479: dumm_status VARCHAR2(100);
9480: l_user_id NUMBER := FND_GLOBAL.USER_ID;
9481: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
9482: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
9483: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9484: l_err_text VARCHAR2(4000);
9485: BEGIN
9486: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9487: SET REQUEST_ID = p_request_id

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

12430: MERGE INTO EGO_IMPORT_EXCLUDED_SS_ITEMS
12431: USING dual
12432: ON (SOURCE_SYSTEM_ID = p_source_system_id AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference)
12433: WHEN matched THEN
12434: UPDATE SET LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE,
12435: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12436: WHEN NOT matched THEN
12437: 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);
12438: END IF;

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

12431: USING dual
12432: ON (SOURCE_SYSTEM_ID = p_source_system_id AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference)
12433: WHEN matched THEN
12434: UPDATE SET LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE,
12435: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12436: WHEN NOT matched THEN
12437: 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);
12438: END IF;
12439:

Line 12437: 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);

12433: WHEN matched THEN
12434: UPDATE SET LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE,
12435: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12436: WHEN NOT matched THEN
12437: 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);
12438: END IF;
12439:
12440: errmsg := NULL;
12441: retcode := 'S';

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

12898: TAG
12899: FROM FND_LOOKUP_VALUES_VL
12900: WHERE LOOKUP_TYPE='EGO_PDH_ENTITY_TYPES'
12901: AND VIEW_APPLICATION_ID = 0
12902: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID);
12903:
12904:
12905: TYPE TABLE_TAG_TYPE IS TABLE OF VARCHAR2(150) INDEX BY VARCHAR2(30);
12906: TYPE TABLE_MEANING_TYPE IS TABLE OF VARCHAR2(80) INDEX BY VARCHAR2(30);