APPS.GMF_MEMO_INTERFACE dependencies on RA_CUSTOMER_TRX_ALL

Line 3: last_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

1: PACKAGE BODY GMF_MEMO_INTERFACE AS
2: /* $Header: gmfarmob.pls 115.10 2002/11/11 00:29:34 rseshadr ship $ */
3: last_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
4: process_errors BOOLEAN;
5: PROCEDURE update_state (p_customer_trx_id IN NUMBER) IS
6: max_id NUMBER;
7: BEGIN

Line 32: t_customer_trx_id1 ra_customer_trx_all.customer_trx_id%type;

28: t_customer_trx_id OUT NOCOPY NUMBER,
29: t_trx_type OUT NOCOPY VARCHAR2,
30: error_status OUT NOCOPY NUMBER
31: ) IS
32: t_customer_trx_id1 ra_customer_trx_all.customer_trx_id%type;
33: t_trx_type1 ra_cust_trx_types_all.type%type;
34: t_interface_date DATE; /* Bug 2403594 */
35: BEGIN
36: error_status := 0;

Line 54: FROM ra_customer_trx_all rct,

50: (customer_trx_id, updated_flag, interface_date)
51: (
52: SELECT
53: distinct rct.customer_trx_id,'N', NULL
54: FROM ra_customer_trx_all rct,
55: ra_cust_trx_types_all rctt
56: WHERE
57: rct.cust_trx_type_id = rctt.cust_trx_type_id
58: AND rctt.TYPE IN ('CM', 'DM')

Line 82: FROM ra_customer_trx_all rct,

78: INTO t_customer_trx_id1, t_trx_type1
79: FROM (
80: SELECT rct.customer_trx_id,
81: rctt.type
82: FROM ra_customer_trx_all rct,
83: ra_cust_trx_types_all rctt,
84: gl_memo_sta ams
85: WHERE rct.customer_trx_id = ams.customer_trx_id
86: AND rct.customer_trx_id > last_trx_id

Line 147: ra_customer_trx_all rct

143: ) IS
144: CURSOR tran_type_cur(t_customer_trx_id IN NUMBER) IS
145: SELECT NVL(rctt.attribute10, ' ')
146: FROM ra_cust_trx_types_all rctt,
147: ra_customer_trx_all rct
148: WHERE rct.customer_trx_id = t_customer_trx_id
149: AND rct.cust_trx_type_id = rctt.cust_trx_type_id;
150: t_rctt_attribute10 ra_cust_trx_types_all.attribute10%type;
151: