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_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_ITEMS

Line 6: TYPE item_id_tbl_type IS TABLE OF pn_payment_items.payment_item_id%TYPE INDEX BY BINARY_INTEGER;

2: /* $Header: PNRTADJB.pls 120.5.12010000.2 2009/05/26 07:08:33 rthumma ship $ */
3:
4: ------------------------------ DECLARATIONS ----------------------------------+
5:
6: TYPE item_id_tbl_type IS TABLE OF pn_payment_items.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
7: TYPE sched_id_tbl_type IS TABLE OF pn_payment_schedules.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
8: TYPE amt_tbl_type IS TABLE OF pn_payment_items.actual_amount%TYPE INDEX BY BINARY_INTEGER;
9: TYPE date_tbl_type IS TABLE OF pn_payment_items.due_date%TYPE INDEX BY BINARY_INTEGER;
10:

Line 8: TYPE amt_tbl_type IS TABLE OF pn_payment_items.actual_amount%TYPE INDEX BY BINARY_INTEGER;

4: ------------------------------ DECLARATIONS ----------------------------------+
5:
6: TYPE item_id_tbl_type IS TABLE OF pn_payment_items.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
7: TYPE sched_id_tbl_type IS TABLE OF pn_payment_schedules.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
8: TYPE amt_tbl_type IS TABLE OF pn_payment_items.actual_amount%TYPE INDEX BY BINARY_INTEGER;
9: TYPE date_tbl_type IS TABLE OF pn_payment_items.due_date%TYPE INDEX BY BINARY_INTEGER;
10:
11: bad_input_exception EXCEPTION;
12:

Line 9: TYPE date_tbl_type IS TABLE OF pn_payment_items.due_date%TYPE INDEX BY BINARY_INTEGER;

5:
6: TYPE item_id_tbl_type IS TABLE OF pn_payment_items.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
7: TYPE sched_id_tbl_type IS TABLE OF pn_payment_schedules.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
8: TYPE amt_tbl_type IS TABLE OF pn_payment_items.actual_amount%TYPE INDEX BY BINARY_INTEGER;
9: TYPE date_tbl_type IS TABLE OF pn_payment_items.due_date%TYPE INDEX BY BINARY_INTEGER;
10:
11: bad_input_exception EXCEPTION;
12:
13: ------------------------------------------------------------------------------+

Line 195: FROM pn_payment_items_all item,

191: item.actual_amount,
192: item.payment_schedule_id,
193: schedule.schedule_date,
194: schedule.payment_status_lookup_code
195: FROM pn_payment_items_all item,
196: pn_payment_schedules_all schedule
197: WHERE item.payment_term_id = p_term_id
198: AND item.payment_schedule_id = schedule.payment_schedule_id
199: AND item.payment_item_type_lookup_code = 'CASH'

Line 616: x_start_date OUT NOCOPY pn_payment_items.adj_start_date%TYPE,

612: p_term_freq pn_payment_terms.frequency_code%TYPE,
613: p_term_start_dt pn_payment_terms.start_date%TYPE,
614: p_term_end_dt pn_payment_terms.end_date%TYPE,
615: p_schedule_dt pn_payment_schedules.schedule_date%TYPE,
616: x_start_date OUT NOCOPY pn_payment_items.adj_start_date%TYPE,
617: x_end_date OUT NOCOPY pn_payment_items.adj_end_date%TYPE
618: )
619: IS
620: l_freq_num NUMBER;

Line 617: x_end_date OUT NOCOPY pn_payment_items.adj_end_date%TYPE

613: p_term_start_dt pn_payment_terms.start_date%TYPE,
614: p_term_end_dt pn_payment_terms.end_date%TYPE,
615: p_schedule_dt pn_payment_schedules.schedule_date%TYPE,
616: x_start_date OUT NOCOPY pn_payment_items.adj_start_date%TYPE,
617: x_end_date OUT NOCOPY pn_payment_items.adj_end_date%TYPE
618: )
619: IS
620: l_freq_num NUMBER;
621: l_start_day NUMBER;

Line 860: FROM pn_payment_items_all item,

856: SELECT item.payment_item_id,
857: item.actual_amount amount,
858: schedule.payment_schedule_id,
859: schedule.schedule_date
860: FROM pn_payment_items_all item,
861: pn_payment_schedules_all schedule
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

Line 981: l_trx_dt pn_payment_items.due_date%TYPE;

977: l_use_crnt_month BOOLEAN;
978: l_trx_sysdate BOOLEAN;
979:
980: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
981: l_trx_dt pn_payment_items.due_date%TYPE;
982: l_total_amt pn_payment_items.actual_amount%TYPE;
983:
984: l_info VARCHAR2(100);
985: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.prepare_new_items_from_adj';

Line 982: l_total_amt pn_payment_items.actual_amount%TYPE;

978: l_trx_sysdate BOOLEAN;
979:
980: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
981: l_trx_dt pn_payment_items.due_date%TYPE;
982: l_total_amt pn_payment_items.actual_amount%TYPE;
983:
984: l_info VARCHAR2(100);
985: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.prepare_new_items_from_adj';
986:

Line 1098: FROM pn_payment_items_all

1094: CURSOR check_if_sch_belong_to_term(p_sch_id pn_payment_schedules.payment_schedule_id%TYPE) IS
1095: SELECT 'Y'
1096: FROM dual
1097: WHERE EXISTS (SELECT NULL
1098: FROM pn_payment_items_all
1099: WHERE payment_schedule_id = p_sch_id
1100: AND payment_term_id = p_term_id);
1101:
1102: CURSOR org_id_cur IS

Line 1302: -- into the pn_payment_items table. Does BULK operations for

1298:
1299: ------------------------------------------------------------------------------+
1300: -- PROCEDURE : process_items
1301: -- DESCRIPTION : Takes 3 tables for UPDATE, DELETE, and INSERT operation
1302: -- into the pn_payment_items table. Does BULK operations for
1303: -- efficiency.
1304: -- HISTORY :
1305: -- 05-OCT-04 ftanudja o Created.
1306: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables

Line 1310: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,

1306: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
1307: ------------------------------------------------------------------------------+
1308: PROCEDURE process_items(
1309: p_term_id pn_payment_terms.payment_term_id%TYPE,
1310: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,
1311: p_upd_item_tbl payment_item_tbl_type,
1312: p_del_item_tbl payment_item_tbl_type,
1313: p_new_item_tbl IN OUT NOCOPY payment_item_tbl_type
1314: )

Line 1391: UPDATE pn_payment_items_all

1387: EXIT;
1388: END LOOP;
1389:
1390: FORALL i IN 0 .. l_payment_id_tbl.COUNT - 1
1391: UPDATE pn_payment_items_all
1392: SET actual_amount = ROUND(l_act_amt_tbl(i), l_precision),
1393: estimated_amount = ROUND(l_est_amt_tbl(i), l_precision),
1394: last_update_date = SYSDATE,
1395: last_updated_by = fnd_global.user_id,

Line 1412: DELETE pn_payment_items

1408: l_info := ' preparing for bulk delete ';
1409: pnp_debug_pkg.log(l_info);
1410:
1411: FORALL i IN 0 .. l_payment_id_tbl.COUNT - 1
1412: DELETE pn_payment_items
1413: WHERE payment_item_id = l_payment_id_tbl(i);
1414:
1415: l_info := ' creating items ';
1416: pnp_debug_pkg.log(l_info);

Line 1465: INSERT INTO pn_payment_items_all

1461:
1462: END LOOP;
1463:
1464: FORALL i IN 0 .. l_sched_id_tbl.COUNT - 1
1465: INSERT INTO pn_payment_items_all
1466: (
1467: payment_item_id,
1468: last_update_date,
1469: last_updated_by,

Line 1497: pn_payment_items_s.nextval,

1493: org_id
1494: )
1495: VALUES
1496: (
1497: pn_payment_items_s.nextval,
1498: SYSDATE,
1499: fnd_global.user_id,
1500: SYSDATE,
1501: fnd_global.user_id,

Line 1798: FROM pn_payment_items_all item

1794: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD');
1795:
1796: CURSOR find_payment_items_cur (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS
1797: SELECT payment_item_id
1798: FROM pn_payment_items_all item
1799: WHERE item.payment_schedule_id = p_sch_id;
1800:
1801: l_found BOOLEAN;
1802:

Line 1847: FROM pn_payment_items_all item

1843: IS
1844:
1845: CURSOR find_cash_items (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS
1846: SELECT SUM(DECODE(item.payment_item_type_lookup_code, 'CASH', 1, 0)) num_cash
1847: FROM pn_payment_items_all item
1848: WHERE item.payment_schedule_id = p_sch_id;
1849:
1850: CURSOR get_term_data IS
1851: SELECT vendor_id,

Line 1952: INSERT INTO pn_payment_items_all

1948: EXIT;
1949:
1950: END LOOP;
1951:
1952: INSERT INTO pn_payment_items_all
1953: (
1954: payment_item_id,
1955: last_update_date,
1956: last_updated_by,

Line 1982: pn_payment_items_s.nextval,

1978: rate,
1979: org_id
1980: ) VALUES
1981: (
1982: pn_payment_items_s.nextval,
1983: SYSDATE,
1984: fnd_global.user_id,
1985: SYSDATE,
1986: fnd_global.user_id,

Line 2040: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,

2036: -- 14-JAN-05 atuppad o Added code to update total_adj_amount
2037: ------------------------------------------------------------------------------+
2038: PROCEDURE update_terms_history(
2039: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2040: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,
2041: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
2042: p_term_id pn_payment_terms.payment_term_id%TYPE
2043: )
2044: IS

Line 2108: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE

2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2105: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2106: p_term_freq pn_payment_terms.frequency_code%TYPE,
2107: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2108: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE
2109: )
2110: IS
2111: CURSOR get_last_appr_sched IS
2112: SELECT max(schedule_date) schedule_date