eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_WRHR_EXTRACT_PROCESS dependencies on PSB_DATA_EXTRACTS

Line 112: FROM PSB_DATA_EXTRACTS

108: NVL(COPY_DEFAULTS_STATUS,'I') COPY_DEFAULTS_STATUS,
109: COPY_DEFAULTS_EXTRACT_ID,
110: COPY_SALARY_FLAG,
111: POSITION_ID_FLEX_NUM
112: FROM PSB_DATA_EXTRACTS
113: WHERE data_extract_id = p_data_extract_id;
114:
115: BEGIN
116:

Line 152: Update Psb_Data_Extracts

148:
149: if (C_DataRec.populate_data_flag = 'Y') then
150: if (C_DataRec.populate_data_status <> 'C') then
151:
152: Update Psb_Data_Extracts
153: set data_extract_status = 'I'
154: where data_extract_id = p_data_extract_id;
155:
156: end if;

Line 299: -- from psb_data_extracts

295: -- Commented the following cursor and redefined.
296: --
297: -- Cursor C_Interface is
298: -- Select data_extract_id
299: -- from psb_data_extracts
300: -- where decode(copy_defaults_flag,'Y',copy_defaults_status,'C') = 'C'
301: -- and decode(populate_interface_flag,'Y',populate_interface_status,'C') = 'C'
302: -- and decode(validate_data_flag,'Y',validate_data_status,'C') = 'C'
303: -- and decode(populate_data_flag,'Y',populate_data_status,'C') = 'C'

Line 312: FROM psb_data_extracts

308:
309:
310: CURSOR C_Interface is
311: SELECT data_extract_id
312: FROM psb_data_extracts
313: WHERE (data_extract_id = (DECODE(p_populate_interface_flag, 'Y', p_data_extract_id, 0))
314: OR (data_extract_id <> DECODE(p_populate_interface_flag, 'Y', 0, p_data_extract_id)
315: AND populate_interface_status = 'C'
316: AND validate_data_status = 'C'

Line 562: FROM PSB_DATA_EXTRACTS de,

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
566: AND p_as_of_date between date_from and nvl(date_to, p_as_of_date)

Line 653: from psb_data_extracts

649: Select data_extract_name,
650: nvl(extract_by_organization_flag,'N'),
651: nvl(data_extract_status,'I')
652: into l_data_extract_name, l_extract_by_org, l_data_extract_status
653: from psb_data_extracts
654: where data_extract_id = p_data_extract_id;
655:
656: message_token('DATA_EXTRACT_NAME',l_data_extract_name);
657: add_message('PSB', 'PSB_DATA_EXTRACT');

Line 810: from PSB_DATA_EXTRACTS

806: select nvl(default_data_flag,'I') default_data_flag,
807: nvl(default_data_status,'I') default_data_status,
808: data_extract_method,
809: data_extract_name
810: from PSB_DATA_EXTRACTS
811: where data_extract_id = p_data_extract_id;
812:
813: BEGIN
814:

Line 1028: FROM PSB_DATA_EXTRACTS

1024: COPY_SALARY_FLAG,
1025: POSITION_ID_FLEX_NUM,
1026: -- de by org
1027: NVL(EXTRACT_BY_ORGANIZATION_FLAG,'N') EXTRACT_BY_ORG
1028: FROM PSB_DATA_EXTRACTS
1029: WHERE data_extract_id = p_data_extract_id;
1030:
1031: l_return_status VARCHAR2(1) ;
1032: l_msg_count NUMBER ;

Line 1936: from psb_data_extracts

1932:
1933: -- Following cursor checks if extract by org is enabled or not.
1934: Cursor c_data_extract_org is
1935: Select nvl(extract_by_organization_flag,'N') extract_by_org
1936: from psb_data_extracts
1937: where data_extract_id = p_data_extract_id;
1938:
1939: BEGIN
1940: -- de by org

Line 2136: from psb_data_extracts

2132:
2133: -- Following cursor checks if extract by org is enabled or not.
2134: Cursor c_data_extract_org is
2135: Select nvl(extract_by_organization_flag,'N') extract_by_org
2136: from psb_data_extracts
2137: where data_extract_id = p_data_extract_id;
2138:
2139: BEGIN
2140: -- de by org

Line 3058: from psb_data_extracts

3054: Select nvl(populate_interface_status,'I') populate_interface_status,
3055: nvl(populate_data_status,'I') populate_data_status,
3056: nvl(copy_defaults_status,'I') copy_defaults_status,
3057: nvl(validate_data_status,'I') validate_data_status
3058: from psb_data_extracts
3059: where data_extract_id = p_data_extract_id;
3060:
3061: -- de by org
3062:

Line 3066: from psb_data_extracts

3062:
3063: -- Following cursor checks if extract by org is enabled or not.
3064: Cursor c_data_extract_org is
3065: Select nvl(extract_by_organization_flag,'N') extract_by_org
3066: from psb_data_extracts
3067: where data_extract_id = p_data_extract_id;
3068:
3069: BEGIN
3070: -- de by org

Line 3141: Update psb_data_extracts

3137: else
3138: lp_status := 'C';
3139: end if;
3140:
3141: Update psb_data_extracts
3142: set copy_defaults_status = lc_status,
3143: populate_interface_status = li_status,
3144: validate_data_status = lv_status,
3145: populate_data_status = lp_status

Line 3157: UPDATE psb_data_extracts

3153: /* Bug 3451357 Start */
3154: IF (lc_return_status = 'E') then
3155: l_return_status := FND_API.G_RET_STS_ERROR;
3156:
3157: UPDATE psb_data_extracts
3158: SET data_extract_status = 'I'
3159: WHERE data_extract_id = p_data_extract_id;
3160: ELSE
3161: UPDATE psb_data_extracts

Line 3161: UPDATE psb_data_extracts

3157: UPDATE psb_data_extracts
3158: SET data_extract_status = 'I'
3159: WHERE data_extract_id = p_data_extract_id;
3160: ELSE
3161: UPDATE psb_data_extracts
3162: SET data_extract_status = 'C'
3163: WHERE data_extract_id = p_data_extract_id;
3164: /* Start bug #4248348 */
3165: l_data_extract_status := 'C';

Line 3212: Update PSB_DATA_EXTRACTS

3208: (l_sp16_status = 'C') and
3209: (l_sp17_status = 'C') and
3210: (l_sp18_status = 'C') and p_copy_defaults_flag <> 'Y') THEN
3211:
3212: Update PSB_DATA_EXTRACTS
3213: set populate_data_status = 'C',
3214: data_extract_status = 'C'
3215: where data_extract_id = p_data_extract_id;
3216: -- de by org

Line 3226: UPDATE PSB_DATA_EXTRACTS

3222: (l_sp10_status = 'C') and
3223: (l_sp11_status = 'C') and
3224: (l_sp12_status = 'C') and p_copy_defaults_flag = 'Y') THEN
3225:
3226: UPDATE PSB_DATA_EXTRACTS
3227: SET copy_defaults_status = 'C',
3228: data_extract_status = 'C'
3229: WHERE data_extract_id = p_data_extract_id;
3230: END IF;

Line 3352: FROM psb_data_extracts

3348: l_extract_by_org VARCHAR2(1) := 'N';
3349:
3350: CURSOR c_data_extract_org IS
3351: SELECT nvl(extract_by_organization_flag,'N') extract_by_org
3352: FROM psb_data_extracts
3353: WHERE data_extract_id = p_data_extract_id;
3354:
3355: BEGIN
3356: p_request_id := 0; -- Bug #4451621

Line 3815: FROM psb_data_extracts

3811: END LOOP;
3812:
3813: --Fetch set_of_books_id and budget_group_id
3814: FOR l_data_extracts_rec IN (SELECT set_of_books_id, business_group_id
3815: FROM psb_data_extracts
3816: WHERE data_extract_id = p_data_extract_id)
3817: LOOP
3818: l_set_of_books_id := l_data_extracts_rec.set_of_books_id;
3819: l_budget_group_id := l_data_extracts_rec.business_group_id;