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 1558: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),

1554: x_ttl_weighted_avg => l_area_total_tbl(0).total_weighted_avg,
1555: x_ttl_weighted_avg_ovr => l_area_total_tbl(0).total_weighted_avg_ovr,
1556: x_ttl_weighted_avg_exc => l_area_total_tbl(0).total_weighted_avg_exc,
1557: x_last_update_date => SYSDATE,
1558: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1559: x_creation_date => SYSDATE,
1560: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1561: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1562: );

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

1556: x_ttl_weighted_avg_exc => l_area_total_tbl(0).total_weighted_avg_exc,
1557: x_last_update_date => SYSDATE,
1558: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1559: x_creation_date => SYSDATE,
1560: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1561: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1562: );
1563: ELSE
1564: pn_rec_arcl_dtl_pkg.insert_row(

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

1557: x_last_update_date => SYSDATE,
1558: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1559: x_creation_date => SYSDATE,
1560: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1561: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1562: );
1563: ELSE
1564: pn_rec_arcl_dtl_pkg.insert_row(
1565: x_org_id => pn_mo_cache_utils.get_current_org_id,

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

1579: x_ttl_weighted_avg => l_area_total_tbl(0).total_weighted_avg,
1580: x_ttl_weighted_avg_ovr => l_area_total_tbl(0).total_weighted_avg_ovr,
1581: x_ttl_weighted_avg_exc => l_area_total_tbl(0).total_weighted_avg_exc,
1582: x_last_update_date => SYSDATE,
1583: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1584: x_creation_date => SYSDATE,
1585: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1586: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1587: );

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

1581: x_ttl_weighted_avg_exc => l_area_total_tbl(0).total_weighted_avg_exc,
1582: x_last_update_date => SYSDATE,
1583: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1584: x_creation_date => SYSDATE,
1585: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1586: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1587: );
1588: END IF;
1589:

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

1582: x_last_update_date => SYSDATE,
1583: x_last_updated_by => nvl(fnd_profile.value('USER_ID'), -1),
1584: x_creation_date => SYSDATE,
1585: x_created_by => nvl(fnd_profile.value('USER_ID'), -1),
1586: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1587: );
1588: END IF;
1589:
1590: l_info := ' dumping data from pl/sql table ';

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

1925: x_to_date => p_to_date,
1926: x_location_id => p_location_id,
1927: x_property_id => p_property_id,
1928: x_last_update_date => SYSDATE,
1929: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1930: x_creation_date => SYSDATE,
1931: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1932: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
1933: );

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

1927: x_property_id => p_property_id,
1928: x_last_update_date => SYSDATE,
1929: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1930: x_creation_date => SYSDATE,
1931: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1932: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
1933: );
1934:
1935: END IF;

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

1928: x_last_update_date => SYSDATE,
1929: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1930: x_creation_date => SYSDATE,
1931: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1932: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
1933: );
1934:
1935: END IF;
1936:

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

1956: x_currency_code => p_currency_code,
1957: x_recoverable_flag => 'Y',
1958: x_expense_line_indicator => 'NEUTRAL',
1959: x_last_update_date => SYSDATE,
1960: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1961: x_creation_date => SYSDATE,
1962: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1963: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1),
1964: x_attribute_category => p_attribute_category,

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

1958: x_expense_line_indicator => 'NEUTRAL',
1959: x_last_update_date => SYSDATE,
1960: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1961: x_creation_date => SYSDATE,
1962: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1963: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1),
1964: x_attribute_category => p_attribute_category,
1965: x_attribute1 => p_attribute1,
1966: x_attribute2 => p_attribute2,

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

1959: x_last_update_date => SYSDATE,
1960: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
1961: x_creation_date => SYSDATE,
1962: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
1963: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1),
1964: x_attribute_category => p_attribute_category,
1965: x_attribute1 => p_attribute1,
1966: x_attribute2 => p_attribute2,
1967: x_attribute3 => p_attribute3,

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

2476: x_cls_line_fee_af_ct_ovr => p_master_data(i).cls_line_fee_after_contr_ovr,
2477: x_use_share_pct_flag => l_use_share_pct_flag,
2478: x_use_fee_before_contr_flag => l_use_fee_pct_flag,
2479: x_last_update_date => SYSDATE,
2480: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2481: x_creation_date => SYSDATE,
2482: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2483: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2484: );

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

2478: x_use_fee_before_contr_flag => l_use_fee_pct_flag,
2479: x_last_update_date => SYSDATE,
2480: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2481: x_creation_date => SYSDATE,
2482: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2483: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2484: );
2485:
2486: p_master_data(i).expense_class_line_id := l_expense_class_line_id;

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

2479: x_last_update_date => SYSDATE,
2480: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2481: x_creation_date => SYSDATE,
2482: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2483: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2484: );
2485:
2486: p_master_data(i).expense_class_line_id := l_expense_class_line_id;
2487:

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

2507: x_cls_line_fee_af_ct_ovr => p_master_data(i).cls_line_fee_after_contr_ovr,
2508: x_use_share_pct_flag => l_use_share_pct_flag,
2509: x_use_fee_before_contr_flag => l_use_fee_pct_flag,
2510: x_last_update_date => SYSDATE,
2511: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2512: x_creation_date => SYSDATE,
2513: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2514: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2515: );

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

2509: x_use_fee_before_contr_flag => l_use_fee_pct_flag,
2510: x_last_update_date => SYSDATE,
2511: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2512: x_creation_date => SYSDATE,
2513: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2514: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2515: );
2516:
2517: END IF;

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

2510: x_last_update_date => SYSDATE,
2511: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2512: x_creation_date => SYSDATE,
2513: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2514: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2515: );
2516:
2517: END IF;
2518:

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

2553: x_budgeted_amt => p_detail_data(i).budgeted_amt,
2554: x_recoverable_amt => p_detail_data(i).recoverable_amt,
2555: x_computed_recoverable_amt => p_detail_data(i).computed_recoverable_amt,
2556: x_last_update_date => SYSDATE,
2557: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2558: x_creation_date => SYSDATE,
2559: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2560: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2561: );

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

2555: x_computed_recoverable_amt => p_detail_data(i).computed_recoverable_amt,
2556: x_last_update_date => SYSDATE,
2557: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2558: x_creation_date => SYSDATE,
2559: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2560: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2561: );
2562: ELSE
2563: l_info := ' updating detail data for class line header: '||

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

2556: x_last_update_date => SYSDATE,
2557: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2558: x_creation_date => SYSDATE,
2559: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2560: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2561: );
2562: ELSE
2563: l_info := ' updating detail data for class line header: '||
2564: p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id;

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

2577: x_budgeted_amt => p_detail_data(i).budgeted_amt,
2578: x_recoverable_amt => p_detail_data(i).recoverable_amt,
2579: x_computed_recoverable_amt => p_detail_data(i).computed_recoverable_amt,
2580: x_last_update_date => SYSDATE,
2581: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2582: x_creation_date => SYSDATE,
2583: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2584: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2585: );

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

2579: x_computed_recoverable_amt => p_detail_data(i).computed_recoverable_amt,
2580: x_last_update_date => SYSDATE,
2581: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2582: x_creation_date => SYSDATE,
2583: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2584: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2585: );
2586:
2587: END IF;

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

2580: x_last_update_date => SYSDATE,
2581: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
2582: x_creation_date => SYSDATE,
2583: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
2584: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
2585: );
2586:
2587: END IF;
2588:

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

2738: computed_recoverable_amt = computed_recoverable_list(i) *
2739: nvl(share_use_tbl(i), cls_line_share_pct) / 100 *
2740: (1 + nvl(fee_use_tbl(i), cls_line_fee_before_contr_ovr) / 100),
2741: last_update_date = SYSDATE,
2742: last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),
2743: last_update_login = nvl(fnd_profile.value('USER_ID'), -1)
2744: WHERE expense_class_line_id = update_list(i);
2745:
2746: l_info := ' deleting unused header lines';

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

2739: nvl(share_use_tbl(i), cls_line_share_pct) / 100 *
2740: (1 + nvl(fee_use_tbl(i), cls_line_fee_before_contr_ovr) / 100),
2741: last_update_date = SYSDATE,
2742: last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),
2743: last_update_login = nvl(fnd_profile.value('USER_ID'), -1)
2744: WHERE expense_class_line_id = update_list(i);
2745:
2746: l_info := ' deleting unused header lines';
2747: pnp_debug_pkg.log(l_info);

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

3523: x_cls_line_fee_bf_ct => l_mst_fee_bf_contr,
3524: x_cls_line_fee_af_ct => l_fee_af_contr,
3525: x_cls_line_portion_pct => l_portion_pct,
3526: x_last_update_date => SYSDATE,
3527: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3528: x_creation_date => SYSDATE,
3529: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3530: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3531: );

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

3525: x_cls_line_portion_pct => l_portion_pct,
3526: x_last_update_date => SYSDATE,
3527: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3528: x_creation_date => SYSDATE,
3529: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3530: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3531: );
3532:
3533: END IF;

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

3526: x_last_update_date => SYSDATE,
3527: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3528: x_creation_date => SYSDATE,
3529: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3530: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3531: );
3532:
3533: END IF;
3534:

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

3549: x_cls_line_fee_bf_ct => l_mst_fee_bf_contr,
3550: x_cls_line_fee_af_ct => l_fee_af_contr,
3551: x_cls_line_portion_pct => l_portion_pct,
3552: x_last_update_date => SYSDATE,
3553: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3554: x_creation_date => SYSDATE,
3555: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3556: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3557: );

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

3551: x_cls_line_portion_pct => l_portion_pct,
3552: x_last_update_date => SYSDATE,
3553: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3554: x_creation_date => SYSDATE,
3555: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3556: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3557: );
3558:
3559: END IF;

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

3552: x_last_update_date => SYSDATE,
3553: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
3554: x_creation_date => SYSDATE,
3555: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
3556: x_last_update_login => nvl(fnd_profile.value('USER_ID'),-1)
3557: );
3558:
3559: END IF;
3560: