APPS.PN_CREATE_ACC dependencies on PN_AE_HEADERS

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

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

Line 1568: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%TYPE;

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

Line 1922: INSERT INTO PN_AE_HEADERS_ALL

1918:
1919: l_header_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1920:
1921:
1922: INSERT INTO PN_AE_HEADERS_ALL
1923: (AE_HEADER_ID ,
1924: ACCOUNTING_EVENT_ID ,
1925: SET_OF_BOOKS_ID ,
1926: AE_CATEGORY ,

Line 1946: (PN_AE_HEADERS_S.nextval,

1942: REQUEST_ID ,
1943: ACCOUNTING_ERROR_CODE
1944: )
1945: VALUES
1946: (PN_AE_HEADERS_S.nextval,
1947: l_EVENT_ID,
1948: l_set_of_books_id ,
1949: 'PM REVENUE' ,
1950: 'N',

Line 2321: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%type;

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

Line 2680: INSERT INTO PN_AE_HEADERS_ALL

2676: CLOSE c_lease_num;
2677:
2678: l_header_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2679:
2680: INSERT INTO PN_AE_HEADERS_ALL
2681: (
2682: AE_HEADER_ID ,
2683: ACCOUNTING_EVENT_ID ,
2684: SET_OF_BOOKS_ID ,

Line 2706: PN_AE_HEADERS_S.nextval,

2702: ACCOUNTING_ERROR_CODE
2703: )
2704: VALUES
2705: (
2706: PN_AE_HEADERS_S.nextval,
2707: l_EVENT_ID,
2708: l_set_of_books_id ,
2709: 'PM EXPENSE' ,
2710: 'N',