47: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
48:
49: TYPE config_bcol_rec IS RECORD
50: (
51: config_item_id CTO_MSUTIL_PUB.NUMTAB,
52: base_item_id CTO_MSUTIL_PUB.NUMTAB,
53: ship_from_org_id CTO_MSUTIL_PUB.NUMTAB
54: ); --Bugfix 6398466
55:
48:
49: TYPE config_bcol_rec IS RECORD
50: (
51: config_item_id CTO_MSUTIL_PUB.NUMTAB,
52: base_item_id CTO_MSUTIL_PUB.NUMTAB,
53: ship_from_org_id CTO_MSUTIL_PUB.NUMTAB
54: ); --Bugfix 6398466
55:
56: PROCEDURE get_all_configs
49: TYPE config_bcol_rec IS RECORD
50: (
51: config_item_id CTO_MSUTIL_PUB.NUMTAB,
52: base_item_id CTO_MSUTIL_PUB.NUMTAB,
53: ship_from_org_id CTO_MSUTIL_PUB.NUMTAB
54: ); --Bugfix 6398466
55:
56: PROCEDURE get_all_configs
57: (
102: bmodel_exists number;
103:
104: v_sourcing_rule_exists VARCHAR2(10);
105: v_source_type NUMBER;
106: v_t_sourcing_info CTO_MSUTIL_PUB.SOURCING_INFO;
107:
108: x_exp_error_code NUMBER;
109: x_return_status VARCHAR2(30);
110:
374: oe_debug_pub.add('link_config: ' || 'Top level model l_model_id= ' || l_model_id, 1);
375: END IF;
376:
377: l_stmt_num := 200;
378: CTO_MSUTIL_PUB.query_sourcing_org_ms(
379: p_inventory_item_id => l_model_id
380: , p_organization_id => old_config_dtls.ship_from_org_id(1)
381: , p_sourcing_rule_exists => v_sourcing_rule_exists
382: , p_source_type => v_source_type