DBA Data[Home] [Help]

APPS.GML_VALIDATE_PO dependencies on IC_WHSE_MST

Line 155: FUNCTION val_warehouse (v_whse_code IN ic_whse_mst.whse_code%TYPE,

151: | for the same set of books. |
152: | |
153: =========================================================================*/
154:
155: FUNCTION val_warehouse (v_whse_code IN ic_whse_mst.whse_code%TYPE,
156: v_orgn_code IN ic_whse_mst.orgn_code%TYPE)
157: RETURN BOOLEAN
158: IS
159: err_num NUMBER;

Line 156: v_orgn_code IN ic_whse_mst.orgn_code%TYPE)

152: | |
153: =========================================================================*/
154:
155: FUNCTION val_warehouse (v_whse_code IN ic_whse_mst.whse_code%TYPE,
156: v_orgn_code IN ic_whse_mst.orgn_code%TYPE)
157: RETURN BOOLEAN
158: IS
159: err_num NUMBER;
160: err_msg VARCHAR2(100);

Line 171: from ic_whse_mst

167: from gl_plcy_mst
168: where co_code = (select co_code
169: from sy_orgn_mst
170: where orgn_code = (select orgn_code
171: from ic_whse_mst
172: where whse_code=v_whse_code));
173:
174: CURSOR org_cur IS
175: SELECT distinct sob_id