eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_WORKFLOW_API_PK dependencies on CTO_UTILITY_PK

Line 1455: if (CTO_UTILITY_PK.check_rsv_quantity (p_order_line_id => p_order_line_id,

1451: --begin bugfix 2001824 : check if qty being unreserved is ok
1452: If PG_DEBUG <> 0 Then
1453: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'p_rsv_quantity'||p_rsv_quantity);
1454: End if;
1455: if (CTO_UTILITY_PK.check_rsv_quantity (p_order_line_id => p_order_line_id,
1456: p_rsv_quantity => p_rsv_quantity) = FALSE )
1457: then
1458: IF PG_DEBUG <> 0 THEN
1459: oe_debug_pub.add ('inventory_unreservation_check: ' || 'Unreservation of qty '||p_rsv_quantity ||

Line 1674: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => p_order_line_id ); --bugfix 1799874

1670: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Open Flag ='||v_open_flag, 1);
1671: End if;
1672:
1673: if v_open_flag = 'Y' then --Bugfix 7214005
1674: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => p_order_line_id ); --bugfix 1799874
1675:
1676: IF ((upper(v_item_type_code) = 'STANDARD' OR upper(v_item_type_code) = 'OPTION' ) --fix for bug# 1874380
1677: AND (v_ato_line_id = p_order_line_id))
1678: OR upper(v_item_type_code) = 'CONFIG'

Line 1706: CTO_UTILITY_PK.check_cto_can_create_supply (

1702: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Ship Line Notified...',1);
1703: END IF;
1704:
1705: --to check if cto or planning has created the supply
1706: CTO_UTILITY_PK.check_cto_can_create_supply (
1707: P_config_item_id =>l_inventory_item_id,
1708: P_org_id =>l_ship_from_org_id,
1709: x_can_create_supply =>l_can_create_supply,
1710: p_source_type =>l_source_type,

Line 3009: l_source_document_type_id := cto_utility_pk.get_source_document_id ( pLineId => p_itemkey );

3005: WHERE a.header_id = b.header_id
3006: AND a.line_id = to_number(p_itemkey);
3007:
3008: -- get the line source document type ID
3009: l_source_document_type_id := cto_utility_pk.get_source_document_id ( pLineId => p_itemkey );
3010:
3011: IF so_line.program_id = p_program_id THEN
3012:
3013: -- log message that the line has been processed by the concurrent_program

Line 3054: CTO_UTILITY_PK.query_sourcing_org(

3050: -- rkaza. 05/02/2005. ireq project
3051: -- call query sourcing org to get src type and distinguish internal
3052: -- external req cases.
3053: l_stmt_num := 22;
3054: CTO_UTILITY_PK.query_sourcing_org(
3055: p_inventory_item_id => so_line.inventory_item_id,
3056: p_organization_id => so_line.ship_from_org_id,
3057: p_sourcing_rule_exists => l_sourcing_rule_exists,
3058: p_sourcing_org => l_req_input_data.sourcing_org,

Line 3247: CTO_UTILITY_PK.query_sourcing_org(

3243:
3244: IF l_item_type_code in ('STANDARD','OPTION') AND
3245: l_ato_line_id = oe_line_security.g_record.line_id THEN
3246:
3247: CTO_UTILITY_PK.query_sourcing_org(
3248: p_inventory_item_id => l_inv_item_id,
3249: p_organization_id => l_ship_org,
3250: p_sourcing_rule_exists => v_sourcing_rule_exists,
3251: p_source_type => v_source_type,

Line 3317: v_rsv_rec CTO_UTILITY_PK.resv_tbl_rec_type;

3313: l_config_line_id number ;
3314:
3315:
3316:
3317: v_rsv_rec CTO_UTILITY_PK.resv_tbl_rec_type;
3318: v_resv_code varchar2(200) ;
3319: v_sum_rxv_qty number ;
3320: v_return_status varchar2(200) ;
3321: v_msg_count number ;

Line 3423: CTO_UTILITY_PK.Get_Resv_Qty

3419:
3420:
3421: l_stmt_num := 30;
3422:
3423: CTO_UTILITY_PK.Get_Resv_Qty
3424: (
3425: p_order_line_id => l_config_line_id ,
3426: x_rsv_rec => v_rsv_rec,
3427: x_primary_uom_code => x_primary_uom_code,

Line 3500: l_rsv_rec CTO_UTILITY_PK.resv_tbl_rec_type;

3496: x_msg_data OUT NOCOPY Varchar2,
3497: x_msg_count OUT NOCOPY Number) is
3498:
3499: l_stmt_num Number;
3500: l_rsv_rec CTO_UTILITY_PK.resv_tbl_rec_type;
3501: x_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%type;
3502: l_sum_rsv_qty NUMBER;
3503: l_can_create_supply varchar2(1);
3504: --l_source_type VARCHAR2(5); -- bug 4552271. rkaza. 08/15/05.

Line 3537: CTO_UTILITY_PK.Get_Resv_Qty

3533: Begin
3534:
3535: --call API to get_reservation_code
3536: l_stmt_num := 10;
3537: CTO_UTILITY_PK.Get_Resv_Qty
3538: (
3539: p_order_line_id => p_order_line_id,
3540: x_rsv_rec => l_rsv_rec,
3541: x_primary_uom_code => x_primary_uom_code,

Line 3576: CTO_UTILITY_PK.check_cto_can_create_supply

3572: l_stmt_num :=20;
3573: If l_rsv_rec.count = 0 then
3574:
3575: l_stmt_num :=30;
3576: CTO_UTILITY_PK.check_cto_can_create_supply
3577: (
3578: P_config_item_id => p_config_item_id,
3579: P_org_id => p_ship_from_org_id,
3580: x_can_create_supply => l_can_create_supply,

Line 3612: l_flm_src_id := cto_utility_pk.g_source_type_flow;

3608: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3609: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3610: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3611: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3612: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3613: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3614: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;
3615: --end cross_dock
3616:

Line 3613: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;

3609: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3610: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3611: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3612: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3613: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3614: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;
3615: --end cross_dock
3616:
3617: IF PG_DEBUG <> 0 THEN

Line 3614: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;

3610: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3611: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3612: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3613: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3614: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;
3615: --end cross_dock
3616:
3617: IF PG_DEBUG <> 0 THEN
3618: oe_debug_pub.add('get_status_tokens: '||'In IF BLOCK when l_rsv_rec count is > 0 ',5);