APPS.JA_JAINPROS_XMLP_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 94: JAI_CMN_VENDOR_SITES

90: CST_REG_NO,
91: ST_REG_NO,
92: VAT_REG_NO
93: FROM
94: JAI_CMN_VENDOR_SITES
95: WHERE VENDOR_ID = P_VENDOR_ID
96: AND VENDOR_SITE_ID = P_VENDOR_SITE_ID;
97: V_CST_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
98: BEGIN

Line 97: V_CST_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;

93: FROM
94: JAI_CMN_VENDOR_SITES
95: WHERE VENDOR_ID = P_VENDOR_ID
96: AND VENDOR_SITE_ID = P_VENDOR_SITE_ID;
97: V_CST_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
98: BEGIN
99: OPEN C_JA_VENDOR_DETAILS(VENDOR_ID,VENDOR_SITE_ID);
100: FETCH C_JA_VENDOR_DETAILS
101: INTO V_CST_REG_NO,CP_VEND_LST,CP_VEND_VAT;

Line 147: JAI_CMN_VENDOR_SITES

143: CST_REG_NO,
144: ST_REG_NO,
145: VAT_REG_NO
146: FROM
147: JAI_CMN_VENDOR_SITES
148: WHERE VENDOR_ID = P_VENDOR_ID
149: AND VENDOR_SITE_ID = P_VENDOR_SITE_ID;
150: V_CST_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
151: V_ST_REG_NO JAI_CMN_VENDOR_SITES.ST_REG_NO%TYPE;

Line 150: V_CST_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;

146: FROM
147: JAI_CMN_VENDOR_SITES
148: WHERE VENDOR_ID = P_VENDOR_ID
149: AND VENDOR_SITE_ID = P_VENDOR_SITE_ID;
150: V_CST_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
151: V_ST_REG_NO JAI_CMN_VENDOR_SITES.ST_REG_NO%TYPE;
152: V_VAT_REG_NO JAI_CMN_VENDOR_SITES.VAT_REG_NO%TYPE;
153: V_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
154: BEGIN

Line 151: V_ST_REG_NO JAI_CMN_VENDOR_SITES.ST_REG_NO%TYPE;

147: JAI_CMN_VENDOR_SITES
148: WHERE VENDOR_ID = P_VENDOR_ID
149: AND VENDOR_SITE_ID = P_VENDOR_SITE_ID;
150: V_CST_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
151: V_ST_REG_NO JAI_CMN_VENDOR_SITES.ST_REG_NO%TYPE;
152: V_VAT_REG_NO JAI_CMN_VENDOR_SITES.VAT_REG_NO%TYPE;
153: V_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
154: BEGIN
155: OPEN C_JA_VENDOR_DETAILS(VENDOR_ID,VENDOR_SITE_ID);

Line 152: V_VAT_REG_NO JAI_CMN_VENDOR_SITES.VAT_REG_NO%TYPE;

148: WHERE VENDOR_ID = P_VENDOR_ID
149: AND VENDOR_SITE_ID = P_VENDOR_SITE_ID;
150: V_CST_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
151: V_ST_REG_NO JAI_CMN_VENDOR_SITES.ST_REG_NO%TYPE;
152: V_VAT_REG_NO JAI_CMN_VENDOR_SITES.VAT_REG_NO%TYPE;
153: V_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
154: BEGIN
155: OPEN C_JA_VENDOR_DETAILS(VENDOR_ID,VENDOR_SITE_ID);
156: FETCH C_JA_VENDOR_DETAILS

Line 153: V_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;

149: AND VENDOR_SITE_ID = P_VENDOR_SITE_ID;
150: V_CST_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
151: V_ST_REG_NO JAI_CMN_VENDOR_SITES.ST_REG_NO%TYPE;
152: V_VAT_REG_NO JAI_CMN_VENDOR_SITES.VAT_REG_NO%TYPE;
153: V_REG_NO JAI_CMN_VENDOR_SITES.CST_REG_NO%TYPE;
154: BEGIN
155: OPEN C_JA_VENDOR_DETAILS(VENDOR_ID,VENDOR_SITE_ID);
156: FETCH C_JA_VENDOR_DETAILS
157: INTO V_CST_REG_NO,V_ST_REG_NO,V_VAT_REG_NO;