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
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 ,
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 ;
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:
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
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 ,
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:
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:
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
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 ,
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:
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:
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
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 ,
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 ;
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:
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
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);
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
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);