APPS.PN_CREATE_ACC dependencies on PN_AE_LINES

Line 731: -- 14-jul-05 sdmahesh o Bug 4284035 - Replaced pn_ae_headers,pn_ae_lines pnl

727: -- PROCDURE : CREATE_ACC
728: -- INVOKED FROM :
729: -- PURPOSE :
730: -- HISTORY :
731: -- 14-jul-05 sdmahesh o Bug 4284035 - Replaced pn_ae_headers,pn_ae_lines pnl
732: -- with _ALL table.
733: -- 01-DEC-05 Hareesha o passed pn_mo_cache_utils.get_current_org_id to
734: -- get_profile_value.
735: -- 01-DEC-05 Hareesha o Added check to call c_default_gl_period only

Line 779: pn_ae_lines_all pnl

775: CURSOR c_min_max_date IS
776: SELECT min(accounting_date),
777: max(accounting_date)
778: FROM pn_ae_headers_all pnh,
779: pn_ae_lines_all pnl
780: WHERE pnh.ae_header_id = pnl.ae_header_id
781: AND pnl.gl_sl_link_id IS NULL ;
782:
783: BEGIN

Line 1101: l_LINE_ID PN_AE_LINES.AE_LINE_ID%TYPE;

1097: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1098: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1099: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;
1100: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%TYPE;
1101: l_LINE_ID PN_AE_LINES.AE_LINE_ID%TYPE;
1102: l_EVENT_ID PN_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID%TYPE;
1103: l_event_number NUMBER;
1104: l_rev_number NUMBER;
1105: l_unearn_number NUMBER;

Line 1549: INSERT INTO PN_AE_LINES_ALL

1545:
1546: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1547: l_rev_number := l_rev_number + 1;
1548:
1549: INSERT INTO PN_AE_LINES_ALL
1550: (
1551: AE_LINE_ID ,
1552: AE_HEADER_ID ,
1553: AE_LINE_NUMBER ,

Line 1581: PN_AE_LINES_S.NEXTVAL,

1577: REQUEST_ID
1578: )
1579: VALUES
1580: (
1581: PN_AE_LINES_S.NEXTVAL,
1582: L_HEADER_ID,
1583: l_rev_number,
1584: rev_acnt_tab(i).account_class,
1585: rev_acnt_tab(i).account_id,

Line 1663: INSERT INTO PN_AE_LINES_ALL

1659: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1660:
1661: l_unearn_number := l_unearn_number + 1;
1662:
1663: INSERT INTO PN_AE_LINES_ALL
1664: (
1665: AE_LINE_ID ,
1666: AE_HEADER_ID ,
1667: AE_LINE_NUMBER ,

Line 1694: PN_AE_LINES_S.nextval,

1690: PROGRAM_ID ,
1691: REQUEST_ID
1692: )
1693: VALUES (
1694: PN_AE_LINES_S.nextval,
1695: L_HEADER_ID,
1696: l_unearn_number,
1697: acc_acnt_tab(i).account_class ,
1698: acc_acnt_tab(i).account_id,

Line 1854: l_LINE_ID PN_AE_LINES.AE_LINE_ID%type;

1850: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1851: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1852: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;
1853: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%type;
1854: l_LINE_ID PN_AE_LINES.AE_LINE_ID%type;
1855: l_EVENT_ID PN_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID%type;
1856: l_event_number number;
1857: l_exp_number number;
1858: l_acc_number number;

Line 2309: INSERT INTO PN_AE_LINES_ALL

2305:
2306: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2307: l_exp_number := l_exp_number +1;
2308:
2309: INSERT INTO PN_AE_LINES_ALL
2310: (
2311: AE_LINE_ID ,
2312: AE_HEADER_ID ,
2313: AE_LINE_NUMBER ,

Line 2341: PN_AE_LINES_S.nextval,

2337: REQUEST_ID
2338: )
2339: VALUES
2340: (
2341: PN_AE_LINES_S.nextval,
2342: L_HEADER_ID,
2343: l_exp_number,
2344: exp_acnt_tab(i).account_class,
2345: exp_acnt_tab(i).account_id,

Line 2424: INSERT INTO PN_AE_LINES_ALL

2420:
2421:
2422: l_acc_number := l_acc_number +1;
2423:
2424: INSERT INTO PN_AE_LINES_ALL
2425: (
2426: AE_LINE_ID ,
2427: AE_HEADER_ID ,
2428: AE_LINE_NUMBER ,

Line 2456: PN_AE_LINES_S.nextval,

2452: REQUEST_ID
2453: )
2454: VALUES
2455: (
2456: PN_AE_LINES_S.nextval,
2457: L_HEADER_ID,
2458: l_acc_number,
2459: acc_acnt_tab(i).account_class ,
2460: acc_acnt_tab(i).account_id,