APPS.PN_CREATE_ACC dependencies on PN_AE_LINES

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

1195: -- PROCDURE : CREATE_ACC
1196: -- INVOKED FROM :
1197: -- PURPOSE :
1198: -- HISTORY :
1199: -- 14-jul-05 sdmahesh o Bug 4284035 - Replaced pn_ae_headers,pn_ae_lines pnl
1200: -- with _ALL table.
1201: -- 01-DEC-05 Hareesha o passed pn_mo_cache_utils.get_current_org_id to
1202: -- get_profile_value.
1203: -- 01-DEC-05 Hareesha o Added check to call c_default_gl_period only

Line 1247: pn_ae_lines_all pnl

1243: CURSOR c_min_max_date IS
1244: SELECT min(accounting_date),
1245: max(accounting_date)
1246: FROM pn_ae_headers_all pnh,
1247: pn_ae_lines_all pnl
1248: WHERE pnh.ae_header_id = pnl.ae_header_id
1249: AND pnl.gl_sl_link_id IS NULL ;
1250:
1251: BEGIN

Line 1569: l_LINE_ID PN_AE_LINES.AE_LINE_ID%TYPE;

1565: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1566: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1567: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;
1568: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%TYPE;
1569: l_LINE_ID PN_AE_LINES.AE_LINE_ID%TYPE;
1570: l_EVENT_ID PN_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID%TYPE;
1571: l_event_number NUMBER;
1572: l_rev_number NUMBER;
1573: l_unearn_number NUMBER;

Line 2017: INSERT INTO PN_AE_LINES_ALL

2013:
2014: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2015: l_rev_number := l_rev_number + 1;
2016:
2017: INSERT INTO PN_AE_LINES_ALL
2018: (
2019: AE_LINE_ID ,
2020: AE_HEADER_ID ,
2021: AE_LINE_NUMBER ,

Line 2049: PN_AE_LINES_S.NEXTVAL,

2045: REQUEST_ID
2046: )
2047: VALUES
2048: (
2049: PN_AE_LINES_S.NEXTVAL,
2050: L_HEADER_ID,
2051: l_rev_number,
2052: rev_acnt_tab(i).account_class,
2053: rev_acnt_tab(i).account_id,

Line 2131: INSERT INTO PN_AE_LINES_ALL

2127: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2128:
2129: l_unearn_number := l_unearn_number + 1;
2130:
2131: INSERT INTO PN_AE_LINES_ALL
2132: (
2133: AE_LINE_ID ,
2134: AE_HEADER_ID ,
2135: AE_LINE_NUMBER ,

Line 2162: PN_AE_LINES_S.nextval,

2158: PROGRAM_ID ,
2159: REQUEST_ID
2160: )
2161: VALUES (
2162: PN_AE_LINES_S.nextval,
2163: L_HEADER_ID,
2164: l_unearn_number,
2165: acc_acnt_tab(i).account_class ,
2166: acc_acnt_tab(i).account_id,

Line 2322: l_LINE_ID PN_AE_LINES.AE_LINE_ID%type;

2318: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
2319: l_conv_rate_type pn_currencies.conversion_type%TYPE;
2320: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;
2321: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%type;
2322: l_LINE_ID PN_AE_LINES.AE_LINE_ID%type;
2323: l_EVENT_ID PN_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID%type;
2324: l_event_number number;
2325: l_exp_number number;
2326: l_acc_number number;

Line 2777: INSERT INTO PN_AE_LINES_ALL

2773:
2774: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2775: l_exp_number := l_exp_number +1;
2776:
2777: INSERT INTO PN_AE_LINES_ALL
2778: (
2779: AE_LINE_ID ,
2780: AE_HEADER_ID ,
2781: AE_LINE_NUMBER ,

Line 2809: PN_AE_LINES_S.nextval,

2805: REQUEST_ID
2806: )
2807: VALUES
2808: (
2809: PN_AE_LINES_S.nextval,
2810: L_HEADER_ID,
2811: l_exp_number,
2812: exp_acnt_tab(i).account_class,
2813: exp_acnt_tab(i).account_id,

Line 2892: INSERT INTO PN_AE_LINES_ALL

2888:
2889:
2890: l_acc_number := l_acc_number +1;
2891:
2892: INSERT INTO PN_AE_LINES_ALL
2893: (
2894: AE_LINE_ID ,
2895: AE_HEADER_ID ,
2896: AE_LINE_NUMBER ,

Line 2924: PN_AE_LINES_S.nextval,

2920: REQUEST_ID
2921: )
2922: VALUES
2923: (
2924: PN_AE_LINES_S.nextval,
2925: L_HEADER_ID,
2926: l_acc_number,
2927: acc_acnt_tab(i).account_class ,
2928: acc_acnt_tab(i).account_id,