APPS.PMI_COST_ANALZ_PACK dependencies on IC_PERD_BAL

Line 111: whse_code_vi IN ic_perd_bal.whse_code%TYPE,

107:
108: FUNCTION gmca_get_perbal(
109: tr_date_vi IN DATE,
110: co_code_vi IN sy_orgn_mst.co_code%TYPE,
111: whse_code_vi IN ic_perd_bal.whse_code%TYPE,
112: item_id_vi IN ic_perd_bal.item_id%TYPE)
113: RETURN NUMBER
114: IS
115: period_balance_v NUMBER;

Line 112: item_id_vi IN ic_perd_bal.item_id%TYPE)

108: FUNCTION gmca_get_perbal(
109: tr_date_vi IN DATE,
110: co_code_vi IN sy_orgn_mst.co_code%TYPE,
111: whse_code_vi IN ic_perd_bal.whse_code%TYPE,
112: item_id_vi IN ic_perd_bal.item_id%TYPE)
113: RETURN NUMBER
114: IS
115: period_balance_v NUMBER;
116: CURSOR get_perbal_cur(

Line 119: whse_code_vi IN ic_perd_bal.whse_code%TYPE,

115: period_balance_v NUMBER;
116: CURSOR get_perbal_cur(
117: tr_date_vi IN DATE,
118: co_code_vi IN sy_orgn_mst.co_code%TYPE,
119: whse_code_vi IN ic_perd_bal.whse_code%TYPE,
120: item_id_vi IN ic_perd_bal.item_id%TYPE)
121: IS
122:
123: SELECT sum(loct_onhand)

Line 120: item_id_vi IN ic_perd_bal.item_id%TYPE)

116: CURSOR get_perbal_cur(
117: tr_date_vi IN DATE,
118: co_code_vi IN sy_orgn_mst.co_code%TYPE,
119: whse_code_vi IN ic_perd_bal.whse_code%TYPE,
120: item_id_vi IN ic_perd_bal.item_id%TYPE)
121: IS
122:
123: SELECT sum(loct_onhand)
124: FROM

Line 125: ic_perd_bal perbal,

121: IS
122:
123: SELECT sum(loct_onhand)
124: FROM
125: ic_perd_bal perbal,
126: pmi_inv_calendar_v precal
127: WHERE (tr_date_vi-1) between precal.start_date and precal.end_date
128: and co_code_vi = precal.orgn_code
129: and precal.fiscal_year = perbal.fiscal_year

Line 196: item_id_vi IN ic_perd_bal.item_id%TYPE)

192: /* Function to get type of the item i.e. PRODUCT, INGREDIENT,CO-PRODUCT,BY-PRODUCT */
193:
194:
195: FUNCTION gmca_get_line_type(
196: item_id_vi IN ic_perd_bal.item_id%TYPE)
197: RETURN NUMBER
198: IS
199: CURSOR line_type_cur IS
200: SELECT distinct line_type from fm_matl_dtl