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 36: Inserted Addl CVD into JAI_CMN_RG_23AC_II_TRXS and JAI_CMN_RG_23AC_I_TRXS

32: 2. insert_rg23_others
33:
34: Feb 18, 2010 Bug 9382720
35: Added Additional CVD as it is not getting consolidated in the Master Org
36: Inserted Addl CVD into JAI_CMN_RG_23AC_II_TRXS and JAI_CMN_RG_23AC_I_TRXS
37:
38: Apr 06, 2010 Bug 9550254
39: The opening balance for the RG23 Part I has been derived
40: from the previous financial year closing balance,

Line 49: p_previous_serial_no IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE,

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

Line 51: p_register_id IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE)

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

Line 72: of JAI_CMN_RG_23AC_II_TRXS table

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

Line 170: of JAI_CMN_RG_23AC_II_TRXS table

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

Line 542: From JAI_CMN_RG_23AC_II_TRXS a

538: v_ec_code Varchar2(50);
539:
540: Cursor rg23_part_ii_cur(p_register_id IN Number) IS
541: Select *
542: From JAI_CMN_RG_23AC_II_TRXS a
543: Where a.register_id = p_register_id;
544: rg23_rec rg23_part_ii_cur%ROWTYPE;
545:
546: Cursor rg23_part_ii_register_id_cur(p_ec_code IN Varchar2) IS

Line 548: From JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_INVENTORY_ORGS b

544: rg23_rec rg23_part_ii_cur%ROWTYPE;
545:
546: Cursor rg23_part_ii_register_id_cur(p_ec_code IN Varchar2) IS
547: Select register_id
548: From JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_INVENTORY_ORGS b
549: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
550: And ( a.master_flag IS NULL OR a.master_flag = 'N' ) --rchandan for bug#4428980
551: And a.organization_id = b.organization_id
552: And a.location_id = b.location_id

Line 561: From JAI_CMN_RG_23AC_II_TRXS

557:
558: Cursor serial_no_cur(p_organization_id IN Number, p_location_id IN Number,
559: p_fin_year IN Number, p_register_type Char) IS
560: Select nvl(MAX(slno),0) , nvl(MAX(slno),0) + 1
561: From JAI_CMN_RG_23AC_II_TRXS
562: Where organization_id = p_organization_id
563: And location_id = nvl(p_location_id,0)
564: And fin_year = p_fin_year
565: And register_type = p_register_type;

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

563: And location_id = nvl(p_location_id,0)
564: And fin_year = p_fin_year
565: And register_type = p_register_type;
566: --And nvl(master_flag,'N') = 'Y';--Commented by Nagaraj.s for Bug2636714
567: v_previous_serial_no JAI_CMN_RG_23AC_II_TRXS.slno%TYPE := 0;
568: v_serial_no JAI_CMN_RG_23AC_II_TRXS.slno%TYPE := 0;
569:
570: Cursor opening_balance_cur(p_previous_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
571: p_fin_year IN Number, p_register_type Char) IS

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

564: And fin_year = p_fin_year
565: And register_type = p_register_type;
566: --And nvl(master_flag,'N') = 'Y';--Commented by Nagaraj.s for Bug2636714
567: v_previous_serial_no JAI_CMN_RG_23AC_II_TRXS.slno%TYPE := 0;
568: v_serial_no JAI_CMN_RG_23AC_II_TRXS.slno%TYPE := 0;
569:
570: Cursor opening_balance_cur(p_previous_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
571: p_fin_year IN Number, p_register_type Char) IS
572: Select nvl(opening_balance,0), nvl(closing_balance,0)

Line 573: From JAI_CMN_RG_23AC_II_TRXS

569:
570: Cursor opening_balance_cur(p_previous_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
571: p_fin_year IN Number, p_register_type Char) IS
572: Select nvl(opening_balance,0), nvl(closing_balance,0)
573: From JAI_CMN_RG_23AC_II_TRXS
574: Where slno = p_previous_serial_no
575: And organization_id = p_organization_id
576: And location_id = nvl(p_location_id,0)
577: And register_type = p_register_type

Line 590: FROM JAI_CMN_RG_23AC_II_TRXS

586: and FIN_ACTIVE_FLAG='Y';
587:
588: 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
589: SELECT NVL(CLOSING_BALANCE,0)
590: FROM JAI_CMN_RG_23AC_II_TRXS
591: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
592: AND LOCATION_ID = P_LOCATION_ID
593: AND REGISTER_TYPE = P_REGISTER_TYPE
594: AND FIN_YEAR = P_FIN_YEAR

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

592: AND LOCATION_ID = P_LOCATION_ID
593: AND REGISTER_TYPE = P_REGISTER_TYPE
594: AND FIN_YEAR = P_FIN_YEAR
595: AND SLNO IN
596: (SELECT NVL(MAX(SLNO),0) FROM JAI_CMN_RG_23AC_II_TRXS
597: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
598: AND LOCATION_ID = P_LOCATION_ID
599: AND FIN_YEAR = P_FIN_YEAR
600: AND REGISTER_TYPE =P_REGISTER_TYPE);

Line 700: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,

696: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
697: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
698: end if;
699:
700: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,
701: fin_year,
702: slno,
703: TRANSACTION_SOURCE_NUM,
704: inventory_item_id,

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

786: rg23_rec.additional_cvd_amt,
787: rg23_rec.cr_additional_cvd,
788: rg23_rec.dr_additional_cvd );
789: if v_debug_flag = 'Y' THEN
790: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.9 After Insert into JAI_CMN_RG_23AC_II_TRXS table');
791: FND_FILE.PUT_LINE(FND_FILE.LOG, '2.0 After the Register id is Processed' );
792: end if;
793:
794: UPDATE JAI_CMN_RG_23AC_II_TRXS

Line 794: UPDATE JAI_CMN_RG_23AC_II_TRXS

790: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.9 After Insert into JAI_CMN_RG_23AC_II_TRXS table');
791: FND_FILE.PUT_LINE(FND_FILE.LOG, '2.0 After the Register id is Processed' );
792: end if;
793:
794: UPDATE JAI_CMN_RG_23AC_II_TRXS
795: SET posted_flag = 'Y',
796: master_flag = 'N'
797: WHERE register_id = rg23_rec.register_id;
798: