DBA Data[Home] [Help]

APPS.POS_SUPP_PUB_RAISE_EVENT_PKG dependencies on FND_GLOBAL

Line 162: l_user_id NUMBER := fnd_global.user_id;

158: x_actions_request_id OUT NOCOPY NUMBER,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2) IS
162: l_user_id NUMBER := fnd_global.user_id;
163: l_last_update_login NUMBER := fnd_global.login_id;
164: l_vendor_id NUMBER := 0;
165: l_actions_request_id NUMBER;
166: l_party_id_cs_1 VARCHAR(32767) := '';

Line 163: l_last_update_login NUMBER := fnd_global.login_id;

159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2) IS
162: l_user_id NUMBER := fnd_global.user_id;
163: l_last_update_login NUMBER := fnd_global.login_id;
164: l_vendor_id NUMBER := 0;
165: l_actions_request_id NUMBER;
166: l_party_id_cs_1 VARCHAR(32767) := '';
167: l_party_id_cs_2 VARCHAR(32767) := '';

Line 225: l_user_id NUMBER := fnd_global.user_id;

221: x_msg_data OUT NOCOPY VARCHAR2) IS
222: l_event_key NUMBER := NULL;
223: l_msg_data Varchar2(30000) := null;
224: l_msg_count NUMBER :=0;
225: l_user_id NUMBER := fnd_global.user_id;
226: l_last_update_login NUMBER := fnd_global.login_id;
227: BEGIN
228:
229: FOR i IN p_publication_event_id.first .. p_publication_event_id.last LOOP

Line 226: l_last_update_login NUMBER := fnd_global.login_id;

222: l_event_key NUMBER := NULL;
223: l_msg_data Varchar2(30000) := null;
224: l_msg_count NUMBER :=0;
225: l_user_id NUMBER := fnd_global.user_id;
226: l_last_update_login NUMBER := fnd_global.login_id;
227: BEGIN
228:
229: FOR i IN p_publication_event_id.first .. p_publication_event_id.last LOOP
230: -- Raising the Workflow event for already published events

Line 269: l_user_id NUMBER := fnd_global.user_id;

265: p_party_id IN NUMBER,
266: p_target_system IN VARCHAR2,
267: p_pub_req_process_id IN NUMBER,
268: p_pub_req_process_stats IN VARCHAR2) IS
269: l_user_id NUMBER := fnd_global.user_id;
270: l_last_update_login NUMBER := fnd_global.login_id;
271:
272:
273: BEGIN

Line 270: l_last_update_login NUMBER := fnd_global.login_id;

266: p_target_system IN VARCHAR2,
267: p_pub_req_process_id IN NUMBER,
268: p_pub_req_process_stats IN VARCHAR2) IS
269: l_user_id NUMBER := fnd_global.user_id;
270: l_last_update_login NUMBER := fnd_global.login_id;
271:
272:
273: BEGIN
274:

Line 337: l_user_id NUMBER := fnd_global.user_id;

333: p_error_message IN VARCHAR2,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,
336: x_msg_data OUT NOCOPY VARCHAR2) IS
337: l_user_id NUMBER := fnd_global.user_id;
338: l_last_update_login NUMBER := fnd_global.login_id;
339: BEGIN
340:
341: UPDATE pos_supp_pub_responses

Line 338: l_last_update_login NUMBER := fnd_global.login_id;

334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,
336: x_msg_data OUT NOCOPY VARCHAR2) IS
337: l_user_id NUMBER := fnd_global.user_id;
338: l_last_update_login NUMBER := fnd_global.login_id;
339: BEGIN
340:
341: UPDATE pos_supp_pub_responses
342: SET response_process_id = p_pub_resp_process_id,

Line 509: l_user_id NUMBER := fnd_global.user_id;

505: p_published_by IN NUMBER,
506: p_publish_detail IN VARCHAR)
507:
508: IS
509: l_user_id NUMBER := fnd_global.user_id;
510: l_last_update_login NUMBER := fnd_global.login_id;
511: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
512: l_pos_supplier_bo pos_supplier_bo;
513: x_return_status VARCHAR2(1000);

Line 510: l_last_update_login NUMBER := fnd_global.login_id;

506: p_publish_detail IN VARCHAR)
507:
508: IS
509: l_user_id NUMBER := fnd_global.user_id;
510: l_last_update_login NUMBER := fnd_global.login_id;
511: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
512: l_pos_supplier_bo pos_supplier_bo;
513: x_return_status VARCHAR2(1000);
514: x_msg_count NUMBER := 0;

Line 511: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

507:
508: IS
509: l_user_id NUMBER := fnd_global.user_id;
510: l_last_update_login NUMBER := fnd_global.login_id;
511: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
512: l_pos_supplier_bo pos_supplier_bo;
513: x_return_status VARCHAR2(1000);
514: x_msg_count NUMBER := 0;
515: x_msg_data VARCHAR2(1000);