APPS.PSB_WRHR_EXTRACT_PROCESS dependencies on PSB_DATA_EXTRACT_ORGS

Line 473: -- This procedure inserts into psb_data_extract_orgs all organizations

469:
470: End Interface_Purge;
471:
472: -- de by org
473: -- This procedure inserts into psb_data_extract_orgs all organizations
474: -- belonging to a Business Group.
475:
476: PROCEDURE Insert_Organizations
477: ( p_api_version IN NUMBER,

Line 529: -- PSB_DATA_EXTRACT_ORGS table.

525: -- API body
526:
527:
528: -- The following statement will insert the organization details into
529: -- PSB_DATA_EXTRACT_ORGS table.
530: -- This is used to ensure that all the organizations available
531: -- in HR are extracted into PSB_DATA_EXTRACT_ORGS table.
532:
533:

Line 531: -- in HR are extracted into PSB_DATA_EXTRACT_ORGS table.

527:
528: -- The following statement will insert the organization details into
529: -- PSB_DATA_EXTRACT_ORGS table.
530: -- This is used to ensure that all the organizations available
531: -- in HR are extracted into PSB_DATA_EXTRACT_ORGS table.
532:
533:
534: IF (p_data_extract_id IS NOT NULL) THEN
535:

Line 536: INSERT INTO PSB_DATA_EXTRACT_ORGS

532:
533:
534: IF (p_data_extract_id IS NOT NULL) THEN
535:
536: INSERT INTO PSB_DATA_EXTRACT_ORGS
537: (
538: data_extract_id,
539: organization_id,
540: organization_name,

Line 555: NULL, --For Bug No:3071201. For every new organization first insert Null status into Psb_Data_Extract_Orgs table.

551: de.data_extract_id,
552: org.organization_id,
553: org.name,
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,

Line 569: FROM PSB_DATA_EXTRACT_ORGS C

565: AND de.business_group_id = org.business_group_id
566: AND p_as_of_date between date_from and nvl(date_to, p_as_of_date)
567: AND NOT EXISTS (
568: SELECT 1
569: FROM PSB_DATA_EXTRACT_ORGS C
570: WHERE c.data_extract_id = p_data_extract_id
571: AND c.organization_id = org.organization_id);
572: END IF;
573:

Line 3241: UPDATE PSB_DATA_EXTRACT_ORGS

3237: -- de by org
3238:
3239: if l_data_extract_status = 'C' then
3240: if l_extract_by_org = 'Y' then
3241: UPDATE PSB_DATA_EXTRACT_ORGS
3242: set completion_status = 'C',
3243: completion_time = sysdate,
3244: select_flag = 'N'
3245: where data_extract_id = p_data_extract_id

Line 3248: UPDATE PSB_DATA_EXTRACT_ORGS

3244: select_flag = 'N'
3245: where data_extract_id = p_data_extract_id
3246: and select_flag = 'Y' ;
3247: else
3248: UPDATE PSB_DATA_EXTRACT_ORGS
3249: set completion_status = 'C',
3250: completion_time = sysdate,
3251: select_flag = 'N'
3252: where data_extract_id = p_data_extract_id;