8: -- Constants
9: --
10: -- Linefeed character
11: --
12: CRLF CONSTANT VARCHAR2(1) := arp_global.CRLF;
13:
14: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
15: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
16: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
10: -- Linefeed character
11: --
12: CRLF CONSTANT VARCHAR2(1) := arp_global.CRLF;
13:
14: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
15: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
16: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
17: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
18: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER :=
11: --
12: CRLF CONSTANT VARCHAR2(1) := arp_global.CRLF;
13:
14: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
15: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
16: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
17: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
18: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER :=
19: arp_global.MSG_LEVEL_DEVELOP;
12: CRLF CONSTANT VARCHAR2(1) := arp_global.CRLF;
13:
14: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
15: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
16: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
17: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
18: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER :=
19: arp_global.MSG_LEVEL_DEVELOP;
20:
13:
14: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
15: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
16: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
17: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
18: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER :=
19: arp_global.MSG_LEVEL_DEVELOP;
20:
21: YES CONSTANT VARCHAR2(1) := arp_global.YES;
15: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
16: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
17: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
18: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER :=
19: arp_global.MSG_LEVEL_DEVELOP;
20:
21: YES CONSTANT VARCHAR2(1) := arp_global.YES;
22: NO CONSTANT VARCHAR2(1) := arp_global.NO;
23:
17: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
18: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER :=
19: arp_global.MSG_LEVEL_DEVELOP;
20:
21: YES CONSTANT VARCHAR2(1) := arp_global.YES;
22: NO CONSTANT VARCHAR2(1) := arp_global.NO;
23:
24: DEP CONSTANT VARCHAR2(10) := 'DEP';
25: GUAR CONSTANT VARCHAR2(10) := 'GUAR';
18: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER :=
19: arp_global.MSG_LEVEL_DEVELOP;
20:
21: YES CONSTANT VARCHAR2(1) := arp_global.YES;
22: NO CONSTANT VARCHAR2(1) := arp_global.NO;
23:
24: DEP CONSTANT VARCHAR2(10) := 'DEP';
25: GUAR CONSTANT VARCHAR2(10) := 'GUAR';
26:
1105: /* anjprasa bug 13574852 : merged both if else block in one
1106: and added delete XLA event before deleting adjustment */
1107:
1108: l_event_source_info.entity_type_code:= 'ADJUSTMENTS';
1109: l_security.security_id_int_1 := arp_global.sysparam.org_id;
1110: l_event_source_info.application_id := 222;
1111: l_event_source_info.ledger_id := arp_standard.sysparm.set_of_books_id;
1112:
1113: OPEN get_adj_event_id(p_customer_trx_id,p_subsequent_trx_id);
1119:
1120: IF PG_DEBUG in ('Y', 'C') THEN
1121: print_fcn_label(' l_event_id='|| l_event_id );
1122: print_fcn_label(' l_source_id_int_1='|| l_source_id_int_1 );
1123: print_fcn_label(' arp_global.sysparam.org_id='|| arp_global.sysparam.org_id );
1124: print_fcn_label(' arp_standard.sysparm.set_of_books_id='|| arp_standard.sysparm.set_of_books_id );
1125: END IF;
1126: l_event_source_info.source_id_int_1 := l_source_id_int_1;
1127: /* first delete xla record and then delete from adjustment*/