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.JAI_CMN_RG_MASTER_ORG_PKG dependencies on JAI_CMN_RG_OTHERS

Line 27: Resolution : When populating jai_cmn_rg_23ac_ii_trxs and jai_cmn_rg_others

23: Description : When doing consolidation, the rg23 part 2 records for master
24: organization gets inserted with the creation_date as sysdate. But the RG23
25: part II report is filtering the rows based on creation date. Due to this
26: the report output becomes wrong.
27: Resolution : When populating jai_cmn_rg_23ac_ii_trxs and jai_cmn_rg_others
28: table for the master org, creation_date (and other who columns) are copied from
29: the child org record instead of using the session values.
30: Following procedures are modified:
31: 1. consolidate_rg23_part_ii

Line 50: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,

46: PROCEDURE insert_rg23_others
47: (ERRBUF OUT NOCOPY VARCHAR2,
48: RETCODE OUT NOCOPY VARCHAR2,
49: p_previous_serial_no IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE,
50: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,
51: p_register_id IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE)
52: AS
53: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
54: Select *

Line 53: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS

49: p_previous_serial_no IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE,
50: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,
51: p_register_id IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE)
52: AS
53: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
54: Select *
55: from JAI_CMN_RG_OTHERS
56: where source_register_id = p_register_id
57: and source_type = 1

Line 55: from JAI_CMN_RG_OTHERS

51: p_register_id IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE)
52: AS
53: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
54: Select *
55: from JAI_CMN_RG_OTHERS
56: where source_register_id = p_register_id
57: and source_type = 1
58: and tax_type = p_tax_type;
59:

Line 71: PURPOSE : To consolidate the data in the table JAI_CMN_RG_OTHERS as a part of the Master-Org Consolidation

67: Harshita J: /**********************************************************************
68: CREATED BY : hjujjuru
69: CREATED DATE : 11-JAN-2005
70: ENHANCEMENT BUG : 4106667
71: PURPOSE : To consolidate the data in the table JAI_CMN_RG_OTHERS as a part of the Master-Org Consolidation
72: of JAI_CMN_RG_23AC_II_TRXS table
73: CALLED FROM : Called from the Concurrent - Master Org RG Entries Request Set
74:
75: **********************************************************************/

Line 96: insert into JAI_CMN_RG_OTHERS

92: OPEN rg_others_cur(p_register_id, p_tax_type);
93: FETCH rg_others_cur INTO rg_others_rec;
94:
95: IF rg_others_cur%FOUND THEN
96: insert into JAI_CMN_RG_OTHERS
97: (
98: rg_other_id,
99: source_type,
100: source_register,

Line 148: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,

144: PROCEDURE insert_pla_others
145: (ERRBUF OUT NOCOPY VARCHAR2,
146: RETCODE OUT NOCOPY VARCHAR2,
147: p_previous_serial_no IN JAI_CMN_RG_PLA_TRXS.slno%TYPE,
148: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,
149: p_register_id IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE)
150: AS
151:
152: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS

Line 152: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS

148: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,
149: p_register_id IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE)
150: AS
151:
152: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
153: Select * from JAI_CMN_RG_OTHERS
154: where source_register_id = p_register_id
155: and source_type = 2
156: and tax_type = p_tax_type;

Line 153: Select * from JAI_CMN_RG_OTHERS

149: p_register_id IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE)
150: AS
151:
152: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
153: Select * from JAI_CMN_RG_OTHERS
154: where source_register_id = p_register_id
155: and source_type = 2
156: and tax_type = p_tax_type;
157:

Line 169: PURPOSE : To consolidate the data in the table JAI_CMN_RG_OTHERS as a part of the Master-Org Consolidation

165: Harshita J: /**********************************************************************
166: CREATED BY : hjujjuru
167: CREATED DATE : 11-JAN-2005
168: ENHANCEMENT BUG : 4106667
169: PURPOSE : To consolidate the data in the table JAI_CMN_RG_OTHERS as a part of the Master-Org Consolidation
170: of JAI_CMN_RG_23AC_II_TRXS table
171: CALLED FROM : Called from the Concurrent - Master Org RG Entries Request Set
172:
173: CHANGE HISTORY:

Line 192: insert into JAI_CMN_RG_OTHERS

188:
189:
190: IF rg_others_cur%FOUND THEN
191:
192: insert into JAI_CMN_RG_OTHERS
193: (
194: rg_other_id,
195: source_type,
196: source_register,

Line 803: from JAI_CMN_RG_OTHERS

799: -- added by hjujjuru for #Bug 4106667
800:
801: FOR tax_types_rec IN
802: (select tax_type
803: from JAI_CMN_RG_OTHERS
804: where source_register_id = rg23_rec.register_id
805: and source_type = 1
806: )
807: LOOP

Line 1168: from JAI_CMN_RG_OTHERS

1164:
1165:
1166: FOR tax_types_rec IN
1167: ( select tax_type
1168: from JAI_CMN_RG_OTHERS
1169: where
1170: source_register_id = pla_rec.register_id
1171: and source_type = 2
1172: )