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_23AC_II_TRXS

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 41: p_previous_serial_no IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE,

37:
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

Line 43: p_register_id IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE)

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 *
47: from JAI_CMN_RG_OTHERS

Line 64: of JAI_CMN_RG_23AC_II_TRXS table

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: **********************************************************************/
68: /*

Line 162: of JAI_CMN_RG_23AC_II_TRXS table

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:
166:

Line 519: From JAI_CMN_RG_23AC_II_TRXS a

515: v_ec_code Varchar2(50);
516:
517: Cursor rg23_part_ii_cur(p_register_id IN Number) IS
518: Select *
519: From JAI_CMN_RG_23AC_II_TRXS a
520: Where a.register_id = p_register_id;
521: rg23_rec rg23_part_ii_cur%ROWTYPE;
522:
523: Cursor rg23_part_ii_register_id_cur(p_ec_code IN Varchar2) IS

Line 525: From JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_INVENTORY_ORGS b

521: rg23_rec rg23_part_ii_cur%ROWTYPE;
522:
523: Cursor rg23_part_ii_register_id_cur(p_ec_code IN Varchar2) IS
524: Select register_id
525: From JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_INVENTORY_ORGS b
526: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
527: And ( a.master_flag IS NULL OR a.master_flag = 'N' ) --rchandan for bug#4428980
528: And a.organization_id = b.organization_id
529: And a.location_id = b.location_id

Line 538: From JAI_CMN_RG_23AC_II_TRXS

534:
535: Cursor serial_no_cur(p_organization_id IN Number, p_location_id IN Number,
536: p_fin_year IN Number, p_register_type Char) IS
537: Select nvl(MAX(slno),0) , nvl(MAX(slno),0) + 1
538: From JAI_CMN_RG_23AC_II_TRXS
539: Where organization_id = p_organization_id
540: And location_id = nvl(p_location_id,0)
541: And fin_year = p_fin_year
542: And register_type = p_register_type;

Line 544: v_previous_serial_no JAI_CMN_RG_23AC_II_TRXS.slno%TYPE := 0;

540: And location_id = nvl(p_location_id,0)
541: And fin_year = p_fin_year
542: And register_type = p_register_type;
543: --And nvl(master_flag,'N') = 'Y';--Commented by Nagaraj.s for Bug2636714
544: v_previous_serial_no JAI_CMN_RG_23AC_II_TRXS.slno%TYPE := 0;
545: v_serial_no JAI_CMN_RG_23AC_II_TRXS.slno%TYPE := 0;
546:
547: Cursor opening_balance_cur(p_previous_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
548: p_fin_year IN Number, p_register_type Char) IS

Line 545: v_serial_no JAI_CMN_RG_23AC_II_TRXS.slno%TYPE := 0;

541: And fin_year = p_fin_year
542: And register_type = p_register_type;
543: --And nvl(master_flag,'N') = 'Y';--Commented by Nagaraj.s for Bug2636714
544: v_previous_serial_no JAI_CMN_RG_23AC_II_TRXS.slno%TYPE := 0;
545: v_serial_no JAI_CMN_RG_23AC_II_TRXS.slno%TYPE := 0;
546:
547: Cursor opening_balance_cur(p_previous_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
548: p_fin_year IN Number, p_register_type Char) IS
549: Select nvl(opening_balance,0), nvl(closing_balance,0)

Line 550: From JAI_CMN_RG_23AC_II_TRXS

546:
547: Cursor opening_balance_cur(p_previous_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
548: p_fin_year IN Number, p_register_type Char) IS
549: Select nvl(opening_balance,0), nvl(closing_balance,0)
550: From JAI_CMN_RG_23AC_II_TRXS
551: Where slno = p_previous_serial_no
552: And organization_id = p_organization_id
553: And location_id = nvl(p_location_id,0)
554: And register_type = p_register_type

Line 567: FROM JAI_CMN_RG_23AC_II_TRXS

563: and FIN_ACTIVE_FLAG='Y';
564:
565: Cursor c_final_balance_rg23(p_organization_id IN NUMBER,p_location_id IN NUMBER,p_fin_year IN NUMBER,P_REGISTER_TYPE CHAR) IS
566: SELECT NVL(CLOSING_BALANCE,0)
567: FROM JAI_CMN_RG_23AC_II_TRXS
568: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
569: AND LOCATION_ID = P_LOCATION_ID
570: AND REGISTER_TYPE = P_REGISTER_TYPE
571: AND FIN_YEAR = P_FIN_YEAR

Line 573: (SELECT NVL(MAX(SLNO),0) FROM JAI_CMN_RG_23AC_II_TRXS

569: AND LOCATION_ID = P_LOCATION_ID
570: AND REGISTER_TYPE = P_REGISTER_TYPE
571: AND FIN_YEAR = P_FIN_YEAR
572: AND SLNO IN
573: (SELECT NVL(MAX(SLNO),0) FROM JAI_CMN_RG_23AC_II_TRXS
574: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
575: AND LOCATION_ID = P_LOCATION_ID
576: AND FIN_YEAR = P_FIN_YEAR
577: AND REGISTER_TYPE =P_REGISTER_TYPE);

Line 677: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,

673: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
674: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
675: end if;
676:
677: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,
678: fin_year,
679: slno,
680: TRANSACTION_SOURCE_NUM,
681: inventory_item_id,

Line 759: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.9 After Insert into JAI_CMN_RG_23AC_II_TRXS table');

755: rg23_rec.last_update_login,
756: rg23_rec.other_tax_credit,
757: rg23_rec.other_tax_debit );
758: if v_debug_flag = 'Y' THEN
759: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.9 After Insert into JAI_CMN_RG_23AC_II_TRXS table');
760: FND_FILE.PUT_LINE(FND_FILE.LOG, '2.0 After the Register id is Processed' );
761: end if;
762:
763: UPDATE JAI_CMN_RG_23AC_II_TRXS

Line 763: UPDATE JAI_CMN_RG_23AC_II_TRXS

759: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.9 After Insert into JAI_CMN_RG_23AC_II_TRXS table');
760: FND_FILE.PUT_LINE(FND_FILE.LOG, '2.0 After the Register id is Processed' );
761: end if;
762:
763: UPDATE JAI_CMN_RG_23AC_II_TRXS
764: SET posted_flag = 'Y',
765: master_flag = 'N'
766: WHERE register_id = rg23_rec.register_id;
767: