APPS.AR_ADJVALIDATE_PUB dependencies on AR_RECEIVABLES_TRX

Line 13: G_receivables_name ar_receivables_trx.name%type := NULL;

9: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
10:
11: G_caching_done varchar2(1) := FND_API.G_FALSE;
12: G_cache_date date := NULL ;
13: G_receivables_name ar_receivables_trx.name%type := NULL;
14:
15: TYPE Context_Rec_Type IS RECORD
16: (
17: validation_level NUMBER ,

Line 39: receivables_trx_id ar_receivables_trx.RECEIVABLES_TRX_ID%type,

35: INDEX BY BINARY_INTEGER;
36:
37: TYPE Rcvtrx_Rec_Type IS RECORD
38: (
39: receivables_trx_id ar_receivables_trx.RECEIVABLES_TRX_ID%type,
40: name ar_receivables_trx.NAME%type,
41: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type
42: ) ;
43: TYPE Rcvtrx_Cache_Tbl_type IS

Line 40: name ar_receivables_trx.NAME%type,

36:
37: TYPE Rcvtrx_Rec_Type IS RECORD
38: (
39: receivables_trx_id ar_receivables_trx.RECEIVABLES_TRX_ID%type,
40: name ar_receivables_trx.NAME%type,
41: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type
42: ) ;
43: TYPE Rcvtrx_Cache_Tbl_type IS
44: TABLE OF Rcvtrx_Rec_Type

Line 41: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type

37: TYPE Rcvtrx_Rec_Type IS RECORD
38: (
39: receivables_trx_id ar_receivables_trx.RECEIVABLES_TRX_ID%type,
40: name ar_receivables_trx.NAME%type,
41: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type
42: ) ;
43: TYPE Rcvtrx_Cache_Tbl_type IS
44: TABLE OF Rcvtrx_Rec_Type
45: INDEX BY BINARY_INTEGER;

Line 651: FROM ar_receivables_trx

647: IS
648:
649: CURSOR l_receivables_csr IS
650: SELECT receivables_trx_id,name,code_combination_id
651: FROM ar_receivables_trx
652: WHERE nvl(status,'A') = 'A'
653: AND type in ('ADJUST','ENDORSEMENT')
654: AND receivables_trx_id not in ( -1,-11,-12,-13 )
655: AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),

Line 1942: l_set_of_books_id ar_receivables_trx.set_of_books_id%type := NULL;

1938: p_return_status IN OUT NOCOPY varchar2
1939: ) IS
1940:
1941: l_index number;
1942: l_set_of_books_id ar_receivables_trx.set_of_books_id%type := NULL;
1943: l_cc_id ar_receivables_trx.code_combination_id%type := NULL;
1944: l_count number;
1945: l_found BOOLEAN;
1946: BEGIN

Line 1943: l_cc_id ar_receivables_trx.code_combination_id%type := NULL;

1939: ) IS
1940:
1941: l_index number;
1942: l_set_of_books_id ar_receivables_trx.set_of_books_id%type := NULL;
1943: l_cc_id ar_receivables_trx.code_combination_id%type := NULL;
1944: l_count number;
1945: l_found BOOLEAN;
1946: BEGIN
1947: