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.

[Home] [Help]

APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on FND_GLOBAL

Line 1161: x_created_by => fnd_global.user_id,

1157: x_attribute13 => null,
1158: x_attribute14 => null,
1159: x_attribute15 => null,
1160: x_creation_date => SYSDATE,
1161: x_created_by => fnd_global.user_id,
1162: x_last_update_date => SYSDATE,
1163: x_last_updated_by => fnd_global.user_id,
1164: x_last_update_login => fnd_global.login_id,
1165: x_org_id => l_org_id

Line 1163: x_last_updated_by => fnd_global.user_id,

1159: x_attribute15 => null,
1160: x_creation_date => SYSDATE,
1161: x_created_by => fnd_global.user_id,
1162: x_last_update_date => SYSDATE,
1163: x_last_updated_by => fnd_global.user_id,
1164: x_last_update_login => fnd_global.login_id,
1165: x_org_id => l_org_id
1166: );
1167:

Line 1164: x_last_update_login => fnd_global.login_id,

1160: x_creation_date => SYSDATE,
1161: x_created_by => fnd_global.user_id,
1162: x_last_update_date => SYSDATE,
1163: x_last_updated_by => fnd_global.user_id,
1164: x_last_update_login => fnd_global.login_id,
1165: x_org_id => l_org_id
1166: );
1167:
1168: END IF;

Line 1265: last_updated_by = fnd_global.user_id,

1261: FORALL i IN 0 .. l_payment_id_tbl.COUNT - 1
1262: UPDATE pn_adjustment_details
1263: SET payment_item_id = null,
1264: last_update_date = SYSDATE,
1265: last_updated_by = fnd_global.user_id,
1266: last_update_login = fnd_global.login_id
1267: WHERE payment_item_id = l_payment_id_tbl(i);
1268:
1269: pnp_debug_pkg.log(l_desc ||' (-)');

Line 1266: last_update_login = fnd_global.login_id

1262: UPDATE pn_adjustment_details
1263: SET payment_item_id = null,
1264: last_update_date = SYSDATE,
1265: last_updated_by = fnd_global.user_id,
1266: last_update_login = fnd_global.login_id
1267: WHERE payment_item_id = l_payment_id_tbl(i);
1268:
1269: pnp_debug_pkg.log(l_desc ||' (-)');
1270:

Line 1374: last_updated_by = fnd_global.user_id,

1370: UPDATE pn_payment_items_all
1371: SET actual_amount = ROUND(l_act_amt_tbl(i), l_precision),
1372: estimated_amount = ROUND(l_est_amt_tbl(i), l_precision),
1373: last_update_date = SYSDATE,
1374: last_updated_by = fnd_global.user_id,
1375: last_update_login = fnd_global.login_id
1376: WHERE payment_item_id = l_payment_id_tbl(i);
1377:
1378: l_info := ' deleting items ';

Line 1375: last_update_login = fnd_global.login_id

1371: SET actual_amount = ROUND(l_act_amt_tbl(i), l_precision),
1372: estimated_amount = ROUND(l_est_amt_tbl(i), l_precision),
1373: last_update_date = SYSDATE,
1374: last_updated_by = fnd_global.user_id,
1375: last_update_login = fnd_global.login_id
1376: WHERE payment_item_id = l_payment_id_tbl(i);
1377:
1378: l_info := ' deleting items ';
1379: pnp_debug_pkg.log(l_info);

Line 1478: fnd_global.user_id,

1474: VALUES
1475: (
1476: pn_payment_items_s.nextval,
1477: SYSDATE,
1478: fnd_global.user_id,
1479: SYSDATE,
1480: fnd_global.user_id,
1481: fnd_global.login_id,
1482: ROUND(l_act_amt_tbl(i), l_precision),

Line 1480: fnd_global.user_id,

1476: pn_payment_items_s.nextval,
1477: SYSDATE,
1478: fnd_global.user_id,
1479: SYSDATE,
1480: fnd_global.user_id,
1481: fnd_global.login_id,
1482: ROUND(l_act_amt_tbl(i), l_precision),
1483: ROUND(l_est_amt_tbl(i), l_precision),
1484: l_trx_date_tbl(i),

Line 1481: fnd_global.login_id,

1477: SYSDATE,
1478: fnd_global.user_id,
1479: SYSDATE,
1480: fnd_global.user_id,
1481: fnd_global.login_id,
1482: ROUND(l_act_amt_tbl(i), l_precision),
1483: ROUND(l_est_amt_tbl(i), l_precision),
1484: l_trx_date_tbl(i),
1485: l_start_date_tbl(i),

Line 1652: fnd_global.user_id,

1648: p_adj_table(i).schedule_date,
1649: p_term_id,
1650: p_adj_table(i).amount,
1651: SYSDATE,
1652: fnd_global.user_id,
1653: SYSDATE,
1654: fnd_global.user_id,
1655: fnd_global.login_id
1656: ) RETURNING adjustment_summary_id INTO l_adj_summ_id;

Line 1654: fnd_global.user_id,

1650: p_adj_table(i).amount,
1651: SYSDATE,
1652: fnd_global.user_id,
1653: SYSDATE,
1654: fnd_global.user_id,
1655: fnd_global.login_id
1656: ) RETURNING adjustment_summary_id INTO l_adj_summ_id;
1657:
1658: ELSE

Line 1655: fnd_global.login_id

1651: SYSDATE,
1652: fnd_global.user_id,
1653: SYSDATE,
1654: fnd_global.user_id,
1655: fnd_global.login_id
1656: ) RETURNING adjustment_summary_id INTO l_adj_summ_id;
1657:
1658: ELSE
1659:

Line 1720: fnd_global.user_id,

1716: l_end_date,
1717: p_adj_table(i).amount,
1718: l_group_num,
1719: SYSDATE,
1720: fnd_global.user_id,
1721: SYSDATE,
1722: fnd_global.user_id,
1723: fnd_global.login_id
1724: );

Line 1722: fnd_global.user_id,

1718: l_group_num,
1719: SYSDATE,
1720: fnd_global.user_id,
1721: SYSDATE,
1722: fnd_global.user_id,
1723: fnd_global.login_id
1724: );
1725:
1726: IF p_adj_table(i).adj_summ_id IS NOT NULL THEN

Line 1723: fnd_global.login_id

1719: SYSDATE,
1720: fnd_global.user_id,
1721: SYSDATE,
1722: fnd_global.user_id,
1723: fnd_global.login_id
1724: );
1725:
1726: IF p_adj_table(i).adj_summ_id IS NOT NULL THEN
1727:

Line 1735: last_updated_by = fnd_global.user_id,

1731:
1732: UPDATE pn_adjustment_summaries
1733: SET sum_adj_amount = sum_adj_amount + p_adj_table(i).amount,
1734: last_update_date = SYSDATE,
1735: last_updated_by = fnd_global.user_id,
1736: last_update_login = fnd_global.login_id
1737: WHERE adjustment_summary_id = p_adj_table(i).adj_summ_id;
1738:
1739: END IF;

Line 1736: last_update_login = fnd_global.login_id

1732: UPDATE pn_adjustment_summaries
1733: SET sum_adj_amount = sum_adj_amount + p_adj_table(i).amount,
1734: last_update_date = SYSDATE,
1735: last_updated_by = fnd_global.user_id,
1736: last_update_login = fnd_global.login_id
1737: WHERE adjustment_summary_id = p_adj_table(i).adj_summ_id;
1738:
1739: END IF;
1740:

Line 1963: fnd_global.user_id,

1959: ) VALUES
1960: (
1961: pn_payment_items_s.nextval,
1962: SYSDATE,
1963: fnd_global.user_id,
1964: SYSDATE,
1965: fnd_global.user_id,
1966: fnd_global.login_id,
1967: 0,

Line 1965: fnd_global.user_id,

1961: pn_payment_items_s.nextval,
1962: SYSDATE,
1963: fnd_global.user_id,
1964: SYSDATE,
1965: fnd_global.user_id,
1966: fnd_global.login_id,
1967: 0,
1968: null,
1969: l_sched_dt_tbl(i),

Line 1966: fnd_global.login_id,

1962: SYSDATE,
1963: fnd_global.user_id,
1964: SYSDATE,
1965: fnd_global.user_id,
1966: fnd_global.login_id,
1967: 0,
1968: null,
1969: l_sched_dt_tbl(i),
1970: null,

Line 2050: last_update_login = fnd_global.login_id,

2046: UPDATE pn_payment_terms_history
2047: SET adjustment_type_code = p_adj_type_cd,
2048: total_adj_amount = l_amount,
2049: last_update_date = SYSDATE,
2050: last_update_login = fnd_global.login_id,
2051: last_updated_by = fnd_global.user_id
2052: WHERE term_history_id = p_term_hist_id;
2053:
2054: pnp_debug_pkg.log(l_desc ||' (-)');

Line 2051: last_updated_by = fnd_global.user_id

2047: SET adjustment_type_code = p_adj_type_cd,
2048: total_adj_amount = l_amount,
2049: last_update_date = SYSDATE,
2050: last_update_login = fnd_global.login_id,
2051: last_updated_by = fnd_global.user_id
2052: WHERE term_history_id = p_term_hist_id;
2053:
2054: pnp_debug_pkg.log(l_desc ||' (-)');
2055: