APPS.POA_DBI_COM_C dependencies on PO_COMMODITIES_B

Line 37: po_commodities_b WHERE commodity_code=v_commodity_code;

33: v_commodity_code := trim(substr(v_commodity_code,1,40));
34: bis_collection_utilities.log('Truncated commodity code is "'|| v_commodity_code||'"',0);
35: -- Check if the commodity exists or not
36: SELECT COUNT(*) INTO v_check_flag FROM
37: po_commodities_b WHERE commodity_code=v_commodity_code;
38: IF (v_check_flag=0) THEN
39:
40: -- Get the values for the WHO columns
41: l_start_time := SYSDATE;

Line 47: --Insert into the table po_commodities_b

43: l_user := fnd_global.user_id;
44:
45: --Get the commodity id in the variable
46: SELECT po_commodities_s.NEXTVAL INTO v_nextval FROM dual;
47: --Insert into the table po_commodities_b
48: INSERT INTO po_commodities_b (
49: commodity_id,
50: commodity_code,
51: active_flag,

Line 48: INSERT INTO po_commodities_b (

44:
45: --Get the commodity id in the variable
46: SELECT po_commodities_s.NEXTVAL INTO v_nextval FROM dual;
47: --Insert into the table po_commodities_b
48: INSERT INTO po_commodities_b (
49: commodity_id,
50: commodity_code,
51: active_flag,
52: creation_date,

Line 145: v_commodity_id po_commodities_b.commodity_id%type;

141: l_user NUMBER;
142: -- Variable for storing the new commodity code.
143: v_commodity_code varchar2(3000);
144: -- Variable for storing the new commodity id
145: v_commodity_id po_commodities_b.commodity_id%type;
146:
147: BEGIN
148: -- Get the values in the WHO columns
149: l_start_time := sysdate;

Line 157: SELECT commodity_id INTO v_commodity_id from po_commodities_b

153: v_commodity_code := fnd_message.get_string('POA','POA_DBI_DEFAULT_COMMODITY');
154: --Extract 40 characters and Trim the spaces
155: v_commodity_code := trim(substr(v_commodity_code,1,40));
156: --Store the commodity id into the variable
157: SELECT commodity_id INTO v_commodity_id from po_commodities_b
158: WHERE commodity_code=v_commodity_code;
159:
160: -- Insert Record in the table
161: INSERT INTO po_commodity_categories (