APPS.GMD_COA_DATA_NEW dependencies on IC_WHSE_MST

Line 188: p_whse_code IN ic_whse_mst.whse_code%TYPE,

184: PROCEDURE Assign_Cursor_Values_To_Table
185: (p_orgn_code IN op_ordr_hdr.orgn_code%TYPE,
186: p_cust_id IN op_cust_mst.cust_id%TYPE,
187: p_item_id IN ic_item_mst.item_id%TYPE,
188: p_whse_code IN ic_whse_mst.whse_code%TYPE,
189: p_lot_id IN ic_lots_mst.lot_id%TYPE,
190: p_qc_spec_id IN gmd_specifications_b.spec_id%TYPE,
191: p_assay_code IN gmd_qc_tests_b.test_code%TYPE,
192: p_specification IN gmd_spec_tests.target_value_char%TYPE,

Line 1423: CURSOR get_whse_info (c_whse_code ic_whse_mst.WHSE_CODE%TYPE) IS

1419: WHERE cust_id = c_cust_id
1420: AND delete_mark= 0;
1421:
1422:
1423: CURSOR get_whse_info (c_whse_code ic_whse_mst.WHSE_CODE%TYPE) IS
1424: SELECT whse_name
1425: FROM
1426: ic_whse_mst
1427: WHERE

Line 1426: ic_whse_mst

1422:
1423: CURSOR get_whse_info (c_whse_code ic_whse_mst.WHSE_CODE%TYPE) IS
1424: SELECT whse_name
1425: FROM
1426: ic_whse_mst
1427: WHERE
1428: whse_code = c_whse_code
1429: and delete_mark = 0
1430: ;

Line 1805: /* get warehouse no and name from ic_whse_mst */

1801: /* end getting item info from ic_item_mst */
1802: END IF;
1803: /* end checking if item id has a value */
1804:
1805: /* get warehouse no and name from ic_whse_mst */
1806:
1807: IF tbl_hdr(loop_counter).whse_code is not NULL THEN
1808: FOR whse_cur_rec IN get_whse_info (tbl_hdr(loop_counter).whse_code) LOOP
1809: tbl_hdr(loop_counter).whse_name := whse_cur_rec.whse_name;

Line 1811: /* end getting warehouse info from ic_whse_mst */

1807: IF tbl_hdr(loop_counter).whse_code is not NULL THEN
1808: FOR whse_cur_rec IN get_whse_info (tbl_hdr(loop_counter).whse_code) LOOP
1809: tbl_hdr(loop_counter).whse_name := whse_cur_rec.whse_name;
1810: END LOOP;
1811: /* end getting warehouse info from ic_whse_mst */
1812: END IF;
1813: /* end checking if whse has a value */
1814:
1815: /* get lot no, sublot no and lot desc from ic_lots_mst */