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_PA_BILLING_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 117: FROM jai_cmn_inventory_orgs

113: modvat_rm_account_id cenvat_rm_accnt,
114: excise_edu_cess_rm_account cenvat_edu_cess_rm_accnt,
115: modvat_cg_account_id cenvat_cg_accnt,
116: excise_edu_cess_cg_account cenvat_edu_cess_cg_accnt
117: FROM jai_cmn_inventory_orgs
118: WHERE organization_id = cp_organization_id
119: AND location_id = cp_location_id;
120: */
121:

Line 545: cp_organization_id JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,

541: pv_process_message OUT NOCOPY VARCHAR2
542: ) is
543:
544: CURSOR c_same_inv_no(
545: cp_organization_id JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
546: cp_location_id JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
547: cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type
548: ) IS
549: SELECT attribute_value

Line 546: cp_location_id JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

542: ) is
543:
544: CURSOR c_same_inv_no(
545: cp_organization_id JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
546: cp_location_id JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
547: cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type
548: ) IS
549: SELECT attribute_value
550: FROM jai_rgm_org_regns_v

Line 760: cursor c_JAI_CMN_INVENTORY_ORGS (cpn_organization_id number, cpn_location_id number) is

756: , jai_constants.tax_type_sh_exc_edu_cess /*budget07*/
757: );
758:
759:
760: cursor c_JAI_CMN_INVENTORY_ORGS (cpn_organization_id number, cpn_location_id number) is
761: select
762: excise_rcvble_account excise_debit_accnt ,
763: cess_paid_payable_account_id excise_edu_cess_debit_accnt,
764: modvat_rm_account_id cenvat_rm_accnt,

Line 773: from JAI_CMN_INVENTORY_ORGS

769: /*budget07*/
770: sh_cess_paid_payable_acct_id exc_sh_cess_debit_accnt,
771: sh_cess_rm_account exc_sh_cess_rm_accnt,
772: sh_cess_cg_account_id exc_sh_cess_cg_accnt
773: from JAI_CMN_INVENTORY_ORGS
774: where organization_id = cpn_organization_id
775: and (
776: (cpn_location_id is not null and location_id = cpn_location_id)
777: or

Line 790: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;

786: and fin_active_flag = 'Y';
787: */
788:
789: r_jai_pa_draft_invoices c_draft_invoice_dtls%rowtype;
790: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;
791: r_jai_cmn_inventory_orgs1 c_jai_cmn_inventory_orgs%rowtype;
792:
793:
794: lv_exists_excise_tax varchar2(1);

Line 791: r_jai_cmn_inventory_orgs1 c_jai_cmn_inventory_orgs%rowtype;

787: */
788:
789: r_jai_pa_draft_invoices c_draft_invoice_dtls%rowtype;
790: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;
791: r_jai_cmn_inventory_orgs1 c_jai_cmn_inventory_orgs%rowtype;
792:
793:
794: lv_exists_excise_tax varchar2(1);
795: ln_basic_excise_amt number;

Line 964: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, r_jai_pa_draft_invoices.location_id);

960: end if;
961:
962: /* Derive the required accounts */
963: /* Accounts for the required location */
964: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, r_jai_pa_draft_invoices.location_id);
965: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs;
966: close c_jai_cmn_inventory_orgs;
967:
968: /* Accounts for the null location */

Line 965: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs;

961:
962: /* Derive the required accounts */
963: /* Accounts for the required location */
964: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, r_jai_pa_draft_invoices.location_id);
965: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs;
966: close c_jai_cmn_inventory_orgs;
967:
968: /* Accounts for the null location */
969: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, null);

Line 966: close c_jai_cmn_inventory_orgs;

962: /* Derive the required accounts */
963: /* Accounts for the required location */
964: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, r_jai_pa_draft_invoices.location_id);
965: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs;
966: close c_jai_cmn_inventory_orgs;
967:
968: /* Accounts for the null location */
969: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, null);
970: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;

Line 969: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, null);

965: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs;
966: close c_jai_cmn_inventory_orgs;
967:
968: /* Accounts for the null location */
969: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, null);
970: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;
971: close c_jai_cmn_inventory_orgs;
972:
973: ln_debit_account_id := nvl(r_jai_cmn_inventory_orgs.excise_debit_accnt,

Line 970: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;

966: close c_jai_cmn_inventory_orgs;
967:
968: /* Accounts for the null location */
969: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, null);
970: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;
971: close c_jai_cmn_inventory_orgs;
972:
973: ln_debit_account_id := nvl(r_jai_cmn_inventory_orgs.excise_debit_accnt,
974: r_jai_cmn_inventory_orgs1.excise_debit_accnt);

Line 971: close c_jai_cmn_inventory_orgs;

967:
968: /* Accounts for the null location */
969: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, null);
970: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;
971: close c_jai_cmn_inventory_orgs;
972:
973: ln_debit_account_id := nvl(r_jai_cmn_inventory_orgs.excise_debit_accnt,
974: r_jai_cmn_inventory_orgs1.excise_debit_accnt);
975:

Line 973: ln_debit_account_id := nvl(r_jai_cmn_inventory_orgs.excise_debit_accnt,

969: open c_jai_cmn_inventory_orgs(r_jai_pa_draft_invoices.organization_id, null);
970: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;
971: close c_jai_cmn_inventory_orgs;
972:
973: ln_debit_account_id := nvl(r_jai_cmn_inventory_orgs.excise_debit_accnt,
974: r_jai_cmn_inventory_orgs1.excise_debit_accnt);
975:
976:
977: /* Update RG Registers */

Line 974: r_jai_cmn_inventory_orgs1.excise_debit_accnt);

970: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;
971: close c_jai_cmn_inventory_orgs;
972:
973: ln_debit_account_id := nvl(r_jai_cmn_inventory_orgs.excise_debit_accnt,
974: r_jai_cmn_inventory_orgs1.excise_debit_accnt);
975:
976:
977: /* Update RG Registers */
978: if lv_register IN ('RG23A', 'RG23C') then

Line 1168: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_rm_accnt, r_jai_cmn_inventory_orgs1.cenvat_rm_accnt);

1164:
1165: if ln_register_id is not null then
1166:
1167: if lv_register = 'RG23A' then
1168: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_rm_accnt, r_jai_cmn_inventory_orgs1.cenvat_rm_accnt);
1169: elsif lv_register = 'RG23C' then
1170: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_cg_accnt, r_jai_cmn_inventory_orgs1.cenvat_cg_accnt);
1171: elsif lv_register = 'PLA' then
1172: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt, r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);

Line 1170: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_cg_accnt, r_jai_cmn_inventory_orgs1.cenvat_cg_accnt);

1166:
1167: if lv_register = 'RG23A' then
1168: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_rm_accnt, r_jai_cmn_inventory_orgs1.cenvat_rm_accnt);
1169: elsif lv_register = 'RG23C' then
1170: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_cg_accnt, r_jai_cmn_inventory_orgs1.cenvat_cg_accnt);
1171: elsif lv_register = 'PLA' then
1172: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt, r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);
1173: end if;
1174:

Line 1172: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt, r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);

1168: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_rm_accnt, r_jai_cmn_inventory_orgs1.cenvat_rm_accnt);
1169: elsif lv_register = 'RG23C' then
1170: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_cg_accnt, r_jai_cmn_inventory_orgs1.cenvat_cg_accnt);
1171: elsif lv_register = 'PLA' then
1172: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt, r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);
1173: end if;
1174:
1175: if ln_credit_ccid is null then
1176: pv_process_flag := jai_constants.expected_error;

Line 1183: ln_debit_ccid := nvl(r_jai_cmn_inventory_orgs.excise_debit_accnt, r_jai_cmn_inventory_orgs1.excise_debit_accnt);

1179: ||'/'||r_jai_pa_draft_invoices.location_id;
1180: goto exit_from_procedure;
1181: end if;
1182:
1183: ln_debit_ccid := nvl(r_jai_cmn_inventory_orgs.excise_debit_accnt, r_jai_cmn_inventory_orgs1.excise_debit_accnt);
1184: if ln_debit_ccid is null then
1185: pv_process_flag := jai_constants.expected_error;
1186: pv_process_message := 'Excise account not defined for '||lv_register
1187: ||' register of Org/Loc:'||r_jai_pa_draft_invoices.organization_id

Line 1242: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_rm_accnt,

1238: /* Entry 2 for ExciseEducation Cess */
1239: ln_debit_ccid := null;
1240: ln_credit_ccid := null;
1241: if lv_register = 'RG23A' then
1242: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_rm_accnt,
1243: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_rm_accnt);
1244: elsif lv_register = 'RG23C' then
1245: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_cg_accnt,
1246: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_cg_accnt);

Line 1243: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_rm_accnt);

1239: ln_debit_ccid := null;
1240: ln_credit_ccid := null;
1241: if lv_register = 'RG23A' then
1242: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_rm_accnt,
1243: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_rm_accnt);
1244: elsif lv_register = 'RG23C' then
1245: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_cg_accnt,
1246: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_cg_accnt);
1247: elsif lv_register = 'PLA' then

Line 1245: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_cg_accnt,

1241: if lv_register = 'RG23A' then
1242: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_rm_accnt,
1243: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_rm_accnt);
1244: elsif lv_register = 'RG23C' then
1245: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_cg_accnt,
1246: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_cg_accnt);
1247: elsif lv_register = 'PLA' then
1248: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt,
1249: r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);

Line 1246: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_cg_accnt);

1242: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_rm_accnt,
1243: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_rm_accnt);
1244: elsif lv_register = 'RG23C' then
1245: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_cg_accnt,
1246: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_cg_accnt);
1247: elsif lv_register = 'PLA' then
1248: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt,
1249: r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);
1250: end if;

Line 1248: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt,

1244: elsif lv_register = 'RG23C' then
1245: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_cg_accnt,
1246: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_cg_accnt);
1247: elsif lv_register = 'PLA' then
1248: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt,
1249: r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);
1250: end if;
1251:
1252: if ln_credit_ccid is null then

Line 1249: r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);

1245: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_edu_cess_cg_accnt,
1246: r_jai_cmn_inventory_orgs1.cenvat_edu_cess_cg_accnt);
1247: elsif lv_register = 'PLA' then
1248: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt,
1249: r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);
1250: end if;
1251:
1252: if ln_credit_ccid is null then
1253: pv_process_flag := jai_constants.expected_error;

Line 1260: ln_debit_ccid := nvl(r_jai_cmn_inventory_orgs.excise_edu_cess_debit_accnt,

1256: ||'/'||r_jai_pa_draft_invoices.location_id;
1257: goto exit_from_procedure;
1258: end if;
1259:
1260: ln_debit_ccid := nvl(r_jai_cmn_inventory_orgs.excise_edu_cess_debit_accnt,
1261: r_jai_cmn_inventory_orgs1.excise_edu_cess_debit_accnt);
1262: if ln_debit_ccid is null then
1263: pv_process_flag := jai_constants.expected_error;
1264: pv_process_message := 'Excise education cess account not defined for '||lv_register

Line 1261: r_jai_cmn_inventory_orgs1.excise_edu_cess_debit_accnt);

1257: goto exit_from_procedure;
1258: end if;
1259:
1260: ln_debit_ccid := nvl(r_jai_cmn_inventory_orgs.excise_edu_cess_debit_accnt,
1261: r_jai_cmn_inventory_orgs1.excise_edu_cess_debit_accnt);
1262: if ln_debit_ccid is null then
1263: pv_process_flag := jai_constants.expected_error;
1264: pv_process_message := 'Excise education cess account not defined for '||lv_register
1265: ||' register of Org/Loc:'||r_jai_pa_draft_invoices.organization_id

Line 1297: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_rm_accnt,

1293: /* Entry 3 for Secondary Higher Excise Education Cess */
1294: ln_debit_ccid := null;
1295: ln_credit_ccid := null;
1296: if lv_register = 'RG23A' then
1297: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_rm_accnt,
1298: r_jai_cmn_inventory_orgs1.exc_sh_cess_rm_accnt);
1299: elsif lv_register = 'RG23C' then
1300: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_cg_accnt,
1301: r_jai_cmn_inventory_orgs1.exc_sh_cess_cg_accnt);

Line 1298: r_jai_cmn_inventory_orgs1.exc_sh_cess_rm_accnt);

1294: ln_debit_ccid := null;
1295: ln_credit_ccid := null;
1296: if lv_register = 'RG23A' then
1297: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_rm_accnt,
1298: r_jai_cmn_inventory_orgs1.exc_sh_cess_rm_accnt);
1299: elsif lv_register = 'RG23C' then
1300: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_cg_accnt,
1301: r_jai_cmn_inventory_orgs1.exc_sh_cess_cg_accnt);
1302: elsif lv_register = 'PLA' then

Line 1300: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_cg_accnt,

1296: if lv_register = 'RG23A' then
1297: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_rm_accnt,
1298: r_jai_cmn_inventory_orgs1.exc_sh_cess_rm_accnt);
1299: elsif lv_register = 'RG23C' then
1300: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_cg_accnt,
1301: r_jai_cmn_inventory_orgs1.exc_sh_cess_cg_accnt);
1302: elsif lv_register = 'PLA' then
1303: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt,
1304: r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);

Line 1301: r_jai_cmn_inventory_orgs1.exc_sh_cess_cg_accnt);

1297: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_rm_accnt,
1298: r_jai_cmn_inventory_orgs1.exc_sh_cess_rm_accnt);
1299: elsif lv_register = 'RG23C' then
1300: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_cg_accnt,
1301: r_jai_cmn_inventory_orgs1.exc_sh_cess_cg_accnt);
1302: elsif lv_register = 'PLA' then
1303: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt,
1304: r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);
1305: end if;

Line 1303: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt,

1299: elsif lv_register = 'RG23C' then
1300: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_cg_accnt,
1301: r_jai_cmn_inventory_orgs1.exc_sh_cess_cg_accnt);
1302: elsif lv_register = 'PLA' then
1303: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt,
1304: r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);
1305: end if;
1306:
1307: if ln_credit_ccid is null then

Line 1304: r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);

1300: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_cg_accnt,
1301: r_jai_cmn_inventory_orgs1.exc_sh_cess_cg_accnt);
1302: elsif lv_register = 'PLA' then
1303: ln_credit_ccid := nvl(r_jai_cmn_inventory_orgs.cenvat_pla_accnt,
1304: r_jai_cmn_inventory_orgs1.cenvat_pla_accnt);
1305: end if;
1306:
1307: if ln_credit_ccid is null then
1308: pv_process_flag := jai_constants.expected_error;

Line 1315: ln_debit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_debit_accnt,

1311: ||'/'||r_jai_pa_draft_invoices.location_id;
1312: goto exit_from_procedure;
1313: end if;
1314:
1315: ln_debit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_debit_accnt,
1316: r_jai_cmn_inventory_orgs1.exc_sh_cess_debit_accnt);
1317: if ln_debit_ccid is null then
1318: pv_process_flag := jai_constants.expected_error;
1319: pv_process_message := 'SH education cess account not defined for '||lv_register

Line 1316: r_jai_cmn_inventory_orgs1.exc_sh_cess_debit_accnt);

1312: goto exit_from_procedure;
1313: end if;
1314:
1315: ln_debit_ccid := nvl(r_jai_cmn_inventory_orgs.exc_sh_cess_debit_accnt,
1316: r_jai_cmn_inventory_orgs1.exc_sh_cess_debit_accnt);
1317: if ln_debit_ccid is null then
1318: pv_process_flag := jai_constants.expected_error;
1319: pv_process_message := 'SH education cess account not defined for '||lv_register
1320: ||' register of Org/Loc:'||r_jai_pa_draft_invoices.organization_id

Line 1397: cursor c_jai_cmn_inventory_orgs (cpn_organization_id number, cpn_location_id number) is

1393: pv_process_message OUT NOCOPY varchar2
1394: )
1395: IS
1396:
1397: cursor c_jai_cmn_inventory_orgs (cpn_organization_id number, cpn_location_id number) is
1398: select pref_rg23a
1399: ,pref_rg23c
1400: ,pref_pla
1401: ,nvl(export_oriented_unit ,'N') export_oriented_unit

Line 1403: from jai_cmn_inventory_orgs

1399: ,pref_rg23c
1400: ,pref_pla
1401: ,nvl(export_oriented_unit ,'N') export_oriented_unit
1402: ,ssi_unit_flag
1403: from jai_cmn_inventory_orgs
1404: where organization_id = cpn_organization_id
1405: and (
1406: (cpn_location_id is not null and location_id = cpn_location_id)
1407: or

Line 1422: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;

1418: from jai_cmn_rg_balances
1419: where organization_id = cpn_organization_id
1420: and location_id = cpn_location_id;
1421:
1422: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;
1423: r_jai_cmn_inventory_orgs1 c_jai_cmn_inventory_orgs%rowtype;
1424: r_jai_cmn_rg_balances c_jai_cmn_rg_balances%rowtype;
1425:
1426: ln_pref_rg23a jai_cmn_inventory_orgs.pref_rg23a%type;

Line 1423: r_jai_cmn_inventory_orgs1 c_jai_cmn_inventory_orgs%rowtype;

1419: where organization_id = cpn_organization_id
1420: and location_id = cpn_location_id;
1421:
1422: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;
1423: r_jai_cmn_inventory_orgs1 c_jai_cmn_inventory_orgs%rowtype;
1424: r_jai_cmn_rg_balances c_jai_cmn_rg_balances%rowtype;
1425:
1426: ln_pref_rg23a jai_cmn_inventory_orgs.pref_rg23a%type;
1427: ln_pref_rg23c jai_cmn_inventory_orgs.pref_rg23c%type;

Line 1426: ln_pref_rg23a jai_cmn_inventory_orgs.pref_rg23a%type;

1422: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;
1423: r_jai_cmn_inventory_orgs1 c_jai_cmn_inventory_orgs%rowtype;
1424: r_jai_cmn_rg_balances c_jai_cmn_rg_balances%rowtype;
1425:
1426: ln_pref_rg23a jai_cmn_inventory_orgs.pref_rg23a%type;
1427: ln_pref_rg23c jai_cmn_inventory_orgs.pref_rg23c%type;
1428: ln_pref_pla jai_cmn_inventory_orgs.pref_pla%type;
1429: lv_export_oriented_unit jai_cmn_inventory_orgs.export_oriented_unit%type;
1430: lv_ssi_unit_flag jai_cmn_inventory_orgs.ssi_unit_flag%type;

Line 1427: ln_pref_rg23c jai_cmn_inventory_orgs.pref_rg23c%type;

1423: r_jai_cmn_inventory_orgs1 c_jai_cmn_inventory_orgs%rowtype;
1424: r_jai_cmn_rg_balances c_jai_cmn_rg_balances%rowtype;
1425:
1426: ln_pref_rg23a jai_cmn_inventory_orgs.pref_rg23a%type;
1427: ln_pref_rg23c jai_cmn_inventory_orgs.pref_rg23c%type;
1428: ln_pref_pla jai_cmn_inventory_orgs.pref_pla%type;
1429: lv_export_oriented_unit jai_cmn_inventory_orgs.export_oriented_unit%type;
1430: lv_ssi_unit_flag jai_cmn_inventory_orgs.ssi_unit_flag%type;
1431: ln_delivery_id number;

Line 1428: ln_pref_pla jai_cmn_inventory_orgs.pref_pla%type;

1424: r_jai_cmn_rg_balances c_jai_cmn_rg_balances%rowtype;
1425:
1426: ln_pref_rg23a jai_cmn_inventory_orgs.pref_rg23a%type;
1427: ln_pref_rg23c jai_cmn_inventory_orgs.pref_rg23c%type;
1428: ln_pref_pla jai_cmn_inventory_orgs.pref_pla%type;
1429: lv_export_oriented_unit jai_cmn_inventory_orgs.export_oriented_unit%type;
1430: lv_ssi_unit_flag jai_cmn_inventory_orgs.ssi_unit_flag%type;
1431: ln_delivery_id number;
1432: ln_tot_excise_amt number;

Line 1429: lv_export_oriented_unit jai_cmn_inventory_orgs.export_oriented_unit%type;

1425:
1426: ln_pref_rg23a jai_cmn_inventory_orgs.pref_rg23a%type;
1427: ln_pref_rg23c jai_cmn_inventory_orgs.pref_rg23c%type;
1428: ln_pref_pla jai_cmn_inventory_orgs.pref_pla%type;
1429: lv_export_oriented_unit jai_cmn_inventory_orgs.export_oriented_unit%type;
1430: lv_ssi_unit_flag jai_cmn_inventory_orgs.ssi_unit_flag%type;
1431: ln_delivery_id number;
1432: ln_tot_excise_amt number;
1433:

Line 1430: lv_ssi_unit_flag jai_cmn_inventory_orgs.ssi_unit_flag%type;

1426: ln_pref_rg23a jai_cmn_inventory_orgs.pref_rg23a%type;
1427: ln_pref_rg23c jai_cmn_inventory_orgs.pref_rg23c%type;
1428: ln_pref_pla jai_cmn_inventory_orgs.pref_pla%type;
1429: lv_export_oriented_unit jai_cmn_inventory_orgs.export_oriented_unit%type;
1430: lv_ssi_unit_flag jai_cmn_inventory_orgs.ssi_unit_flag%type;
1431: ln_delivery_id number;
1432: ln_tot_excise_amt number;
1433:
1434: BEGIN

Line 1437: open c_jai_cmn_inventory_orgs(pn_organization_id, pn_location_id);

1433:
1434: BEGIN
1435:
1436: /* Getthe details from the organization, location */
1437: open c_jai_cmn_inventory_orgs(pn_organization_id, pn_location_id);
1438: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs;
1439: close c_jai_cmn_inventory_orgs;
1440:
1441: /* Getthe details from the organization, null location */

Line 1438: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs;

1434: BEGIN
1435:
1436: /* Getthe details from the organization, location */
1437: open c_jai_cmn_inventory_orgs(pn_organization_id, pn_location_id);
1438: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs;
1439: close c_jai_cmn_inventory_orgs;
1440:
1441: /* Getthe details from the organization, null location */
1442: open c_jai_cmn_inventory_orgs(pn_organization_id, null);

Line 1439: close c_jai_cmn_inventory_orgs;

1435:
1436: /* Getthe details from the organization, location */
1437: open c_jai_cmn_inventory_orgs(pn_organization_id, pn_location_id);
1438: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs;
1439: close c_jai_cmn_inventory_orgs;
1440:
1441: /* Getthe details from the organization, null location */
1442: open c_jai_cmn_inventory_orgs(pn_organization_id, null);
1443: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;

Line 1442: open c_jai_cmn_inventory_orgs(pn_organization_id, null);

1438: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs;
1439: close c_jai_cmn_inventory_orgs;
1440:
1441: /* Getthe details from the organization, null location */
1442: open c_jai_cmn_inventory_orgs(pn_organization_id, null);
1443: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;
1444: close c_jai_cmn_inventory_orgs;
1445:
1446: ln_pref_rg23a :=

Line 1443: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;

1439: close c_jai_cmn_inventory_orgs;
1440:
1441: /* Getthe details from the organization, null location */
1442: open c_jai_cmn_inventory_orgs(pn_organization_id, null);
1443: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;
1444: close c_jai_cmn_inventory_orgs;
1445:
1446: ln_pref_rg23a :=
1447: nvl(r_jai_cmn_inventory_orgs.pref_rg23a, r_jai_cmn_inventory_orgs1.pref_rg23a);

Line 1444: close c_jai_cmn_inventory_orgs;

1440:
1441: /* Getthe details from the organization, null location */
1442: open c_jai_cmn_inventory_orgs(pn_organization_id, null);
1443: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;
1444: close c_jai_cmn_inventory_orgs;
1445:
1446: ln_pref_rg23a :=
1447: nvl(r_jai_cmn_inventory_orgs.pref_rg23a, r_jai_cmn_inventory_orgs1.pref_rg23a);
1448:

Line 1447: nvl(r_jai_cmn_inventory_orgs.pref_rg23a, r_jai_cmn_inventory_orgs1.pref_rg23a);

1443: fetch c_jai_cmn_inventory_orgs into r_jai_cmn_inventory_orgs1;
1444: close c_jai_cmn_inventory_orgs;
1445:
1446: ln_pref_rg23a :=
1447: nvl(r_jai_cmn_inventory_orgs.pref_rg23a, r_jai_cmn_inventory_orgs1.pref_rg23a);
1448:
1449: ln_pref_rg23c :=
1450: nvl(r_jai_cmn_inventory_orgs.pref_rg23c, r_jai_cmn_inventory_orgs1.pref_rg23c);
1451:

Line 1450: nvl(r_jai_cmn_inventory_orgs.pref_rg23c, r_jai_cmn_inventory_orgs1.pref_rg23c);

1446: ln_pref_rg23a :=
1447: nvl(r_jai_cmn_inventory_orgs.pref_rg23a, r_jai_cmn_inventory_orgs1.pref_rg23a);
1448:
1449: ln_pref_rg23c :=
1450: nvl(r_jai_cmn_inventory_orgs.pref_rg23c, r_jai_cmn_inventory_orgs1.pref_rg23c);
1451:
1452: ln_pref_pla :=
1453: nvl(r_jai_cmn_inventory_orgs.pref_pla, r_jai_cmn_inventory_orgs1.pref_pla);
1454:

Line 1453: nvl(r_jai_cmn_inventory_orgs.pref_pla, r_jai_cmn_inventory_orgs1.pref_pla);

1449: ln_pref_rg23c :=
1450: nvl(r_jai_cmn_inventory_orgs.pref_rg23c, r_jai_cmn_inventory_orgs1.pref_rg23c);
1451:
1452: ln_pref_pla :=
1453: nvl(r_jai_cmn_inventory_orgs.pref_pla, r_jai_cmn_inventory_orgs1.pref_pla);
1454:
1455: lv_export_oriented_unit :=
1456: nvl(r_jai_cmn_inventory_orgs.export_oriented_unit,
1457: r_jai_cmn_inventory_orgs1.export_oriented_unit);

Line 1456: nvl(r_jai_cmn_inventory_orgs.export_oriented_unit,

1452: ln_pref_pla :=
1453: nvl(r_jai_cmn_inventory_orgs.pref_pla, r_jai_cmn_inventory_orgs1.pref_pla);
1454:
1455: lv_export_oriented_unit :=
1456: nvl(r_jai_cmn_inventory_orgs.export_oriented_unit,
1457: r_jai_cmn_inventory_orgs1.export_oriented_unit);
1458:
1459: lv_ssi_unit_flag :=
1460: nvl(r_jai_cmn_inventory_orgs.ssi_unit_flag, r_jai_cmn_inventory_orgs1.ssi_unit_flag);

Line 1457: r_jai_cmn_inventory_orgs1.export_oriented_unit);

1453: nvl(r_jai_cmn_inventory_orgs.pref_pla, r_jai_cmn_inventory_orgs1.pref_pla);
1454:
1455: lv_export_oriented_unit :=
1456: nvl(r_jai_cmn_inventory_orgs.export_oriented_unit,
1457: r_jai_cmn_inventory_orgs1.export_oriented_unit);
1458:
1459: lv_ssi_unit_flag :=
1460: nvl(r_jai_cmn_inventory_orgs.ssi_unit_flag, r_jai_cmn_inventory_orgs1.ssi_unit_flag);
1461:

Line 1460: nvl(r_jai_cmn_inventory_orgs.ssi_unit_flag, r_jai_cmn_inventory_orgs1.ssi_unit_flag);

1456: nvl(r_jai_cmn_inventory_orgs.export_oriented_unit,
1457: r_jai_cmn_inventory_orgs1.export_oriented_unit);
1458:
1459: lv_ssi_unit_flag :=
1460: nvl(r_jai_cmn_inventory_orgs.ssi_unit_flag, r_jai_cmn_inventory_orgs1.ssi_unit_flag);
1461:
1462:
1463:
1464: /* Validations */