DBA Data[Home] [Help]

APPS.XDP_ORDER_SYNC dependencies on FND_GLOBAL

Line 34: last_updated_by = fnd_global.user_id,

30: UPDATE xdp_order_headers
31: SET status_code = p_status ,
32: completion_date = sysdate ,
33: last_update_date = sysdate,
34: last_updated_by = fnd_global.user_id,
35: last_update_login = fnd_global.login_id
36: WHERE order_id = p_order_id ;
37: ELSE
38: UPDATE xdp_order_headers

Line 35: last_update_login = fnd_global.login_id

31: SET status_code = p_status ,
32: completion_date = sysdate ,
33: last_update_date = sysdate,
34: last_updated_by = fnd_global.user_id,
35: last_update_login = fnd_global.login_id
36: WHERE order_id = p_order_id ;
37: ELSE
38: UPDATE xdp_order_headers
39: SET status_code = p_status ,

Line 41: last_updated_by = fnd_global.user_id,

37: ELSE
38: UPDATE xdp_order_headers
39: SET status_code = p_status ,
40: last_update_date = sysdate,
41: last_updated_by = fnd_global.user_id,
42: last_update_login = fnd_global.login_id
43: WHERE order_id = p_order_id ;
44:
45: END IF ;

Line 42: last_update_login = fnd_global.login_id

38: UPDATE xdp_order_headers
39: SET status_code = p_status ,
40: last_update_date = sysdate,
41: last_updated_by = fnd_global.user_id,
42: last_update_login = fnd_global.login_id
43: WHERE order_id = p_order_id ;
44:
45: END IF ;
46:

Line 65: last_updated_by = fnd_global.user_id,

61:
62: UPDATE xdp_order_line_items
63: SET status_code = p_status ,
64: last_update_date = sysdate,
65: last_updated_by = fnd_global.user_id,
66: last_update_login = fnd_global.login_id
67: WHERE line_item_id = p_line_item_id ;
68: ELSE
69: UPDATE xdp_order_line_items

Line 66: last_update_login = fnd_global.login_id

62: UPDATE xdp_order_line_items
63: SET status_code = p_status ,
64: last_update_date = sysdate,
65: last_updated_by = fnd_global.user_id,
66: last_update_login = fnd_global.login_id
67: WHERE line_item_id = p_line_item_id ;
68: ELSE
69: UPDATE xdp_order_line_items
70: SET status_code = p_status ,

Line 73: last_updated_by = fnd_global.user_id,

69: UPDATE xdp_order_line_items
70: SET status_code = p_status ,
71: completion_date = sysdate ,
72: last_update_date = sysdate,
73: last_updated_by = fnd_global.user_id,
74: last_update_login = fnd_global.login_id
75: WHERE line_item_id = p_line_item_id ;
76: END IF ;
77:

Line 74: last_update_login = fnd_global.login_id

70: SET status_code = p_status ,
71: completion_date = sysdate ,
72: last_update_date = sysdate,
73: last_updated_by = fnd_global.user_id,
74: last_update_login = fnd_global.login_id
75: WHERE line_item_id = p_line_item_id ;
76: END IF ;
77:
78:

Line 97: last_updated_by = fnd_global.user_id,

93:
94: UPDATE xdp_fulfill_worklist
95: SET status_code = p_status ,
96: last_update_date = sysdate,
97: last_updated_by = fnd_global.user_id,
98: last_update_login = fnd_global.login_id
99: WHERE workitem_instance_id = p_workitem_instance_id ;
100: ELSE
101: UPDATE xdp_fulfill_worklist

Line 98: last_update_login = fnd_global.login_id

94: UPDATE xdp_fulfill_worklist
95: SET status_code = p_status ,
96: last_update_date = sysdate,
97: last_updated_by = fnd_global.user_id,
98: last_update_login = fnd_global.login_id
99: WHERE workitem_instance_id = p_workitem_instance_id ;
100: ELSE
101: UPDATE xdp_fulfill_worklist
102: SET status_code = p_status ,

Line 105: last_updated_by = fnd_global.user_id,

101: UPDATE xdp_fulfill_worklist
102: SET status_code = p_status ,
103: completion_date = sysdate ,
104: last_update_date = sysdate,
105: last_updated_by = fnd_global.user_id,
106: last_update_login = fnd_global.login_id
107: WHERE workitem_instance_id = p_workitem_instance_id ;
108: END IF ;
109:

Line 106: last_update_login = fnd_global.login_id

102: SET status_code = p_status ,
103: completion_date = sysdate ,
104: last_update_date = sysdate,
105: last_updated_by = fnd_global.user_id,
106: last_update_login = fnd_global.login_id
107: WHERE workitem_instance_id = p_workitem_instance_id ;
108: END IF ;
109:
110:

Line 128: last_updated_by = fnd_global.user_id,

124:
125: UPDATE xdp_fa_runtime_list
126: SET status_code = p_status ,
127: last_update_date = sysdate,
128: last_updated_by = fnd_global.user_id,
129: last_update_login = fnd_global.login_id
130: WHERE fa_instance_id = p_fa_instance_id ;
131: ELSE
132: UPDATE xdp_fa_runtime_list

Line 129: last_update_login = fnd_global.login_id

125: UPDATE xdp_fa_runtime_list
126: SET status_code = p_status ,
127: last_update_date = sysdate,
128: last_updated_by = fnd_global.user_id,
129: last_update_login = fnd_global.login_id
130: WHERE fa_instance_id = p_fa_instance_id ;
131: ELSE
132: UPDATE xdp_fa_runtime_list
133: SET status_code = p_status ,

Line 136: last_updated_by = fnd_global.user_id,

132: UPDATE xdp_fa_runtime_list
133: SET status_code = p_status ,
134: completion_date = sysdate ,
135: last_update_date = sysdate,
136: last_updated_by = fnd_global.user_id,
137: last_update_login = fnd_global.login_id
138: WHERE fa_instance_id = p_fa_instance_id ;
139:
140: END IF ;

Line 137: last_update_login = fnd_global.login_id

133: SET status_code = p_status ,
134: completion_date = sysdate ,
135: last_update_date = sysdate,
136: last_updated_by = fnd_global.user_id,
137: last_update_login = fnd_global.login_id
138: WHERE fa_instance_id = p_fa_instance_id ;
139:
140: END IF ;
141:

Line 510: LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

506:
507: UPDATE XDP_FULFILL_WORKLIST
508: SET WF_ITEM_TYPE = lv_user_item_type,
509: WF_ITEM_KEY = lv_user_item_key,
510: LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
511: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
512: WHERE WORKITEM_INSTANCE_ID = p_workitem_instance_id;
513:
514: --Start the process

Line 511: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

507: UPDATE XDP_FULFILL_WORKLIST
508: SET WF_ITEM_TYPE = lv_user_item_type,
509: WF_ITEM_KEY = lv_user_item_key,
510: LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
511: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
512: WHERE WORKITEM_INSTANCE_ID = p_workitem_instance_id;
513:
514: --Start the process
515: WF_ENGINE.StartProcess(lv_user_item_type,lv_user_item_key);

Line 557: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

553: update XDP_FULFILL_WORKLIST
554: set WF_ITEM_TYPE = lv_user_item_type,
555: WF_ITEM_KEY = lv_user_item_key,
556: LAST_UPDATE_DATE = sysdate,
557: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
558: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
559: where
560: WORKITEM_INSTANCE_ID = p_workitem_instance_id;
561: -- Start the process

Line 558: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

554: set WF_ITEM_TYPE = lv_user_item_type,
555: WF_ITEM_KEY = lv_user_item_key,
556: LAST_UPDATE_DATE = sysdate,
557: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
558: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
559: where
560: WORKITEM_INSTANCE_ID = p_workitem_instance_id;
561: -- Start the process
562: WF_ENGINE.StartProcess(lv_user_item_type,wf_engine.eng_synch);