APPS.JA_JAINPLA_XMLP_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 322: JAI_CMN_INVENTORY_ORGS A

318: CURSOR C_EC_CODE_HR IS
319: SELECT
320: A.EC_CODE
321: FROM
322: JAI_CMN_INVENTORY_ORGS A
323: WHERE A.ORGANIZATION_ID = P_ORGANIZATION_ID
324: AND ROWNUM = 1
325: AND A.LOCATION_ID = P_LOCATION_ID;
326: X_EC_CODE JAI_CMN_INVENTORY_ORGS.EC_CODE%TYPE;

Line 326: X_EC_CODE JAI_CMN_INVENTORY_ORGS.EC_CODE%TYPE;

322: JAI_CMN_INVENTORY_ORGS A
323: WHERE A.ORGANIZATION_ID = P_ORGANIZATION_ID
324: AND ROWNUM = 1
325: AND A.LOCATION_ID = P_LOCATION_ID;
326: X_EC_CODE JAI_CMN_INVENTORY_ORGS.EC_CODE%TYPE;
327: BEGIN
328: IF VFLAG = 'C' THEN
329: OPEN C_EC_CODE_CUSTOMER;
330: FETCH C_EC_CODE_CUSTOMER

Line 523: V_ECC_CODE JAI_CMN_INVENTORY_ORGS.EC_CODE%TYPE;

519: END IF;
520: END CF_ACK_RECD_DATEFORMULA;
521:
522: FUNCTION CF_HDR_EC_CODEFORMULA RETURN CHAR IS
523: V_ECC_CODE JAI_CMN_INVENTORY_ORGS.EC_CODE%TYPE;
524: CURSOR C_EC_CODE IS
525: SELECT
526: EC_CODE
527: FROM

Line 528: JAI_CMN_INVENTORY_ORGS

524: CURSOR C_EC_CODE IS
525: SELECT
526: EC_CODE
527: FROM
528: JAI_CMN_INVENTORY_ORGS
529: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
530: AND LOCATION_ID = P_LOCATION_ID;
531: CURSOR C_EC_CODE_WO_LOCATION IS
532: SELECT

Line 535: JAI_CMN_INVENTORY_ORGS

531: CURSOR C_EC_CODE_WO_LOCATION IS
532: SELECT
533: EC_CODE
534: FROM
535: JAI_CMN_INVENTORY_ORGS
536: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
537: AND LOCATION_ID = 0;
538: BEGIN
539: OPEN C_EC_CODE;

Line 1126: LV_MAST_ORG_FLAG JAI_CMN_INVENTORY_ORGS.MASTER_ORG_FLAG%TYPE;

1122: AND TAX_TYPE = CP_TAX_TYPE
1123: AND SOURCE_REGISTER = 'PLA';
1124: LN_EXC_CESS_OPEN_BAL NUMBER := 0;
1125: LN_CVD_CESS_OPEN_BAL NUMBER := 0;
1126: LV_MAST_ORG_FLAG JAI_CMN_INVENTORY_ORGS.MASTER_ORG_FLAG%TYPE;
1127: LN_MIN_REG_ID NUMBER;
1128: LN_MAX_REG_ID NUMBER;
1129: LN_FIN_YEAR NUMBER;
1130: LN_REG_ID JAI_CMN_RG_PLA_TRXS.REGISTER_ID%TYPE;