APPS.PN_CREATE_ACC dependencies on PN_ACCOUNTING_EVENTS

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

Line 1393: FROM PN_ACCOUNTING_EVENTS_ALL

1389: END LOOP;
1390:
1391: SELECT nvl(max(event_number),0) + 1
1392: INTO l_event_number
1393: FROM PN_ACCOUNTING_EVENTS_ALL
1394: WHERE source_table = 'PN_PAYMENT_TERMS'
1395: AND SOURCE_ID = v_pn_payment_term_id
1396: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1397:

Line 1400: INSERT INTO PN_ACCOUNTING_EVENTS_ALL

1396: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1397:
1398: pnp_debug_pkg.log('Before event insert');
1399:
1400: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
1401: (
1402: ACCOUNTING_EVENT_ID ,
1403: EVENT_TYPE_CODE ,
1404: ACCOUNTING_DATE ,

Line 1422: (PN_ACCOUNTING_EVENTS_S.nextval,

1418: ORG_ID ,
1419: CANNOT_ACCOUNT_FLAG
1420: )
1421: VALUES
1422: (PN_ACCOUNTING_EVENTS_S.nextval,
1423: nvl(V_PN_EVENT_TYPE_CODE ,'ABS'),
1424: SYSDATE,
1425: l_event_number,
1426: 'ACCOUNTED',

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

Line 2147: FROM pn_accounting_events_all

2143: END LOOP;
2144:
2145: SELECT nvl(max(event_number),0) + 1
2146: INTO l_event_number
2147: FROM pn_accounting_events_all
2148: WHERE source_table = 'PN_PAYMENT_TERMS'
2149: AND SOURCE_ID = v_pn_payment_term_id
2150: AND EVENT_TYPE_CODE = v_pn_event_type_code;
2151:

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

2151:
2152: pnp_debug_pkg.log('Before event insert');
2153:
2154:
2155: l_context := 'Inserting into PN_ACCOUNTING_EVENTS';
2156:
2157: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
2158: (
2159: ACCOUNTING_EVENT_ID ,

Line 2157: INSERT INTO PN_ACCOUNTING_EVENTS_ALL

2153:
2154:
2155: l_context := 'Inserting into PN_ACCOUNTING_EVENTS';
2156:
2157: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
2158: (
2159: ACCOUNTING_EVENT_ID ,
2160: EVENT_TYPE_CODE ,
2161: ACCOUNTING_DATE ,

Line 2180: PN_ACCOUNTING_EVENTS_S.nextval,

2176: CANNOT_ACCOUNT_FLAG
2177: )
2178: VALUES
2179: (
2180: PN_ACCOUNTING_EVENTS_S.nextval,
2181: nvl(V_PN_EVENT_TYPE_CODE ,'ABS') ,
2182: SYSDATE,
2183: l_event_number,
2184: 'ACCOUNTED',