DBA Data[Home] [Help]

PACKAGE: APPS.IEX_TRX_VIEW_PKG

Source


1 PACKAGE IEX_TRX_VIEW_PKG AUTHID CURRENT_USER AS
2 /* $Header: iexttvws.pls 120.2 2004/10/14 13:49:33 jypark ship $ */
3 TYPE postQueryRecType IS RECORD
4 (
5   customer_trx_id NUMBER,
6   payment_schedule_id NUMBER,
7   delinquency_id NUMBER,
8   promised_flag VARCHAR2(100),
9   paid_flag VARCHAR2(100),
10   sales_order VARCHAR2(50),
11   trx_score NUMBER,
12   strategy_name VARCHAR2(240)
13 );
14 
15 TYPE postQueryTabType IS TABLE OF postQueryRecType INDEX BY BINARY_INTEGER;
16 
17 FUNCTION is_paid(p_payment_schedule_id NUMBER) RETURN NUMBER;
18 FUNCTION is_promised(p_delinquency_id NUMBER) RETURN NUMBER;
19 FUNCTION get_sales_order(p_customer_trx_id NUMBER) RETURN VARCHAR2;
20 FUNCTION get_score(p_payment_schedule_id NUMBER) RETURN NUMBER;
21 FUNCTION get_strategy_name(p_delinquency_id NUMBER) RETURN VARCHAR2;
22 
23 -- clchang added 11/11/2002
24 -- for IEX_DUNNINGS_ACCT_BALI_V
25 FUNCTION get_party_id(p_account_id NUMBER) RETURN NUMBER;
26 
27 PROCEDURE post_query_trx(p_trx_tab IN OUT NOCOPY postQueryTabType, p_type IN VARCHAR2);
28 
29 END;