DBA Data[Home] [Help]

APPS.ZPB_DC_DISTRIBUTE dependencies on FND_GLOBAL

Line 92: --fnd_global.apps_initialize(1009109,l_resp_id,210);

88: AND responsibility_key IN ('ZPB_CONTROLLER_RESP', 'ZPB_SUPER_CONTROLLER_RESP', 'ZPB_ANALYST_RESP')
89: AND ROWNUM = 1;
90:
91:
92: --fnd_global.apps_initialize(1009109,l_resp_id,210);
93: fnd_global.apps_initialize(l_user_id,l_resp_id,210);
94:
95: l_req_id := FND_REQUEST.SUBMIT_REQUEST ('ZPB',
96: 'ZPB_DC_DATA_DISTRIB_REQ', NULL, NULL, FALSE,

Line 93: fnd_global.apps_initialize(l_user_id,l_resp_id,210);

89: AND ROWNUM = 1;
90:
91:
92: --fnd_global.apps_initialize(1009109,l_resp_id,210);
93: fnd_global.apps_initialize(l_user_id,l_resp_id,210);
94:
95: l_req_id := FND_REQUEST.SUBMIT_REQUEST ('ZPB',
96: 'ZPB_DC_DATA_DISTRIB_REQ', NULL, NULL, FALSE,
97: l_user_id,l_business_area_id);

Line 166: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

162: IS
163: l_api_name CONSTANT VARCHAR2(30) := 'distribute_data_cp';
164: l_api_version CONSTANT NUMBER := 1.0 ;
165: --
166: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
167: l_SID NUMBER;
168: l_serial_no NUMBER;
169: l_sess_user VARCHAR2(200);
170: l_os_user VARCHAR2(200);

Line 272: last_updated_by = fnd_global.user_id,

268: SET conc_request_id = l_conc_request_id,
269: conc_request_start_time = SYSDATE,
270: -- WHO columns
271: last_update_date = SYSDATE,
272: last_updated_by = fnd_global.user_id,
273: last_update_login = fnd_global.LOGIN_ID
274: WHERE user_id = p_user_id
275: AND business_area_id = p_business_area_id;
276:

Line 273: last_update_login = fnd_global.LOGIN_ID

269: conc_request_start_time = SYSDATE,
270: -- WHO columns
271: last_update_date = SYSDATE,
272: last_updated_by = fnd_global.user_id,
273: last_update_login = fnd_global.LOGIN_ID
274: WHERE user_id = p_user_id
275: AND business_area_id = p_business_area_id;
276:
277: COMMIT;

Line 375: last_updated_by = fnd_global.user_id,

371: UPDATE zpb_dc_objects
372: SET view_type = l_currency_view,
373: -- WHO columns
374: last_update_date = SYSDATE,
375: last_updated_by = fnd_global.user_id,
376: last_update_login = fnd_global.LOGIN_ID
377: WHERE template_id = l_template_id
378: AND object_user_id = p_user_id;
379: END IF;

Line 376: last_update_login = fnd_global.LOGIN_ID

372: SET view_type = l_currency_view,
373: -- WHO columns
374: last_update_date = SYSDATE,
375: last_updated_by = fnd_global.user_id,
376: last_update_login = fnd_global.LOGIN_ID
377: WHERE template_id = l_template_id
378: AND object_user_id = p_user_id;
379: END IF;
380: COMMIT;

Line 404: last_updated_by = fnd_global.user_id,

400: SET conc_request_id = NULL,
401: conc_request_start_time = NULL,
402: -- WHO columns
403: last_update_date = SYSDATE,
404: last_updated_by = fnd_global.user_id,
405: last_update_login = fnd_global.LOGIN_ID
406: WHERE user_id = p_user_id
407: AND business_area_id = p_business_area_id;
408:

Line 405: last_update_login = fnd_global.LOGIN_ID

401: conc_request_start_time = NULL,
402: -- WHO columns
403: last_update_date = SYSDATE,
404: last_updated_by = fnd_global.user_id,
405: last_update_login = fnd_global.LOGIN_ID
406: WHERE user_id = p_user_id
407: AND business_area_id = p_business_area_id;
408:
409: END IF;