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_TRANSFER_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 59: p_org_code org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043

55: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_transfer_pkg.balance_transfer';
56: lv_debit jai_cmn_rg_others.debit%TYPE ; --rchandan for bug#4428980
57: lv_credit jai_cmn_rg_others.credit%TYPE ; --rchandan for bug#4428980
58:
59: p_org_code org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043
60: p_org_code_to org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043
61:
62: CURSOR c_rg_balances(p_organization_id NUMBER, p_location_id NUMBER) IS
63: select nvl(rg23a_balance,0), nvl(rg23c_balance,0), nvl(pla_balance,0)

Line 60: p_org_code_to org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043

56: lv_debit jai_cmn_rg_others.debit%TYPE ; --rchandan for bug#4428980
57: lv_credit jai_cmn_rg_others.credit%TYPE ; --rchandan for bug#4428980
58:
59: p_org_code org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043
60: p_org_code_to org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043
61:
62: CURSOR c_rg_balances(p_organization_id NUMBER, p_location_id NUMBER) IS
63: select nvl(rg23a_balance,0), nvl(rg23c_balance,0), nvl(pla_balance,0)
64: from JAI_CMN_RG_BALANCES

Line 734: org_organization_definitions where organization_id = p_organization_id;

730:
731: --Fetching organization code information for Added for bug # 13824043
732:
733: select organization_code into p_org_code from
734: org_organization_definitions where organization_id = p_organization_id;
735:
736: select organization_code into p_org_code_to from
737: org_organization_definitions where organization_id = p_to_organization_id;
738:

Line 737: org_organization_definitions where organization_id = p_to_organization_id;

733: select organization_code into p_org_code from
734: org_organization_definitions where organization_id = p_organization_id;
735:
736: select organization_code into p_org_code_to from
737: org_organization_definitions where organization_id = p_to_organization_id;
738:
739: IF p_register NOT IN ('RG23A','RG23C','PLA') THEN
740: RAISE_APPLICATION_ERROR(-20120, 'Select a Register');
741: END IF;