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.PN_RECOVERY_EXTRACT_PKG dependencies on FND_PROFILE

Line 779: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),

775: x_include_flag => p_new_data(i).include_flag,
776: x_recovery_space_std_code => p_new_data(i).recovery_space_std_code,
777: x_recovery_type_code => p_new_data(i).recovery_type_code,
778: x_last_update_date => SYSDATE,
779: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
780: x_creation_date => SYSDATE,
781: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
782: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
783: );

Line 781: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),

777: x_recovery_type_code => p_new_data(i).recovery_type_code,
778: x_last_update_date => SYSDATE,
779: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
780: x_creation_date => SYSDATE,
781: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
782: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
783: );
784:
785: ELSE

Line 782: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)

778: x_last_update_date => SYSDATE,
779: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
780: x_creation_date => SYSDATE,
781: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
782: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
783: );
784:
785: ELSE
786:

Line 817: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),

813: x_include_flag => p_new_data(i).include_flag,
814: x_recovery_space_std_code => p_new_data(i).recovery_space_std_code,
815: x_recovery_type_code => p_new_data(i).recovery_type_code,
816: x_last_update_date => SYSDATE,
817: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
818: x_creation_date => SYSDATE,
819: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
820: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
821: );

Line 819: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),

815: x_recovery_type_code => p_new_data(i).recovery_type_code,
816: x_last_update_date => SYSDATE,
817: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
818: x_creation_date => SYSDATE,
819: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
820: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
821: );
822:
823: END IF;

Line 820: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)

816: x_last_update_date => SYSDATE,
817: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
818: x_creation_date => SYSDATE,
819: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
820: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
821: );
822:
823: END IF;
824:

Line 1570: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),

1566: x_ttl_weighted_avg => l_area_total_tbl(0).total_weighted_avg,
1567: x_ttl_weighted_avg_ovr => l_area_total_tbl(0).total_weighted_avg_ovr,
1568: x_ttl_weighted_avg_exc => l_area_total_tbl(0).total_weighted_avg_exc,
1569: x_last_update_date => SYSDATE,
1570: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1571: x_creation_date => SYSDATE,
1572: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1573: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1574: );

Line 1572: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),

1568: x_ttl_weighted_avg_exc => l_area_total_tbl(0).total_weighted_avg_exc,
1569: x_last_update_date => SYSDATE,
1570: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1571: x_creation_date => SYSDATE,
1572: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1573: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1574: );
1575: ELSE
1576: pn_rec_arcl_dtl_pkg.insert_row(

Line 1573: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)

1569: x_last_update_date => SYSDATE,
1570: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1571: x_creation_date => SYSDATE,
1572: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1573: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1574: );
1575: ELSE
1576: pn_rec_arcl_dtl_pkg.insert_row(
1577: x_org_id => pn_mo_cache_utils.get_current_org_id,

Line 1595: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),

1591: x_ttl_weighted_avg => l_area_total_tbl(0).total_weighted_avg,
1592: x_ttl_weighted_avg_ovr => l_area_total_tbl(0).total_weighted_avg_ovr,
1593: x_ttl_weighted_avg_exc => l_area_total_tbl(0).total_weighted_avg_exc,
1594: x_last_update_date => SYSDATE,
1595: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1596: x_creation_date => SYSDATE,
1597: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1598: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1599: );

Line 1597: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),

1593: x_ttl_weighted_avg_exc => l_area_total_tbl(0).total_weighted_avg_exc,
1594: x_last_update_date => SYSDATE,
1595: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1596: x_creation_date => SYSDATE,
1597: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1598: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1599: );
1600: END IF;
1601:

Line 1598: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)

1594: x_last_update_date => SYSDATE,
1595: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1596: x_creation_date => SYSDATE,
1597: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1598: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1599: );
1600: END IF;
1601:
1602: l_info := ' dumping data from pl/sql table ';

Line 1941: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),

1937: x_to_date => p_to_date,
1938: x_location_id => p_location_id,
1939: x_property_id => p_property_id,
1940: x_last_update_date => SYSDATE,
1941: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1942: x_creation_date => SYSDATE,
1943: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1944: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
1945: );

Line 1943: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),

1939: x_property_id => p_property_id,
1940: x_last_update_date => SYSDATE,
1941: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1942: x_creation_date => SYSDATE,
1943: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1944: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
1945: );
1946:
1947: END IF;

Line 1944: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)

1940: x_last_update_date => SYSDATE,
1941: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1942: x_creation_date => SYSDATE,
1943: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1944: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
1945: );
1946:
1947: END IF;
1948:

Line 1972: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),

1968: x_currency_code => p_currency_code,
1969: x_recoverable_flag => 'Y',
1970: x_expense_line_indicator => 'NEUTRAL',
1971: x_last_update_date => SYSDATE,
1972: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1973: x_creation_date => SYSDATE,
1974: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1975: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1),
1976: x_attribute_category => p_attribute_category,

Line 1974: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),

1970: x_expense_line_indicator => 'NEUTRAL',
1971: x_last_update_date => SYSDATE,
1972: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1973: x_creation_date => SYSDATE,
1974: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1975: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1),
1976: x_attribute_category => p_attribute_category,
1977: x_attribute1 => p_attribute1,
1978: x_attribute2 => p_attribute2,

Line 1975: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1),

1971: x_last_update_date => SYSDATE,
1972: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1973: x_creation_date => SYSDATE,
1974: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1975: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1),
1976: x_attribute_category => p_attribute_category,
1977: x_attribute1 => p_attribute1,
1978: x_attribute2 => p_attribute2,
1979: x_attribute3 => p_attribute3,

Line 2492: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),

2488: x_cls_line_fee_af_ct_ovr => p_master_data(i).cls_line_fee_after_contr_ovr,
2489: x_use_share_pct_flag => l_use_share_pct_flag,
2490: x_use_fee_before_contr_flag => l_use_fee_pct_flag,
2491: x_last_update_date => SYSDATE,
2492: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2493: x_creation_date => SYSDATE,
2494: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2495: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2496: );

Line 2494: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),

2490: x_use_fee_before_contr_flag => l_use_fee_pct_flag,
2491: x_last_update_date => SYSDATE,
2492: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2493: x_creation_date => SYSDATE,
2494: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2495: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2496: );
2497:
2498: p_master_data(i).expense_class_line_id := l_expense_class_line_id;

Line 2495: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)

2491: x_last_update_date => SYSDATE,
2492: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2493: x_creation_date => SYSDATE,
2494: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2495: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2496: );
2497:
2498: p_master_data(i).expense_class_line_id := l_expense_class_line_id;
2499:

Line 2523: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),

2519: x_cls_line_fee_af_ct_ovr => p_master_data(i).cls_line_fee_after_contr_ovr,
2520: x_use_share_pct_flag => l_use_share_pct_flag,
2521: x_use_fee_before_contr_flag => l_use_fee_pct_flag,
2522: x_last_update_date => SYSDATE,
2523: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2524: x_creation_date => SYSDATE,
2525: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2526: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2527: );

Line 2525: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),

2521: x_use_fee_before_contr_flag => l_use_fee_pct_flag,
2522: x_last_update_date => SYSDATE,
2523: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2524: x_creation_date => SYSDATE,
2525: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2526: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2527: );
2528:
2529: END IF;

Line 2526: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)

2522: x_last_update_date => SYSDATE,
2523: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2524: x_creation_date => SYSDATE,
2525: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2526: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2527: );
2528:
2529: END IF;
2530:

Line 2569: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),

2565: x_budgeted_amt => p_detail_data(i).budgeted_amt,
2566: x_recoverable_amt => p_detail_data(i).recoverable_amt,
2567: x_computed_recoverable_amt => p_detail_data(i).computed_recoverable_amt,
2568: x_last_update_date => SYSDATE,
2569: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2570: x_creation_date => SYSDATE,
2571: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2572: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2573: );

Line 2571: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),

2567: x_computed_recoverable_amt => p_detail_data(i).computed_recoverable_amt,
2568: x_last_update_date => SYSDATE,
2569: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2570: x_creation_date => SYSDATE,
2571: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2572: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2573: );
2574: ELSE
2575: l_info := ' updating detail data for class line header: '||

Line 2572: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)

2568: x_last_update_date => SYSDATE,
2569: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2570: x_creation_date => SYSDATE,
2571: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2572: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2573: );
2574: ELSE
2575: l_info := ' updating detail data for class line header: '||
2576: p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id;

Line 2593: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),

2589: x_budgeted_amt => p_detail_data(i).budgeted_amt,
2590: x_recoverable_amt => p_detail_data(i).recoverable_amt,
2591: x_computed_recoverable_amt => p_detail_data(i).computed_recoverable_amt,
2592: x_last_update_date => SYSDATE,
2593: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2594: x_creation_date => SYSDATE,
2595: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2596: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2597: );

Line 2595: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),

2591: x_computed_recoverable_amt => p_detail_data(i).computed_recoverable_amt,
2592: x_last_update_date => SYSDATE,
2593: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2594: x_creation_date => SYSDATE,
2595: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2596: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2597: );
2598:
2599: END IF;

Line 2596: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)

2592: x_last_update_date => SYSDATE,
2593: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2594: x_creation_date => SYSDATE,
2595: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2596: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2597: );
2598:
2599: END IF;
2600:

Line 2754: last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),

2750: computed_recoverable_amt = computed_recoverable_list(i) *
2751: nvl(share_use_tbl(i), cls_line_share_pct) / 100 *
2752: (1 + nvl(fee_use_tbl(i), cls_line_fee_before_contr_ovr) / 100),
2753: last_update_date = SYSDATE,
2754: last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),
2755: last_update_login = nvl(fnd_profile.value('USER_ID'), -1)
2756: WHERE expense_class_line_id = update_list(i);
2757:
2758: l_info := ' deleting unused header lines';

Line 2755: last_update_login = nvl(fnd_profile.value('USER_ID'), -1)

2751: nvl(share_use_tbl(i), cls_line_share_pct) / 100 *
2752: (1 + nvl(fee_use_tbl(i), cls_line_fee_before_contr_ovr) / 100),
2753: last_update_date = SYSDATE,
2754: last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),
2755: last_update_login = nvl(fnd_profile.value('USER_ID'), -1)
2756: WHERE expense_class_line_id = update_list(i);
2757:
2758: l_info := ' deleting unused header lines';
2759: pnp_debug_pkg.log(l_info);

Line 3539: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),

3535: x_cls_line_fee_bf_ct => l_mst_fee_bf_contr,
3536: x_cls_line_fee_af_ct => l_fee_af_contr,
3537: x_cls_line_portion_pct => l_portion_pct,
3538: x_last_update_date => SYSDATE,
3539: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3540: x_creation_date => SYSDATE,
3541: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3542: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3543: );

Line 3541: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),

3537: x_cls_line_portion_pct => l_portion_pct,
3538: x_last_update_date => SYSDATE,
3539: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3540: x_creation_date => SYSDATE,
3541: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3542: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3543: );
3544:
3545: END IF;

Line 3542: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)

3538: x_last_update_date => SYSDATE,
3539: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3540: x_creation_date => SYSDATE,
3541: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3542: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3543: );
3544:
3545: END IF;
3546:

Line 3565: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),

3561: x_cls_line_fee_bf_ct => l_mst_fee_bf_contr,
3562: x_cls_line_fee_af_ct => l_fee_af_contr,
3563: x_cls_line_portion_pct => l_portion_pct,
3564: x_last_update_date => SYSDATE,
3565: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3566: x_creation_date => SYSDATE,
3567: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3568: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3569: );

Line 3567: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),

3563: x_cls_line_portion_pct => l_portion_pct,
3564: x_last_update_date => SYSDATE,
3565: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3566: x_creation_date => SYSDATE,
3567: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3568: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3569: );
3570:
3571: END IF;

Line 3568: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)

3564: x_last_update_date => SYSDATE,
3565: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3566: x_creation_date => SYSDATE,
3567: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3568: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3569: );
3570:
3571: END IF;
3572: