APPS.INV_SERIAL_NUMBER_PUB dependencies on INV_COST_GROUP_PUB

Line 870: , inv_cost_group_pub.g_cost_group_id

866: , n_attribute9
867: , n_attribute10
868: , status_id
869: , territory_code
870: , inv_cost_group_pub.g_cost_group_id
871: , NVL(p_organization_type, 2)
872: , NVL(p_owning_org_id, p_organization_id)
873: , NVL(p_owning_tp_type, 2)
874: , NVL(p_planning_org_id, p_organization_id)

Line 1151: , inv_cost_group_pub.g_cost_group_id

1147: , TO_NUMBER(g_serial_attributes_tbl(41).column_value)
1148: , TO_NUMBER(g_serial_attributes_tbl(42).column_value)
1149: , l_status_id
1150: , g_serial_attributes_tbl(44).column_value
1151: , inv_cost_group_pub.g_cost_group_id
1152: , NVL(p_organization_type, 2)
1153: , NVL(p_owning_org_id, p_organization_id)
1154: , NVL(p_owning_tp_type, 2)
1155: , NVL(p_planning_org_id, p_organization_id)

Line 1246: -- invtrace('cost group id is ' ||inv_cost_group_pub.g_cost_group_id);

1242: -- invtrace('nattribute9 ' ||TO_NUMBER(g_serial_attributes_tbl(41).column_value));
1243: -- invtrace('nattribute10 ' ||TO_NUMBER(g_serial_attributes_tbl(42).column_value));
1244: -- invtrace('status id is ' ||l_status_id);
1245: -- invtrace('territory code is ' || g_serial_attributes_tbl(44).column_value);
1246: -- invtrace('cost group id is ' ||inv_cost_group_pub.g_cost_group_id);
1247: -- invtrace('organization type is ' ||NVL(p_organization_type, 2));
1248: -- invtrace('owning org id ' ||NVL(p_owning_org_id, p_organization_id));
1249: -- invtrace('owning tp type ' ||NVL(p_owning_tp_type, 2));
1250: -- invtrace('planning org id is ' ||NVL(p_planning_org_id, p_organization_id));

Line 2036: inv_cost_group_pub.g_cost_group_id || ',lastStat=' ||

2032: -- API body
2033:
2034: IF (l_debug = 1) THEN
2035: invtrace('CurStat =' || p_current_status || ',CG=' ||
2036: inv_cost_group_pub.g_cost_group_id || ',lastStat=' ||
2037: p_last_status || 'p_wip_entity_id = ' || p_wip_entity_id ||
2038: 'SerialNumber = ' || p_serial_number);
2039: END IF;
2040: l_userid := fnd_global.user_id;

Line 2180: -- invtrace('cost_group_id ' || inv_cost_group_pub.g_cost_group_id);

2176: -- invtrace('n_attribute8 ' || l_n_attribute8);
2177: -- invtrace('n_attribute9 ' || l_n_attribute9);
2178: -- invtrace('n_attribute10 ' || l_n_attribute10);
2179: -- invtrace('territory_code ' || l_territory_code);
2180: -- invtrace('cost_group_id ' || inv_cost_group_pub.g_cost_group_id);
2181:
2182: UPDATE mtl_serial_numbers
2183: SET current_status = decode(p_current_status, null,
2184: decode(p_wip_entity_id, null, current_status, decode(current_status, 6, 1, current_status)),

Line 2258: , cost_group_id = inv_cost_group_pub.g_cost_group_id

2254: , n_attribute8 = l_n_attribute8
2255: , n_attribute9 = l_n_attribute9
2256: , n_attribute10 = l_n_attribute10
2257: , territory_code = l_territory_code
2258: , cost_group_id = inv_cost_group_pub.g_cost_group_id
2259: , wip_entity_id = p_wip_entity_id
2260: , operation_seq_num = p_operation_seq_num
2261: , intraoperation_step_type = p_intraoperation_step_type
2262: WHERE inventory_item_id = p_inventory_item_id

Line 4222: l_cg_id NUMBER := nvl(inv_cost_group_pub.g_cost_group_id, 0);

4218: l_to_status NUMBER := 0;
4219: l_canonical_trx_date DATE;
4220: l_sys_date DATE := SYSDATE;
4221: l_init_date DATE := trunc(sysdate);
4222: l_cg_id NUMBER := nvl(inv_cost_group_pub.g_cost_group_id, 0);
4223: l_upd_count NUMBER := 0;
4224: l_receipt_issue_flag VARCHAR2(1);
4225: l_error_code NUMBER;
4226: l_dynamic_ok NUMBER;