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 42: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,

38: PROCEDURE insert_rg23_others
39: (ERRBUF OUT NOCOPY VARCHAR2,
40: RETCODE OUT NOCOPY VARCHAR2,
41: p_previous_serial_no IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE,
42: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,
43: p_register_id IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE)
44: AS
45: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
46: Select *

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

41: p_previous_serial_no IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE,
42: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,
43: p_register_id IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE)
44: AS
45: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
46: Select *
47: from JAI_CMN_RG_OTHERS
48: where source_register_id = p_register_id
49: and source_type = 1

Line 47: from JAI_CMN_RG_OTHERS

43: p_register_id IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE)
44: AS
45: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
46: Select *
47: from JAI_CMN_RG_OTHERS
48: where source_register_id = p_register_id
49: and source_type = 1
50: and tax_type = p_tax_type;
51:

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

59: Harshita J: /**********************************************************************
60: CREATED BY : hjujjuru
61: CREATED DATE : 11-JAN-2005
62: ENHANCEMENT BUG : 4106667
63: PURPOSE : To consolidate the data in the table JAI_CMN_RG_OTHERS as a part of the Master-Org Consolidation
64: of JAI_CMN_RG_23AC_II_TRXS table
65: CALLED FROM : Called from the Concurrent - Master Org RG Entries Request Set
66:
67: **********************************************************************/

Line 88: insert into JAI_CMN_RG_OTHERS

84: OPEN rg_others_cur(p_register_id, p_tax_type);
85: FETCH rg_others_cur INTO rg_others_rec;
86:
87: IF rg_others_cur%FOUND THEN
88: insert into JAI_CMN_RG_OTHERS
89: (
90: rg_other_id,
91: source_type,
92: source_register,

Line 140: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,

136: PROCEDURE insert_pla_others
137: (ERRBUF OUT NOCOPY VARCHAR2,
138: RETCODE OUT NOCOPY VARCHAR2,
139: p_previous_serial_no IN JAI_CMN_RG_PLA_TRXS.slno%TYPE,
140: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,
141: p_register_id IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE)
142: AS
143:
144: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS

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

140: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,
141: p_register_id IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE)
142: AS
143:
144: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
145: Select * from JAI_CMN_RG_OTHERS
146: where source_register_id = p_register_id
147: and source_type = 2
148: and tax_type = p_tax_type;

Line 145: Select * from JAI_CMN_RG_OTHERS

141: p_register_id IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE)
142: AS
143:
144: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
145: Select * from JAI_CMN_RG_OTHERS
146: where source_register_id = p_register_id
147: and source_type = 2
148: and tax_type = p_tax_type;
149:

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

157: Harshita J: /**********************************************************************
158: CREATED BY : hjujjuru
159: CREATED DATE : 11-JAN-2005
160: ENHANCEMENT BUG : 4106667
161: PURPOSE : To consolidate the data in the table JAI_CMN_RG_OTHERS as a part of the Master-Org Consolidation
162: of JAI_CMN_RG_23AC_II_TRXS table
163: CALLED FROM : Called from the Concurrent - Master Org RG Entries Request Set
164:
165: CHANGE HISTORY:

Line 184: insert into JAI_CMN_RG_OTHERS

180:
181:
182: IF rg_others_cur%FOUND THEN
183:
184: insert into JAI_CMN_RG_OTHERS
185: (
186: rg_other_id,
187: source_type,
188: source_register,

Line 772: from JAI_CMN_RG_OTHERS

768: -- added by hjujjuru for #Bug 4106667
769:
770: FOR tax_types_rec IN
771: (select tax_type
772: from JAI_CMN_RG_OTHERS
773: where source_register_id = rg23_rec.register_id
774: and source_type = 1
775: )
776: LOOP

Line 1137: from JAI_CMN_RG_OTHERS

1133:
1134:
1135: FOR tax_types_rec IN
1136: ( select tax_type
1137: from JAI_CMN_RG_OTHERS
1138: where
1139: source_register_id = pla_rec.register_id
1140: and source_type = 2
1141: )