APPS.PN_CREATE_ACC dependencies on PN_ACCOUNTING_EVENTS

Line 1570: l_EVENT_ID PN_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID%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;
1574: v_pn_accounted_amount NUMBER;

Line 1861: FROM PN_ACCOUNTING_EVENTS_ALL

1857: END LOOP;
1858:
1859: SELECT nvl(max(event_number),0) + 1
1860: INTO l_event_number
1861: FROM PN_ACCOUNTING_EVENTS_ALL
1862: WHERE source_table = 'PN_PAYMENT_TERMS'
1863: AND SOURCE_ID = v_pn_payment_term_id
1864: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1865:

Line 1868: INSERT INTO PN_ACCOUNTING_EVENTS_ALL

1864: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1865:
1866: pnp_debug_pkg.log('Before event insert');
1867:
1868: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
1869: (
1870: ACCOUNTING_EVENT_ID ,
1871: EVENT_TYPE_CODE ,
1872: ACCOUNTING_DATE ,

Line 1890: (PN_ACCOUNTING_EVENTS_S.nextval,

1886: ORG_ID ,
1887: CANNOT_ACCOUNT_FLAG
1888: )
1889: VALUES
1890: (PN_ACCOUNTING_EVENTS_S.nextval,
1891: nvl(V_PN_EVENT_TYPE_CODE ,'ABS'),
1892: SYSDATE,
1893: l_event_number,
1894: 'ACCOUNTED',

Line 2323: l_EVENT_ID PN_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID%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;
2327: v_pn_accounted_amount number;

Line 2615: FROM pn_accounting_events_all

2611: END LOOP;
2612:
2613: SELECT nvl(max(event_number),0) + 1
2614: INTO l_event_number
2615: FROM pn_accounting_events_all
2616: WHERE source_table = 'PN_PAYMENT_TERMS'
2617: AND SOURCE_ID = v_pn_payment_term_id
2618: AND EVENT_TYPE_CODE = v_pn_event_type_code;
2619:

Line 2623: l_context := 'Inserting into PN_ACCOUNTING_EVENTS';

2619:
2620: pnp_debug_pkg.log('Before event insert');
2621:
2622:
2623: l_context := 'Inserting into PN_ACCOUNTING_EVENTS';
2624:
2625: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
2626: (
2627: ACCOUNTING_EVENT_ID ,

Line 2625: INSERT INTO PN_ACCOUNTING_EVENTS_ALL

2621:
2622:
2623: l_context := 'Inserting into PN_ACCOUNTING_EVENTS';
2624:
2625: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
2626: (
2627: ACCOUNTING_EVENT_ID ,
2628: EVENT_TYPE_CODE ,
2629: ACCOUNTING_DATE ,

Line 2648: PN_ACCOUNTING_EVENTS_S.nextval,

2644: CANNOT_ACCOUNT_FLAG
2645: )
2646: VALUES
2647: (
2648: PN_ACCOUNTING_EVENTS_S.nextval,
2649: nvl(V_PN_EVENT_TYPE_CODE ,'ABS') ,
2650: SYSDATE,
2651: l_event_number,
2652: 'ACCOUNTED',