APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_ADJUSTMENT_DETAILS

Line 707: l_start_date pn_adjustment_details.adj_start_date%TYPE;

703: l_count_del_orig NUMBER := 0;
704: l_count_chg_adj NUMBER := 0;
705: l_last_appr_dt DATE;
706:
707: l_start_date pn_adjustment_details.adj_start_date%TYPE;
708: l_end_date pn_adjustment_details.adj_end_date%TYPE;
709:
710: l_info VARCHAR2(100);
711: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_adjustment_tables';

Line 708: l_end_date pn_adjustment_details.adj_end_date%TYPE;

704: l_count_chg_adj NUMBER := 0;
705: l_last_appr_dt DATE;
706:
707: l_start_date pn_adjustment_details.adj_start_date%TYPE;
708: l_end_date pn_adjustment_details.adj_end_date%TYPE;
709:
710: l_info VARCHAR2(100);
711: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_adjustment_tables';
712:

Line 866: FROM pn_adjustment_details

862: WHERE schedule.payment_schedule_id = item.payment_schedule_id
863: AND schedule.payment_status_lookup_code = 'DRAFT'
864: AND item.payment_item_id IN
865: (SELECT payment_item_id
866: FROM pn_adjustment_details
867: WHERE adjustment_summary_id = p_adj_summ_id);
868:
869: l_items_table payment_item_tbl_type;
870:

Line 1253: -- to it from the pn_adjustment_details table.

1249:
1250: ------------------------------------------------------------------------------+
1251: -- PROCEDURE : remove_item_reference
1252: -- DESCRIPTION : takes a table containing payment id and remove all reference
1253: -- to it from the pn_adjustment_details table.
1254: -- HISTORY :
1255: -- 05-OCT-04 ftanudja o Created.
1256: ------------------------------------------------------------------------------+
1257:

Line 1283: UPDATE pn_adjustment_details

1279: l_info := ' performing bulk update ';
1280: pnp_debug_pkg.log(l_info);
1281:
1282: FORALL i IN 0 .. l_payment_id_tbl.COUNT - 1
1283: UPDATE pn_adjustment_details
1284: SET payment_item_id = null,
1285: last_update_date = SYSDATE,
1286: last_updated_by = fnd_global.user_id,
1287: last_update_login = fnd_global.login_id

Line 1625: l_start_date pn_adjustment_details.adj_start_date%TYPE;

1621: p_adj_table payment_item_tbl_type,
1622: p_org_id NUMBER
1623: )
1624: IS
1625: l_start_date pn_adjustment_details.adj_start_date%TYPE;
1626: l_end_date pn_adjustment_details.adj_end_date%TYPE;
1627: l_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE;
1628:
1629: l_group_num NUMBER := 0;

Line 1626: l_end_date pn_adjustment_details.adj_end_date%TYPE;

1622: p_org_id NUMBER
1623: )
1624: IS
1625: l_start_date pn_adjustment_details.adj_start_date%TYPE;
1626: l_end_date pn_adjustment_details.adj_end_date%TYPE;
1627: l_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE;
1628:
1629: l_group_num NUMBER := 0;
1630: l_consolidate BOOLEAN;

Line 1717: INSERT INTO pn_adjustment_details (

1713: l_info := ' inserting new adjustment for schedule date:'||
1714: p_adj_table(i).schedule_date;
1715: pnp_debug_pkg.log(l_info);
1716:
1717: INSERT INTO pn_adjustment_details (
1718: adjustment_detail_id,
1719: term_history_id,
1720: adjustment_summary_id,
1721: payment_item_id,

Line 1732: pn_adjustment_details_s.nextval,

1728: last_update_date,
1729: last_updated_by,
1730: last_update_login
1731: ) VALUES (
1732: pn_adjustment_details_s.nextval,
1733: p_term_hist_id,
1734: l_adj_summ_id,
1735: p_adj_table(i).item_id,
1736: l_start_date,

Line 2049: FROM pn_adjustment_details pad,

2045:
2046: -- Get total adj amount
2047: CURSOR get_total_adj_amt IS
2048: SELECT SUM(pad.adjustment_amount) total_adj_amount
2049: FROM pn_adjustment_details pad,
2050: pn_payment_terms_history pth
2051: WHERE pth.payment_term_id = p_term_id
2052: AND pth.lease_change_id = p_lease_change_id
2053: AND pad.term_history_id = pth.term_history_id;