APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_ADJUSTMENT_DETAILS

Line 686: l_start_date pn_adjustment_details.adj_start_date%TYPE;

682: l_count_del_orig NUMBER := 0;
683: l_count_chg_adj NUMBER := 0;
684: l_last_appr_dt DATE;
685:
686: l_start_date pn_adjustment_details.adj_start_date%TYPE;
687: l_end_date pn_adjustment_details.adj_end_date%TYPE;
688:
689: l_info VARCHAR2(100);
690: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_adjustment_tables';

Line 687: l_end_date pn_adjustment_details.adj_end_date%TYPE;

683: l_count_chg_adj NUMBER := 0;
684: l_last_appr_dt DATE;
685:
686: l_start_date pn_adjustment_details.adj_start_date%TYPE;
687: l_end_date pn_adjustment_details.adj_end_date%TYPE;
688:
689: l_info VARCHAR2(100);
690: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_adjustment_tables';
691:

Line 845: FROM pn_adjustment_details

841: WHERE schedule.payment_schedule_id = item.payment_schedule_id
842: AND schedule.payment_status_lookup_code = 'DRAFT'
843: AND item.payment_item_id IN
844: (SELECT payment_item_id
845: FROM pn_adjustment_details
846: WHERE adjustment_summary_id = p_adj_summ_id);
847:
848: l_items_table payment_item_tbl_type;
849:

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

1228:
1229: ------------------------------------------------------------------------------+
1230: -- PROCEDURE : remove_item_reference
1231: -- DESCRIPTION : takes a table containing payment id and remove all reference
1232: -- to it from the pn_adjustment_details table.
1233: -- HISTORY :
1234: -- 05-OCT-04 ftanudja o Created.
1235: ------------------------------------------------------------------------------+
1236:

Line 1262: UPDATE pn_adjustment_details

1258: l_info := ' performing bulk update ';
1259: pnp_debug_pkg.log(l_info);
1260:
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

Line 1604: l_start_date pn_adjustment_details.adj_start_date%TYPE;

1600: p_adj_table payment_item_tbl_type,
1601: p_org_id NUMBER
1602: )
1603: IS
1604: l_start_date pn_adjustment_details.adj_start_date%TYPE;
1605: l_end_date pn_adjustment_details.adj_end_date%TYPE;
1606: l_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE;
1607:
1608: l_group_num NUMBER := 0;

Line 1605: l_end_date pn_adjustment_details.adj_end_date%TYPE;

1601: p_org_id NUMBER
1602: )
1603: IS
1604: l_start_date pn_adjustment_details.adj_start_date%TYPE;
1605: l_end_date pn_adjustment_details.adj_end_date%TYPE;
1606: l_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE;
1607:
1608: l_group_num NUMBER := 0;
1609: l_consolidate BOOLEAN;

Line 1696: INSERT INTO pn_adjustment_details (

1692: l_info := ' inserting new adjustment for schedule date:'||
1693: p_adj_table(i).schedule_date;
1694: pnp_debug_pkg.log(l_info);
1695:
1696: INSERT INTO pn_adjustment_details (
1697: adjustment_detail_id,
1698: term_history_id,
1699: adjustment_summary_id,
1700: payment_item_id,

Line 1711: pn_adjustment_details_s.nextval,

1707: last_update_date,
1708: last_updated_by,
1709: last_update_login
1710: ) VALUES (
1711: pn_adjustment_details_s.nextval,
1712: p_term_hist_id,
1713: l_adj_summ_id,
1714: p_adj_table(i).item_id,
1715: l_start_date,

Line 2028: FROM pn_adjustment_details pad,

2024:
2025: -- Get total adj amount
2026: CURSOR get_total_adj_amt IS
2027: SELECT SUM(pad.adjustment_amount) total_adj_amount
2028: FROM pn_adjustment_details pad,
2029: pn_payment_terms_history pth
2030: WHERE pth.payment_term_id = p_term_id
2031: AND pth.lease_change_id = p_lease_change_id
2032: AND pad.term_history_id = pth.term_history_id;