APPS.INV_SERIAL_NUMBER_PUB dependencies on INV_COST_GROUP_PUB

Line 836: , inv_cost_group_pub.g_cost_group_id

832: , n_attribute9
833: , n_attribute10
834: , status_id
835: , territory_code
836: , inv_cost_group_pub.g_cost_group_id
837: , NVL(p_organization_type, 2)
838: , NVL(p_owning_org_id, p_organization_id)
839: , NVL(p_owning_tp_type, 2)
840: , NVL(p_planning_org_id, p_organization_id)

Line 1117: , inv_cost_group_pub.g_cost_group_id

1113: , TO_NUMBER(g_serial_attributes_tbl(41).column_value)
1114: , TO_NUMBER(g_serial_attributes_tbl(42).column_value)
1115: , l_status_id
1116: , g_serial_attributes_tbl(44).column_value
1117: , inv_cost_group_pub.g_cost_group_id
1118: , NVL(p_organization_type, 2)
1119: , NVL(p_owning_org_id, p_organization_id)
1120: , NVL(p_owning_tp_type, 2)
1121: , NVL(p_planning_org_id, p_organization_id)

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

1208: -- invtrace('nattribute9 ' ||TO_NUMBER(g_serial_attributes_tbl(41).column_value));
1209: -- invtrace('nattribute10 ' ||TO_NUMBER(g_serial_attributes_tbl(42).column_value));
1210: -- invtrace('status id is ' ||l_status_id);
1211: -- invtrace('territory code is ' || g_serial_attributes_tbl(44).column_value);
1212: -- invtrace('cost group id is ' ||inv_cost_group_pub.g_cost_group_id);
1213: -- invtrace('organization type is ' ||NVL(p_organization_type, 2));
1214: -- invtrace('owning org id ' ||NVL(p_owning_org_id, p_organization_id));
1215: -- invtrace('owning tp type ' ||NVL(p_owning_tp_type, 2));
1216: -- invtrace('planning org id is ' ||NVL(p_planning_org_id, p_organization_id));

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

1701: -- API body
1702:
1703: IF (l_debug = 1) THEN
1704: invtrace('CurStat =' || p_current_status || ',CG=' ||
1705: inv_cost_group_pub.g_cost_group_id || ',lastStat=' ||
1706: p_last_status || 'p_wip_entity_id = ' || p_wip_entity_id ||
1707: 'SerialNumber = ' || p_serial_number);
1708: END IF;
1709: l_userid := fnd_global.user_id;

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

1845: -- invtrace('n_attribute8 ' || l_n_attribute8);
1846: -- invtrace('n_attribute9 ' || l_n_attribute9);
1847: -- invtrace('n_attribute10 ' || l_n_attribute10);
1848: -- invtrace('territory_code ' || l_territory_code);
1849: -- invtrace('cost_group_id ' || inv_cost_group_pub.g_cost_group_id);
1850:
1851: UPDATE mtl_serial_numbers
1852: SET current_status = decode(p_current_status, null,
1853: decode(p_wip_entity_id, null, current_status, decode(current_status, 6, 1, current_status)),

Line 1927: , cost_group_id = inv_cost_group_pub.g_cost_group_id

1923: , n_attribute8 = l_n_attribute8
1924: , n_attribute9 = l_n_attribute9
1925: , n_attribute10 = l_n_attribute10
1926: , territory_code = l_territory_code
1927: , cost_group_id = inv_cost_group_pub.g_cost_group_id
1928: , wip_entity_id = p_wip_entity_id
1929: , operation_seq_num = p_operation_seq_num
1930: , intraoperation_step_type = p_intraoperation_step_type
1931: WHERE inventory_item_id = p_inventory_item_id

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

3835: l_to_status NUMBER := 0;
3836: l_canonical_trx_date DATE;
3837: l_sys_date DATE := SYSDATE;
3838: l_init_date DATE := trunc(sysdate);
3839: l_cg_id NUMBER := nvl(inv_cost_group_pub.g_cost_group_id, 0);
3840: l_upd_count NUMBER := 0;
3841: l_receipt_issue_flag VARCHAR2(1);
3842: l_error_code NUMBER;
3843: l_dynamic_ok NUMBER;