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.XDP_AQ_UTILITIES dependencies on FND_GLOBAL

Line 266: last_updated_by = FND_GLOBAL.USER_ID,

262: msgid => lv_MsgID);
263:
264: update XDP_ORDER_HEADERS
265: set
266: last_updated_by = FND_GLOBAL.USER_ID,
267: last_update_date = sysdate,
268: last_update_login = FND_GLOBAL.LOGIN_ID,
269: STATE = 'WAIT',
270: MSGID = lv_MsgID

Line 268: last_update_login = FND_GLOBAL.LOGIN_ID,

264: update XDP_ORDER_HEADERS
265: set
266: last_updated_by = FND_GLOBAL.USER_ID,
267: last_update_date = sysdate,
268: last_update_login = FND_GLOBAL.LOGIN_ID,
269: STATE = 'WAIT',
270: MSGID = lv_MsgID
271: where
272: order_id = p_order_id;

Line 276: last_updated_by = FND_GLOBAL.USER_ID,

272: order_id = p_order_id;
273:
274: update XDP_ORDER_LINE_ITEMS
275: set
276: last_updated_by = FND_GLOBAL.USER_ID,
277: last_update_date = sysdate,
278: last_update_login = FND_GLOBAL.LOGIN_ID,
279: STATE = 'WAIT'
280: where

Line 278: last_update_login = FND_GLOBAL.LOGIN_ID,

274: update XDP_ORDER_LINE_ITEMS
275: set
276: last_updated_by = FND_GLOBAL.USER_ID,
277: last_update_date = sysdate,
278: last_update_login = FND_GLOBAL.LOGIN_ID,
279: STATE = 'WAIT'
280: where
281: order_id = p_order_id and
282: state = 'PREPROCESS';

Line 669: set last_updated_by = FND_GLOBAL.USER_ID,

665: msgid => lv_MsgID);
666:
667:
668: update XDP_ORDER_HEADERS
669: set last_updated_by = FND_GLOBAL.USER_ID,
670: last_update_date = sysdate,
671: last_update_login = FND_GLOBAL.LOGIN_ID,
672: status_code = 'READY',
673: MSGID = lv_MsgID

Line 671: last_update_login = FND_GLOBAL.LOGIN_ID,

667:
668: update XDP_ORDER_HEADERS
669: set last_updated_by = FND_GLOBAL.USER_ID,
670: last_update_date = sysdate,
671: last_update_login = FND_GLOBAL.LOGIN_ID,
672: status_code = 'READY',
673: MSGID = lv_MsgID
674: where order_id = p_order_id;
675:

Line 677: set last_updated_by = FND_GLOBAL.USER_ID,

673: MSGID = lv_MsgID
674: where order_id = p_order_id;
675:
676: update XDP_ORDER_LINE_ITEMS
677: set last_updated_by = FND_GLOBAL.USER_ID,
678: last_update_date = sysdate,
679: last_update_login = FND_GLOBAL.LOGIN_ID,
680: status_code = 'READY'
681: where order_id = p_order_id

Line 679: last_update_login = FND_GLOBAL.LOGIN_ID,

675:
676: update XDP_ORDER_LINE_ITEMS
677: set last_updated_by = FND_GLOBAL.USER_ID,
678: last_update_date = sysdate,
679: last_update_login = FND_GLOBAL.LOGIN_ID,
680: status_code = 'READY'
681: where order_id = p_order_id
682: and status_code = 'STANDBY';
683:

Line 969: set last_updated_by = FND_GLOBAL.USER_ID,

965: payload =>lv_wf_object,
966: msgid => lv_MsgID);
967:
968: update XDP_FULFILL_WORKLIST
969: set last_updated_by = FND_GLOBAL.USER_ID,
970: last_update_date = sysdate,
971: last_update_login = FND_GLOBAL.LOGIN_ID,
972: STATUS_CODE = 'READY',
973: MSGID = lv_MsgID

Line 971: last_update_login = FND_GLOBAL.LOGIN_ID,

967:
968: update XDP_FULFILL_WORKLIST
969: set last_updated_by = FND_GLOBAL.USER_ID,
970: last_update_date = sysdate,
971: last_update_login = FND_GLOBAL.LOGIN_ID,
972: STATUS_CODE = 'READY',
973: MSGID = lv_MsgID
974: where workitem_instance_id = p_wi_instance_id;
975:

Line 1059: set last_updated_by = FND_GLOBAL.USER_ID,

1055: payload => lv_tmp,
1056: msgid => lv_MsgID);
1057:
1058: update XDP_FULFILL_WORKLIST
1059: set last_updated_by = FND_GLOBAL.USER_ID,
1060: last_update_date = sysdate,
1061: last_update_login = FND_GLOBAL.LOGIN_ID,
1062: STATUS_CODE = 'IN PROGRESS'
1063: where workitem_instance_id = lv_wf_object.workitem_instance_id;

Line 1061: last_update_login = FND_GLOBAL.LOGIN_ID,

1057:
1058: update XDP_FULFILL_WORKLIST
1059: set last_updated_by = FND_GLOBAL.USER_ID,
1060: last_update_date = sysdate,
1061: last_update_login = FND_GLOBAL.LOGIN_ID,
1062: STATUS_CODE = 'IN PROGRESS'
1063: where workitem_instance_id = lv_wf_object.workitem_instance_id;
1064:
1065: WF_ENGINE.StartProcess(

Line 1172: -- set last_updated_by = FND_GLOBAL.USER_ID,

1168:
1169: -- Commented out as this initialization is done in Work Item workflow by spusegao on 08/07/01
1170: --
1171: -- update XDP_FULFILL_WORKLIST
1172: -- set last_updated_by = FND_GLOBAL.USER_ID,
1173: -- last_update_date = sysdate,
1174: -- last_update_login = FND_GLOBAL.LOGIN_ID,
1175: -- STATUS_CODE = 'IN PROGRESS'
1176: -- where workitem_instance_id = lv_wf_object.workitem_instance_id;

Line 1174: -- last_update_login = FND_GLOBAL.LOGIN_ID,

1170: --
1171: -- update XDP_FULFILL_WORKLIST
1172: -- set last_updated_by = FND_GLOBAL.USER_ID,
1173: -- last_update_date = sysdate,
1174: -- last_update_login = FND_GLOBAL.LOGIN_ID,
1175: -- STATUS_CODE = 'IN PROGRESS'
1176: -- where workitem_instance_id = lv_wf_object.workitem_instance_id;
1177:
1178: -- Commented out as this evaluation id done in workitem workflow by spusegao on 08/07/01

Line 1268: set last_updated_by = FND_GLOBAL.USER_ID,

1264: payload =>lv_wf_object,
1265: msgid => lv_MsgID);
1266:
1267: update XDP_FA_RUNTIME_LIST
1268: set last_updated_by = FND_GLOBAL.USER_ID,
1269: last_update_date = sysdate,
1270: last_update_login = FND_GLOBAL.LOGIN_ID,
1271: STATUS_CODE = 'READY',
1272: MSGID = lv_MsgID

Line 1270: last_update_login = FND_GLOBAL.LOGIN_ID,

1266:
1267: update XDP_FA_RUNTIME_LIST
1268: set last_updated_by = FND_GLOBAL.USER_ID,
1269: last_update_date = sysdate,
1270: last_update_login = FND_GLOBAL.LOGIN_ID,
1271: STATUS_CODE = 'READY',
1272: MSGID = lv_MsgID
1273: where fa_instance_id = p_fa_instance_id;
1274:

Line 2098: set last_updated_by = FND_GLOBAL.USER_ID,

2094:
2095: p_return_code := 0;
2096: if p_queue_name is not null then
2097: update XDP_dq_configuration
2098: set last_updated_by = FND_GLOBAL.USER_ID,
2099: last_update_date = sysdate,
2100: last_update_login = FND_GLOBAL.LOGIN_ID,
2101: state = 'DISABLED'
2102: where internal_q_name = UPPER(p_queue_name);

Line 2100: last_update_login = FND_GLOBAL.LOGIN_ID,

2096: if p_queue_name is not null then
2097: update XDP_dq_configuration
2098: set last_updated_by = FND_GLOBAL.USER_ID,
2099: last_update_date = sysdate,
2100: last_update_login = FND_GLOBAL.LOGIN_ID,
2101: state = 'DISABLED'
2102: where internal_q_name = UPPER(p_queue_name);
2103: else
2104: FOR lv_rec in lc_q loop

Line 2107: last_updated_by = FND_GLOBAL.USER_ID,

2103: else
2104: FOR lv_rec in lc_q loop
2105: update XDP_dq_configuration
2106: set state = 'DISABLED',
2107: last_updated_by = FND_GLOBAL.USER_ID,
2108: last_update_date = sysdate,
2109: last_update_login = FND_GLOBAL.LOGIN_ID
2110: where rowid = lv_rec.rowid;
2111: COMMIT;

Line 2109: last_update_login = FND_GLOBAL.LOGIN_ID

2105: update XDP_dq_configuration
2106: set state = 'DISABLED',
2107: last_updated_by = FND_GLOBAL.USER_ID,
2108: last_update_date = sysdate,
2109: last_update_login = FND_GLOBAL.LOGIN_ID
2110: where rowid = lv_rec.rowid;
2111: COMMIT;
2112: END LOOP;
2113: end if;

Line 2142: last_updated_by = FND_GLOBAL.USER_ID,

2138: p_return_code := 0;
2139: if p_queue_name is not null then
2140: update XDP_dq_configuration
2141: set state = 'ENABLED',
2142: last_updated_by = FND_GLOBAL.USER_ID,
2143: last_update_date = sysdate,
2144: last_update_login = FND_GLOBAL.LOGIN_ID
2145: where internal_q_name = UPPER(p_queue_name);
2146: else

Line 2144: last_update_login = FND_GLOBAL.LOGIN_ID

2140: update XDP_dq_configuration
2141: set state = 'ENABLED',
2142: last_updated_by = FND_GLOBAL.USER_ID,
2143: last_update_date = sysdate,
2144: last_update_login = FND_GLOBAL.LOGIN_ID
2145: where internal_q_name = UPPER(p_queue_name);
2146: else
2147: FOR lv_rec IN lc_q LOOP
2148: update XDP_dq_configuration

Line 2150: last_updated_by = FND_GLOBAL.USER_ID,

2146: else
2147: FOR lv_rec IN lc_q LOOP
2148: update XDP_dq_configuration
2149: set state = 'ENABLED',
2150: last_updated_by = FND_GLOBAL.USER_ID,
2151: last_update_date = sysdate,
2152: last_update_login = FND_GLOBAL.LOGIN_ID
2153: where rowid = lv_rec.rowid;
2154: COMMIT;

Line 2152: last_update_login = FND_GLOBAL.LOGIN_ID

2148: update XDP_dq_configuration
2149: set state = 'ENABLED',
2150: last_updated_by = FND_GLOBAL.USER_ID,
2151: last_update_date = sysdate,
2152: last_update_login = FND_GLOBAL.LOGIN_ID
2153: where rowid = lv_rec.rowid;
2154: COMMIT;
2155: END LOOP;
2156: end if;

Line 2183: last_updated_by = FND_GLOBAL.USER_ID,

2179: p_return_code := 0;
2180: if p_queue_name is not null then
2181: update XDP_dq_configuration
2182: set state = 'SHUTDOWN',
2183: last_updated_by = FND_GLOBAL.USER_ID,
2184: last_update_date = sysdate,
2185: last_update_login = FND_GLOBAL.LOGIN_ID
2186: where internal_q_name = UPPER(p_queue_name);
2187: else

Line 2185: last_update_login = FND_GLOBAL.LOGIN_ID

2181: update XDP_dq_configuration
2182: set state = 'SHUTDOWN',
2183: last_updated_by = FND_GLOBAL.USER_ID,
2184: last_update_date = sysdate,
2185: last_update_login = FND_GLOBAL.LOGIN_ID
2186: where internal_q_name = UPPER(p_queue_name);
2187: else
2188: FOR lv_rec IN lc_q LOOP
2189: update XDP_dq_configuration

Line 2191: last_updated_by = FND_GLOBAL.USER_ID,

2187: else
2188: FOR lv_rec IN lc_q LOOP
2189: update XDP_dq_configuration
2190: set state = 'SHUTDOWN',
2191: last_updated_by = FND_GLOBAL.USER_ID,
2192: last_update_date = sysdate,
2193: last_update_login = FND_GLOBAL.LOGIN_ID
2194: where rowid = lv_rec.rowid;
2195: COMMIT;

Line 2193: last_update_login = FND_GLOBAL.LOGIN_ID

2189: update XDP_dq_configuration
2190: set state = 'SHUTDOWN',
2191: last_updated_by = FND_GLOBAL.USER_ID,
2192: last_update_date = sysdate,
2193: last_update_login = FND_GLOBAL.LOGIN_ID
2194: where rowid = lv_rec.rowid;
2195: COMMIT;
2196: END LOOP;
2197: end if;

Line 2262: -- FND_GLOBAL.USER_ID,

2258: -- CALLBACK_TEXT ,
2259: -- Q_NAME ,
2260: -- error_ref_id)
2261: -- values(
2262: -- FND_GLOBAL.USER_ID,
2263: -- sysdate,
2264: -- FND_GLOBAL.USER_ID,
2265: -- sysdate,
2266: -- FND_GLOBAL.LOGIN_ID,

Line 2264: -- FND_GLOBAL.USER_ID,

2260: -- error_ref_id)
2261: -- values(
2262: -- FND_GLOBAL.USER_ID,
2263: -- sysdate,
2264: -- FND_GLOBAL.USER_ID,
2265: -- sysdate,
2266: -- FND_GLOBAL.LOGIN_ID,
2267: -- p_MESSAGE_ID ,
2268: -- p_WF_ITEM_TYPE,

Line 2266: -- FND_GLOBAL.LOGIN_ID,

2262: -- FND_GLOBAL.USER_ID,
2263: -- sysdate,
2264: -- FND_GLOBAL.USER_ID,
2265: -- sysdate,
2266: -- FND_GLOBAL.LOGIN_ID,
2267: -- p_MESSAGE_ID ,
2268: -- p_WF_ITEM_TYPE,
2269: -- p_WF_ITEM_KEY,
2270: -- p_CALLER_NAME ,

Line 2364: FND_GLOBAL.USER_ID,

2360: response_long,
2361: response_date,
2362: provisioning_procedure)
2363: VALUES (
2364: FND_GLOBAL.USER_ID,
2365: sysdate,
2366: FND_GLOBAL.USER_ID,
2367: sysdate,
2368: FND_GLOBAL.LOGIN_ID,

Line 2366: FND_GLOBAL.USER_ID,

2362: provisioning_procedure)
2363: VALUES (
2364: FND_GLOBAL.USER_ID,
2365: sysdate,
2366: FND_GLOBAL.USER_ID,
2367: sysdate,
2368: FND_GLOBAL.LOGIN_ID,
2369: FAInstanceID,
2370: XDP_FE_CMD_AUD_TRAILS_S.NEXTVAL,

Line 2368: FND_GLOBAL.LOGIN_ID,

2364: FND_GLOBAL.USER_ID,
2365: sysdate,
2366: FND_GLOBAL.USER_ID,
2367: sysdate,
2368: FND_GLOBAL.LOGIN_ID,
2369: FAInstanceID,
2370: XDP_FE_CMD_AUD_TRAILS_S.NEXTVAL,
2371: l_FeName,
2372: l_FeType,

Line 2468: FND_GLOBAL.USER_ID,

2464: response_long,
2465: response_date,
2466: provisioning_procedure)
2467: VALUES (
2468: FND_GLOBAL.USER_ID,
2469: sysdate,
2470: FND_GLOBAL.USER_ID,
2471: sysdate,
2472: FND_GLOBAL.LOGIN_ID,

Line 2470: FND_GLOBAL.USER_ID,

2466: provisioning_procedure)
2467: VALUES (
2468: FND_GLOBAL.USER_ID,
2469: sysdate,
2470: FND_GLOBAL.USER_ID,
2471: sysdate,
2472: FND_GLOBAL.LOGIN_ID,
2473: FAInstanceID,
2474: XDP_FE_CMD_AUD_TRAILS_S.NEXTVAL,

Line 2472: FND_GLOBAL.LOGIN_ID,

2468: FND_GLOBAL.USER_ID,
2469: sysdate,
2470: FND_GLOBAL.USER_ID,
2471: sysdate,
2472: FND_GLOBAL.LOGIN_ID,
2473: FAInstanceID,
2474: XDP_FE_CMD_AUD_TRAILS_S.NEXTVAL,
2475: l_FeName,
2476: l_FeType,

Line 3838: FND_GLOBAL.USER_ID,

3834: lv_wf_object.WF_ITEM_TYPE,
3835: 'NORMAL',
3836: lv_wf_object.WF_ITEM_KEY,
3837: 'N',
3838: FND_GLOBAL.USER_ID,
3839: sysdate,
3840: FND_GLOBAL.USER_ID,
3841: sysdate,
3842: FND_GLOBAL.LOGIN_ID);

Line 3840: FND_GLOBAL.USER_ID,

3836: lv_wf_object.WF_ITEM_KEY,
3837: 'N',
3838: FND_GLOBAL.USER_ID,
3839: sysdate,
3840: FND_GLOBAL.USER_ID,
3841: sysdate,
3842: FND_GLOBAL.LOGIN_ID);
3843:
3844: l_ReProcessEnqTime := l_ReProcessEnqTime + (1 / (24*60));

Line 3842: FND_GLOBAL.LOGIN_ID);

3838: FND_GLOBAL.USER_ID,
3839: sysdate,
3840: FND_GLOBAL.USER_ID,
3841: sysdate,
3842: FND_GLOBAL.LOGIN_ID);
3843:
3844: l_ReProcessEnqTime := l_ReProcessEnqTime + (1 / (24*60));
3845: END IF ;
3846: