APPS.PSB_WRHR_EXTRACT_PROCESS dependencies on FND_GLOBAL

Line 194: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;

190:
191: DELETE FROM PSB_ERROR_MESSAGES
192: WHERE process_id = p_data_extract_id;
193:
194: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
195: l_userid := FND_GLOBAL.USER_ID;
196:
197: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
198: p_data => l_msg_data );

Line 195: l_userid := FND_GLOBAL.USER_ID;

191: DELETE FROM PSB_ERROR_MESSAGES
192: WHERE process_id = p_data_extract_id;
193:
194: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
195: l_userid := FND_GLOBAL.USER_ID;
196:
197: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
198: p_data => l_msg_data );
199: IF l_msg_count > 0 THEN

Line 220: l_req_id := FND_GLOBAL.CONC_REQUEST_ID;

216: end if;
217:
218: if (l_msg_count > 0) then
219:
220: l_req_id := FND_GLOBAL.CONC_REQUEST_ID;
221:
222: l_rep_req_id := Fnd_Request.Submit_Request
223: (application => 'PSB' ,
224: program => 'PSBRPERR' ,

Line 558: FND_GLOBAL.USER_ID,

554: 'N', -- For Bug: 4248378. Select_flag has to be inserted initially.
555: NULL, --For Bug No:3071201. For every new organization first insert Null status into Psb_Data_Extract_Orgs table.
556: NULL,
557: SYSDATE,
558: FND_GLOBAL.USER_ID,
559: FND_GLOBAL.LOGIN_ID,
560: SYSDATE,
561: FND_GLOBAL.USER_ID
562: FROM PSB_DATA_EXTRACTS de,

Line 559: FND_GLOBAL.LOGIN_ID,

555: NULL, --For Bug No:3071201. For every new organization first insert Null status into Psb_Data_Extract_Orgs table.
556: NULL,
557: SYSDATE,
558: FND_GLOBAL.USER_ID,
559: FND_GLOBAL.LOGIN_ID,
560: SYSDATE,
561: FND_GLOBAL.USER_ID
562: FROM PSB_DATA_EXTRACTS de,
563: PER_ORGANIZATION_UNITS org

Line 561: FND_GLOBAL.USER_ID

557: SYSDATE,
558: FND_GLOBAL.USER_ID,
559: FND_GLOBAL.LOGIN_ID,
560: SYSDATE,
561: FND_GLOBAL.USER_ID
562: FROM PSB_DATA_EXTRACTS de,
563: PER_ORGANIZATION_UNITS org
564: WHERE de.data_extract_id = p_data_extract_id
565: AND de.business_group_id = org.business_group_id

Line 2932: l_req_id := FND_GLOBAL.CONC_REQUEST_ID;

2928: COMMIT WORK;
2929:
2930: if (l_msg_count > 0) then
2931:
2932: l_req_id := FND_GLOBAL.CONC_REQUEST_ID;
2933:
2934: l_rep_req_id := Fnd_Request.Submit_Request
2935: (application => 'PSB' ,
2936: program => 'PSBRPERR' ,

Line 3788: l_last_updated_by := FND_GLOBAL.USER_ID;

3784:
3785: SAVEPOINT create_default_rule_set;
3786:
3787: l_last_update_date := sysdate;
3788: l_last_updated_by := FND_GLOBAL.USER_ID;
3789: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3790: l_creation_date := sysdate;
3791: l_created_by := FND_GLOBAL.USER_ID;
3792:

Line 3789: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3785: SAVEPOINT create_default_rule_set;
3786:
3787: l_last_update_date := sysdate;
3788: l_last_updated_by := FND_GLOBAL.USER_ID;
3789: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3790: l_creation_date := sysdate;
3791: l_created_by := FND_GLOBAL.USER_ID;
3792:
3793: --verify if the rule set name provided by the user already exists

Line 3791: l_created_by := FND_GLOBAL.USER_ID;

3787: l_last_update_date := sysdate;
3788: l_last_updated_by := FND_GLOBAL.USER_ID;
3789: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3790: l_creation_date := sysdate;
3791: l_created_by := FND_GLOBAL.USER_ID;
3792:
3793: --verify if the rule set name provided by the user already exists
3794: SELECT COUNT(1) INTO l_name_already_exist
3795: FROM psb_entity_set