APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_PREPAY_HISTORY

Line 1025: FROM AP_PREPAY_HISTORY_ALL APPH, AP_INVOICE_DISTRIBUTIONS AID

1021:
1022: CURSOR prepay_adj_events(l_prepay_app_event_id NUMBER,
1023: l_accounting_date DATE) is
1024: SELECT APPH.accounting_event_id
1025: FROM AP_PREPAY_HISTORY_ALL APPH, AP_INVOICE_DISTRIBUTIONS AID
1026: WHERE APPH.related_prepay_app_Event_id = l_prepay_app_event_id
1027: AND APPH.invoice_adjustment_event_id = AID.accounting_event_id
1028: AND nvl(APPH.posted_flag,'N') = 'N';
1029: --AND AID.accounting_date = l_accounting_date; Commented for bug 10132577

Line 5067: FROM ap_prepay_history_all APPH

5063: AND AID.parent_reversal_id IS NULL
5064: AND NVL(AID.Historical_Flag, 'N') <> 'Y'
5065: AND NOT EXISTS
5066: (SELECT 1
5067: FROM ap_prepay_history_all APPH
5068: WHERE APPH.invoice_id = AID.invoice_id
5069: AND APPH.Invoice_Adjustment_Event_Id = P_Adj_Accounting_Event_Id
5070: AND APPH.Related_Prepay_App_Event_Id = AID.Accounting_Event_Id
5071: AND APPH.transaction_type = 'PREPAYMENT APPLICATION ADJ'

Line 5321: ap_prepay_history_all apph

5317: AND aid.accounting_event_id = p_adj_accounting_event_id
5318: AND NOT EXISTS
5319: (SELECT 1
5320: FROM ap_prepay_app_dists apad,
5321: ap_prepay_history_all apph
5322: WHERE apad.prepay_history_id = apph.prepay_history_id
5323: AND apph.transaction_type = 'PREPAYMENT APPLIED'
5324: AND apph.invoice_id = l_prepay_app_invoice_ids(i)
5325: AND apph.invoice_line_number = l_prepay_app_invoice_line_num(i)

Line 7791: TYPE l_prepay_hist_list IS TABLE OF ap_prepay_history.prepay_history_id%TYPE;

7787: p_calling_sequence IN VARCHAR2)
7788: IS
7789:
7790: l_curr_calling_sequence VARCHAR2(2000);
7791: TYPE l_prepay_hist_list IS TABLE OF ap_prepay_history.prepay_history_id%TYPE;
7792: l_prepay_hist_tab l_prepay_hist_list;
7793: l_related_prepay_app_event_id AP_PREPAY_HISTORY_ALL.related_prepay_app_event_id%TYPE;
7794:
7795: -- Logging:

Line 7793: l_related_prepay_app_event_id AP_PREPAY_HISTORY_ALL.related_prepay_app_event_id%TYPE;

7789:
7790: l_curr_calling_sequence VARCHAR2(2000);
7791: TYPE l_prepay_hist_list IS TABLE OF ap_prepay_history.prepay_history_id%TYPE;
7792: l_prepay_hist_tab l_prepay_hist_list;
7793: l_related_prepay_app_event_id AP_PREPAY_HISTORY_ALL.related_prepay_app_event_id%TYPE;
7794:
7795: -- Logging:
7796: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_Prepayment_Header';
7797: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 7826: UPDATE AP_Prepay_History APH

7822: AND AID.invoice_id = P_invoice_id
7823: AND AID.invoice_line_number = P_invoice_line_number;
7824:
7825:
7826: UPDATE AP_Prepay_History APH
7827: SET Accounting_Event_ID = p_accounting_event_id,
7828: APH.Related_Prepay_App_Event_ID =
7829: CASE
7830: WHEN APH.transaction_type = 'PREPAYMENT UNAPPLIED' AND

Line 8009: INSERT INTO AP_PREPAY_HISTORY_ALL

8005: ELSE
8006: l_transaction_type := PREPAYMENT_UNAPPLIED_TYPE;
8007: END IF;
8008:
8009: INSERT INTO AP_PREPAY_HISTORY_ALL
8010: ( PREPAY_HISTORY_ID
8011: ,PREPAY_INVOICE_ID
8012: ,PREPAY_LINE_NUM
8013: ,ACCOUNTING_EVENT_ID

Line 8033: (AP_PREPAY_HISTORY_S.nextval

8029: ,PROGRAM_ID
8030: ,PROGRAM_UPDATE_DATE
8031: ,REQUEST_ID)
8032: VALUES
8033: (AP_PREPAY_HISTORY_S.nextval
8034: ,l_prepay_invoice_id
8035: ,l_prepay_line_number
8036: ,p_Accounting_event_id
8037: ,'N'

Line 8101: INSERT INTO AP_PREPAY_HISTORY_ALL

8097: ELSE
8098: l_transaction_type := PREPAYMENT_UNAPPLIED_TYPE;
8099: END IF;
8100:
8101: INSERT INTO AP_PREPAY_HISTORY_ALL
8102: ( PREPAY_HISTORY_ID
8103: ,PREPAY_INVOICE_ID
8104: ,PREPAY_LINE_NUM
8105: ,ACCOUNTING_EVENT_ID

Line 8124: (AP_PREPAY_HISTORY_S.nextval

8120: ,PROGRAM_ID
8121: ,PROGRAM_UPDATE_DATE
8122: ,REQUEST_ID)
8123: VALUES
8124: (AP_PREPAY_HISTORY_S.nextval
8125: ,l_prepay_invoice_id
8126: ,l_prepay_line_number
8127: ,p_Accounting_event_id
8128: ,p_accounting_date