eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_ADJVALIDATE_PVT 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: G_cache_org_id ar_receivables_trx.org_id%TYPE;
15:
16: TYPE Context_Rec_Type IS RECORD
17: (

Line 14: G_cache_org_id ar_receivables_trx.org_id%TYPE;

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: G_cache_org_id ar_receivables_trx.org_id%TYPE;
15:
16: TYPE Context_Rec_Type IS RECORD
17: (
18: validation_level NUMBER ,

Line 46: receivables_trx_id ar_receivables_trx.RECEIVABLES_TRX_ID%type,

42: | accounting_affect_flag is set to 'N' |
43: +---------------------------------------------------------------------------*/
44: TYPE Rcvtrx_Rec_Type IS RECORD
45: (
46: receivables_trx_id ar_receivables_trx.RECEIVABLES_TRX_ID%type,
47: name ar_receivables_trx.NAME%type,
48: type ar_receivables_trx.TYPE%type,
49: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type,
50: accounting_affect_flag ar_receivables_trx.ACCOUNTING_AFFECT_FLAG%type,

Line 47: name ar_receivables_trx.NAME%type,

43: +---------------------------------------------------------------------------*/
44: TYPE Rcvtrx_Rec_Type IS RECORD
45: (
46: receivables_trx_id ar_receivables_trx.RECEIVABLES_TRX_ID%type,
47: name ar_receivables_trx.NAME%type,
48: type ar_receivables_trx.TYPE%type,
49: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type,
50: accounting_affect_flag ar_receivables_trx.ACCOUNTING_AFFECT_FLAG%type,
51: gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type /*Bug 2925924*/

Line 48: type ar_receivables_trx.TYPE%type,

44: TYPE Rcvtrx_Rec_Type IS RECORD
45: (
46: receivables_trx_id ar_receivables_trx.RECEIVABLES_TRX_ID%type,
47: name ar_receivables_trx.NAME%type,
48: type ar_receivables_trx.TYPE%type,
49: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type,
50: accounting_affect_flag ar_receivables_trx.ACCOUNTING_AFFECT_FLAG%type,
51: gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type /*Bug 2925924*/
52: ) ;

Line 49: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type,

45: (
46: receivables_trx_id ar_receivables_trx.RECEIVABLES_TRX_ID%type,
47: name ar_receivables_trx.NAME%type,
48: type ar_receivables_trx.TYPE%type,
49: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type,
50: accounting_affect_flag ar_receivables_trx.ACCOUNTING_AFFECT_FLAG%type,
51: gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type /*Bug 2925924*/
52: ) ;
53: TYPE Rcvtrx_Cache_Tbl_type IS

Line 50: accounting_affect_flag ar_receivables_trx.ACCOUNTING_AFFECT_FLAG%type,

46: receivables_trx_id ar_receivables_trx.RECEIVABLES_TRX_ID%type,
47: name ar_receivables_trx.NAME%type,
48: type ar_receivables_trx.TYPE%type,
49: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type,
50: accounting_affect_flag ar_receivables_trx.ACCOUNTING_AFFECT_FLAG%type,
51: gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type /*Bug 2925924*/
52: ) ;
53: TYPE Rcvtrx_Cache_Tbl_type IS
54: TABLE OF Rcvtrx_Rec_Type

Line 51: gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type /Bug 2925924/

47: name ar_receivables_trx.NAME%type,
48: type ar_receivables_trx.TYPE%type,
49: code_combination_id ar_receivables_trx.CODE_COMBINATION_ID%type,
50: accounting_affect_flag ar_receivables_trx.ACCOUNTING_AFFECT_FLAG%type,
51: gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type /*Bug 2925924*/
52: ) ;
53: TYPE Rcvtrx_Cache_Tbl_type IS
54: TABLE OF Rcvtrx_Rec_Type
55: INDEX BY BINARY_INTEGER;

Line 591: FROM ar_receivables_trx

587:
588: CURSOR l_receivables_csr IS
589: SELECT receivables_trx_id,name,type,code_combination_id ,accounting_affect_flag,
590: gl_account_source /*Bug 2925924*/
591: FROM ar_receivables_trx
592: WHERE nvl(status,'A') = 'A'
593: AND type in ('ADJUST','ENDORSEMENT','FINCHRG')
594: AND receivables_trx_id not in (-11,-13 )
595: AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),

Line 890: l_current_org_id ar_receivables_trx.org_id%TYPE;

886: ) IS
887:
888: l_tobe_cached_flag varchar2(1) ;
889: l_return_status varchar2(1);
890: l_current_org_id ar_receivables_trx.org_id%TYPE;
891:
892: BEGIN
893:
894: IF PG_DEBUG in ('Y', 'C') THEN

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

2202: p_from_llca_call IN varchar2 DEFAULT 'N'
2203: ) IS
2204:
2205: l_index number;
2206: l_set_of_books_id ar_receivables_trx.set_of_books_id%type := NULL;
2207: l_cc_id ar_receivables_trx.code_combination_id%type := NULL;
2208: l_count number;
2209: l_found BOOLEAN;
2210: l_accounting_affect_flag varchar2(1);

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

2203: ) IS
2204:
2205: l_index number;
2206: l_set_of_books_id ar_receivables_trx.set_of_books_id%type := NULL;
2207: l_cc_id ar_receivables_trx.code_combination_id%type := NULL;
2208: l_count number;
2209: l_found BOOLEAN;
2210: l_accounting_affect_flag varchar2(1);
2211: l_receivable_trx_type ar_receivables_trx.TYPE%type := NULL;

Line 2211: l_receivable_trx_type ar_receivables_trx.TYPE%type := NULL;

2207: l_cc_id ar_receivables_trx.code_combination_id%type := NULL;
2208: l_count number;
2209: l_found BOOLEAN;
2210: l_accounting_affect_flag varchar2(1);
2211: l_receivable_trx_type ar_receivables_trx.TYPE%type := NULL;
2212: l_gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type; /*Bug 2925924*/
2213:
2214: -- Line Level Adjustment
2215: l_customer_trx_id number;

Line 2212: l_gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type; /Bug 2925924/

2208: l_count number;
2209: l_found BOOLEAN;
2210: l_accounting_affect_flag varchar2(1);
2211: l_receivable_trx_type ar_receivables_trx.TYPE%type := NULL;
2212: l_gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type; /*Bug 2925924*/
2213:
2214: -- Line Level Adjustment
2215: l_customer_trx_id number;
2216: l_customer_trx_line_id number;