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_AUTO_PROCURE_PK dependencies on CTO_AUTO_PROCURE_PK

Line 1: PACKAGE BODY cto_auto_procure_pk AS

1: PACKAGE BODY cto_auto_procure_pk AS
2: /*$Header: CTOPROCB.pls 120.36.12020000.3 2013/01/08 09:44:07 kupradha ship $ */
3: /*============================================================================+
4: | Copyright (c) 1999 Oracle Corporation Belmont, California, USA |
5: | All rights reserved. |

Line 186: -- CTO_AUTO_PROCURE_PK

182: |
183: |
184: =============================================================================*/
185:
186: -- CTO_AUTO_PROCURE_PK
187: -- following parameters are created for
188: g_pkg_name CONSTANT VARCHAR2(30) := 'CTO_AUTO_PROCURE_PK';
189: gMrpAssignmentSet NUMBER ;
190:

Line 188: g_pkg_name CONSTANT VARCHAR2(30) := 'CTO_AUTO_PROCURE_PK';

184: =============================================================================*/
185:
186: -- CTO_AUTO_PROCURE_PK
187: -- following parameters are created for
188: g_pkg_name CONSTANT VARCHAR2(30) := 'CTO_AUTO_PROCURE_PK';
189: gMrpAssignmentSet NUMBER ;
190:
191:
192: --- Added by Renga for Purchaes price rollup

Line 269: x_oper_unit_list IN OUT NOCOPY cto_auto_procure_pk.oper_unit_tbl,

265: p_group_id in number,
266: p_overwrite_list_price in varchar2,
267: p_line_id in number,
268: p_mode in Varchar2 default 'ORDER',
269: x_oper_unit_list IN OUT NOCOPY cto_auto_procure_pk.oper_unit_tbl,
270: x_return_status out NOCOPY varchar2,
271: x_msg_data out NOCOPY varchar2,
272: x_msg_count out NOCOPY number);
273:

Line 418: l_res_quantity := cto_auto_procure_pk.get_reserved_qty(p_line_id);

414: oe_debug_pub.add('is_line_eligible: p_shipped_quantity = '|| p_shipped_quantity, 5);
415: oe_debug_pub.add('is_line_eligible: p_ordered_quantity = '|| p_ordered_quantity, 5);
416: END IF;
417:
418: l_res_quantity := cto_auto_procure_pk.get_reserved_qty(p_line_id);
419:
420: IF PG_DEBUG <> 0 THEN
421: oe_debug_pub.add('is_line_eligible: l_res_quantity = '|| l_res_quantity, 5);
422: END IF;

Line 2532: x_oper_unit_list IN OUT NOCOPY cto_auto_procure_pk.oper_unit_tbl,

2528: p_called_in_batch IN Varchar2 default 'N',
2529: p_batch_number IN OUT NOCOPY Number,
2530: p_mode IN Varchar2 Default 'ORDER',
2531: p_ato_line_id IN Number default null,
2532: x_oper_unit_list IN OUT NOCOPY cto_auto_procure_pk.oper_unit_tbl,
2533: x_return_status OUT NOCOPY Varchar2,
2534: x_msg_count OUT NOCOPY Number,
2535: x_msg_data OUT NOCOPY Varchar) is
2536:

Line 2957: x_oper_unit_list in out NOCOPY cto_auto_procure_pk.oper_unit_tbl,

2953: p_batch_id in out NOCOPY Number,
2954: p_group_id in Number,
2955: p_mode IN Varchar2 Default 'ORDER',
2956: p_line_id in number,
2957: x_oper_unit_list in out NOCOPY cto_auto_procure_pk.oper_unit_tbl,
2958: x_return_status out NOCOPY varchar2,
2959: x_msg_count out NOCOPY number,
2960: x_msg_data out NOCOPY varchar2) is
2961:

Line 3386: Cto_auto_procure_pk.G_oper_unit_list(x_org_id).oper_unit := x_org_id;

3382:
3383: x_oper_unit_list(x_org_id).oper_unit := x_org_id;
3384: -- The following global assignment is added becase Pro*c
3385: -- Cannot pass/receive record of tables.
3386: Cto_auto_procure_pk.G_oper_unit_list(x_org_id).oper_unit := x_org_id;
3387: end if;
3388: end if; /* If l_config_exists = 'Y' */
3389:
3390: end if; /* if config_exists_in_blanket */

Line 4294: x_oper_unit_list CTO_AUTO_PROCURE_PK.oper_unit_tbl;

4290: l_active_activity VARCHAR2(8);
4291:
4292: x_msg_count NUMBER;
4293: x_msg_data VARCHAR2(4000);
4294: x_oper_unit_list CTO_AUTO_PROCURE_PK.oper_unit_tbl;
4295: xUserId NUMBER;
4296: xrespid NUMBER;
4297: xrespapplid NUMBER;
4298:

Line 4633: CTO_AUTO_PROCURE_PK.Create_purchasing_doc(

4629: -- Set a savepoint so that we can rollback to this pt if something goes wrong.
4630: SAVEPOINT pp_rollup;
4631:
4632: -- call the purchase doc creation API.
4633: CTO_AUTO_PROCURE_PK.Create_purchasing_doc(
4634: p_config_item_id => ll_inventory_item_id,
4635: p_overwrite_list_price => p_overwrite_list_price,
4636: p_called_in_batch => 'Y',
4637: p_batch_number => l_batch_id,

Line 4839: p_oper_unit_list In cto_auto_procure_pk.oper_unit_tbl,

4835:
4836:
4837:
4838: Procedure Submit_pdoi_conc_prog(
4839: p_oper_unit_list In cto_auto_procure_pk.oper_unit_tbl,
4840: p_batch_id In Number,
4841: x_return_status Out NOCOPY Varchar2,
4842: x_msg_count Out NOCOPY Number,
4843: x_msg_data Out NOCOPY Varchar2) Is

Line 4954: i := CTO_AUTO_PROCURE_PK.G_oper_unit_list.first;

4950: Procedure empty_ou_global is
4951: i Number;
4952: begin
4953:
4954: i := CTO_AUTO_PROCURE_PK.G_oper_unit_list.first;
4955: while i is not null
4956: loop
4957: CTO_AUTO_PROCURE_PK.g_oper_unit_list.delete(i);
4958: i := g_oper_unit_list.next(i);

Line 4957: CTO_AUTO_PROCURE_PK.g_oper_unit_list.delete(i);

4953:
4954: i := CTO_AUTO_PROCURE_PK.G_oper_unit_list.first;
4955: while i is not null
4956: loop
4957: CTO_AUTO_PROCURE_PK.g_oper_unit_list.delete(i);
4958: i := g_oper_unit_list.next(i);
4959: end loop;
4960:
4961: end Empty_ou_global;

Line 4971: x_oper_unit_list IN OUT NOCOPY cto_auto_procure_pk.oper_unit_tbl,

4967: p_group_id in number,
4968: p_overwrite_list_price in varchar2,
4969: p_line_id in number,
4970: p_mode in Varchar2 default 'ORDER',
4971: x_oper_unit_list IN OUT NOCOPY cto_auto_procure_pk.oper_unit_tbl,
4972: x_return_status out NOCOPY varchar2,
4973: x_msg_data out NOCOPY varchar2,
4974: x_msg_count out NOCOPY number) is
4975: lStmtNumber Number;

Line 5044: cto_auto_procure_pk.Rollup_list_price(

5040: --- Call the list price API to rollup the list price of
5041: --- this model based on its components selected in OE
5042: If l_list_price is null or p_overwrite_list_price = 'Y' Then
5043: lStmtNumber := 30;
5044: cto_auto_procure_pk.Rollup_list_price(
5045: p_config_item_id => p_config_item_id,
5046: p_group_id => p_group_id,
5047: p_org_id => l_orgs_list(i),
5048: x_rolled_price => x_rolled_price,

Line 5218: --'and cto_auto_procure_pk.get_reserved_qty(oel.line_id)- nvl(oel.shipped_quantity,0) < oel.ordered_quantity '||

5214: 'and oel.booked_flag = ''Y'' '||
5215: 'and oel.schedule_status_code = ''SCHEDULED'' '||
5216: 'and oel.ordered_quantity > 0 ' ||
5217: --Bugfix 13500057: Debugging changes
5218: --'and cto_auto_procure_pk.get_reserved_qty(oel.line_id)- nvl(oel.shipped_quantity,0) < oel.ordered_quantity '||
5219: 'and cto_auto_procure_pk.is_line_eligible(oel.line_id, nvl(oel.shipped_quantity,0), oel.ordered_quantity) = ''TRUE'' ' ||
5220: 'and nvl (oel.shipped_quantity, 0) = 0 '||
5221: --Bugfix 9689936
5222: --'and oel.flow_status_code not in ( ''EXTERNAL_REQ_REQUESTED'',''INTERNAL_REQ_REQUESTED'',''AWAITING_SHIPPING'',''SHIPPED'',''PICKED'') '||

Line 5219: 'and cto_auto_procure_pk.is_line_eligible(oel.line_id, nvl(oel.shipped_quantity,0), oel.ordered_quantity) = ''TRUE'' ' ||

5215: 'and oel.schedule_status_code = ''SCHEDULED'' '||
5216: 'and oel.ordered_quantity > 0 ' ||
5217: --Bugfix 13500057: Debugging changes
5218: --'and cto_auto_procure_pk.get_reserved_qty(oel.line_id)- nvl(oel.shipped_quantity,0) < oel.ordered_quantity '||
5219: 'and cto_auto_procure_pk.is_line_eligible(oel.line_id, nvl(oel.shipped_quantity,0), oel.ordered_quantity) = ''TRUE'' ' ||
5220: 'and nvl (oel.shipped_quantity, 0) = 0 '||
5221: --Bugfix 9689936
5222: --'and oel.flow_status_code not in ( ''EXTERNAL_REQ_REQUESTED'',''INTERNAL_REQ_REQUESTED'',''AWAITING_SHIPPING'',''SHIPPED'',''PICKED'') '||
5223: --Bugfix 10235354

Line 5635: END cto_auto_procure_pk;

5631:
5632:
5633:
5634:
5635: END cto_auto_procure_pk;