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 1476: if (CTO_UTILITY_PK.check_rsv_quantity (p_order_line_id => p_order_line_id,

1472: --begin bugfix 2001824 : check if qty being unreserved is ok
1473: If PG_DEBUG <> 0 Then
1474: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'p_rsv_quantity'||p_rsv_quantity);
1475: End if;
1476: if (CTO_UTILITY_PK.check_rsv_quantity (p_order_line_id => p_order_line_id,
1477: p_rsv_quantity => p_rsv_quantity) = FALSE )
1478: then
1479: IF PG_DEBUG <> 0 THEN
1480: oe_debug_pub.add ('inventory_unreservation_check: ' || 'Unreservation of qty '||p_rsv_quantity ||

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

1691: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Open Flag ='||v_open_flag, 1);
1692: End if;
1693:
1694: if v_open_flag = 'Y' then --Bugfix 7214005
1695: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => p_order_line_id ); --bugfix 1799874
1696:
1697: --Adding INCLUDED item type code for SUN ER#9793792
1698: --IF ((upper(v_item_type_code) = 'STANDARD' OR upper(v_item_type_code) = 'OPTION' ) --fix for bug# 1874380
1699: IF (( upper(v_item_type_code) = 'STANDARD'

Line 1733: CTO_UTILITY_PK.check_cto_can_create_supply (

1729: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Ship Line Notified...',1);
1730: END IF;
1731:
1732: --to check if cto or planning has created the supply
1733: CTO_UTILITY_PK.check_cto_can_create_supply (
1734: P_config_item_id =>l_inventory_item_id,
1735: P_org_id =>l_ship_from_org_id,
1736: x_can_create_supply =>l_can_create_supply,
1737: p_source_type =>l_source_type,

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

3035: WHERE a.header_id = b.header_id
3036: AND a.line_id = to_number(p_itemkey);
3037:
3038: -- get the line source document type ID
3039: l_source_document_type_id := cto_utility_pk.get_source_document_id ( pLineId => p_itemkey );
3040:
3041: IF so_line.program_id = p_program_id THEN
3042:
3043: -- log message that the line has been processed by the concurrent_program

Line 3084: CTO_UTILITY_PK.query_sourcing_org(

3080: -- rkaza. 05/02/2005. ireq project
3081: -- call query sourcing org to get src type and distinguish internal
3082: -- external req cases.
3083: l_stmt_num := 22;
3084: CTO_UTILITY_PK.query_sourcing_org(
3085: p_inventory_item_id => so_line.inventory_item_id,
3086: p_organization_id => so_line.ship_from_org_id,
3087: p_sourcing_rule_exists => l_sourcing_rule_exists,
3088: p_sourcing_org => l_req_input_data.sourcing_org,

Line 3279: CTO_UTILITY_PK.query_sourcing_org(

3275: --IF l_item_type_code in ('STANDARD','OPTION') AND
3276: IF l_item_type_code in ('STANDARD','OPTION','INCLUDED') AND
3277: l_ato_line_id = oe_line_security.g_record.line_id THEN
3278:
3279: CTO_UTILITY_PK.query_sourcing_org(
3280: p_inventory_item_id => l_inv_item_id,
3281: p_organization_id => l_ship_org,
3282: p_sourcing_rule_exists => v_sourcing_rule_exists,
3283: p_source_type => v_source_type,

Line 3349: v_rsv_rec CTO_UTILITY_PK.resv_tbl_rec_type;

3345: l_config_line_id number ;
3346:
3347:
3348:
3349: v_rsv_rec CTO_UTILITY_PK.resv_tbl_rec_type;
3350: v_resv_code varchar2(200) ;
3351: v_sum_rxv_qty number ;
3352: v_return_status varchar2(200) ;
3353: v_msg_count number ;

Line 3455: CTO_UTILITY_PK.Get_Resv_Qty

3451:
3452:
3453: l_stmt_num := 30;
3454:
3455: CTO_UTILITY_PK.Get_Resv_Qty
3456: (
3457: p_order_line_id => l_config_line_id ,
3458: x_rsv_rec => v_rsv_rec,
3459: x_primary_uom_code => x_primary_uom_code,

Line 3532: l_rsv_rec CTO_UTILITY_PK.resv_tbl_rec_type;

3528: x_msg_data OUT NOCOPY Varchar2,
3529: x_msg_count OUT NOCOPY Number) is
3530:
3531: l_stmt_num Number;
3532: l_rsv_rec CTO_UTILITY_PK.resv_tbl_rec_type;
3533: x_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%type;
3534: l_sum_rsv_qty NUMBER;
3535: l_can_create_supply varchar2(1);
3536: --l_source_type VARCHAR2(5); -- bug 4552271. rkaza. 08/15/05.

Line 3569: CTO_UTILITY_PK.Get_Resv_Qty

3565: Begin
3566:
3567: --call API to get_reservation_code
3568: l_stmt_num := 10;
3569: CTO_UTILITY_PK.Get_Resv_Qty
3570: (
3571: p_order_line_id => p_order_line_id,
3572: x_rsv_rec => l_rsv_rec,
3573: x_primary_uom_code => x_primary_uom_code,

Line 3608: CTO_UTILITY_PK.check_cto_can_create_supply

3604: l_stmt_num :=20;
3605: If l_rsv_rec.count = 0 then
3606:
3607: l_stmt_num :=30;
3608: CTO_UTILITY_PK.check_cto_can_create_supply
3609: (
3610: P_config_item_id => p_config_item_id,
3611: P_org_id => p_ship_from_org_id,
3612: x_can_create_supply => l_can_create_supply,

Line 3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;

3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3645: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3646: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;
3647: --end cross_dock
3648:

Line 3645: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;

3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3645: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3646: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;
3647: --end cross_dock
3648:
3649: IF PG_DEBUG <> 0 THEN

Line 3646: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;

3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3645: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3646: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;
3647: --end cross_dock
3648:
3649: IF PG_DEBUG <> 0 THEN
3650: oe_debug_pub.add('get_status_tokens: '||'In IF BLOCK when l_rsv_rec count is > 0 ',5);