APPS.PN_CREATE_ACC dependencies on PN_AE_HEADERS

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 778: FROM pn_ae_headers_all pnh,

774:
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:

Line 1100: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%TYPE;

1096: ,pn_mo_cache_utils.get_current_org_id));
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;

Line 1454: INSERT INTO PN_AE_HEADERS_ALL

1450:
1451: l_header_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1452:
1453:
1454: INSERT INTO PN_AE_HEADERS_ALL
1455: (AE_HEADER_ID ,
1456: ACCOUNTING_EVENT_ID ,
1457: SET_OF_BOOKS_ID ,
1458: AE_CATEGORY ,

Line 1478: (PN_AE_HEADERS_S.nextval,

1474: REQUEST_ID ,
1475: ACCOUNTING_ERROR_CODE
1476: )
1477: VALUES
1478: (PN_AE_HEADERS_S.nextval,
1479: l_EVENT_ID,
1480: l_set_of_books_id ,
1481: 'PM REVENUE' ,
1482: 'N',

Line 1853: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%type;

1849: pn_mo_cache_utils.get_current_org_id));
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;

Line 2212: INSERT INTO PN_AE_HEADERS_ALL

2208: CLOSE c_lease_num;
2209:
2210: l_header_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2211:
2212: INSERT INTO PN_AE_HEADERS_ALL
2213: (
2214: AE_HEADER_ID ,
2215: ACCOUNTING_EVENT_ID ,
2216: SET_OF_BOOKS_ID ,

Line 2238: PN_AE_HEADERS_S.nextval,

2234: ACCOUNTING_ERROR_CODE
2235: )
2236: VALUES
2237: (
2238: PN_AE_HEADERS_S.nextval,
2239: l_EVENT_ID,
2240: l_set_of_books_id ,
2241: 'PM EXPENSE' ,
2242: 'N',