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: (
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 ,
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,
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*/
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: ) ;
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
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
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;
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),
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
2177: p_from_llca_call IN varchar2 DEFAULT 'N'
2178: ) IS
2179:
2180: l_index number;
2181: l_set_of_books_id ar_receivables_trx.set_of_books_id%type := NULL;
2182: l_cc_id ar_receivables_trx.code_combination_id%type := NULL;
2183: l_count number;
2184: l_found BOOLEAN;
2185: l_accounting_affect_flag varchar2(1);
2178: ) IS
2179:
2180: l_index number;
2181: l_set_of_books_id ar_receivables_trx.set_of_books_id%type := NULL;
2182: l_cc_id ar_receivables_trx.code_combination_id%type := NULL;
2183: l_count number;
2184: l_found BOOLEAN;
2185: l_accounting_affect_flag varchar2(1);
2186: l_receivable_trx_type ar_receivables_trx.TYPE%type := NULL;
2182: l_cc_id ar_receivables_trx.code_combination_id%type := NULL;
2183: l_count number;
2184: l_found BOOLEAN;
2185: l_accounting_affect_flag varchar2(1);
2186: l_receivable_trx_type ar_receivables_trx.TYPE%type := NULL;
2187: l_gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type; /*Bug 2925924*/
2188:
2189: -- Line Level Adjustment
2190: l_customer_trx_id number;
2183: l_count number;
2184: l_found BOOLEAN;
2185: l_accounting_affect_flag varchar2(1);
2186: l_receivable_trx_type ar_receivables_trx.TYPE%type := NULL;
2187: l_gl_account_source ar_receivables_trx.GL_ACCOUNT_SOURCE%type; /*Bug 2925924*/
2188:
2189: -- Line Level Adjustment
2190: l_customer_trx_id number;
2191: l_customer_trx_line_id number;