DBA Data[Home] [Help]

APPS.ENG_LAUNCH_ECO_OI_PK dependencies on ENG_ECO_PUB

Line 48: g_public_eco_rec ENG_Eco_PUB.Eco_Rec_Type;

44: -- record structures without ifce keys.
45: -- rev comps structures have parent rev items index keys
46: -- ref desgs and sub comps have parent rev comps and grand parent rev items ifce keys
47:
48: g_public_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
49: g_public_out_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
50: g_public_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
51: g_public_out_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
52: g_public_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 49: g_public_out_eco_rec ENG_Eco_PUB.Eco_Rec_Type;

45: -- rev comps structures have parent rev items index keys
46: -- ref desgs and sub comps have parent rev comps and grand parent rev items ifce keys
47:
48: g_public_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
49: g_public_out_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
50: g_public_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
51: g_public_out_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
52: g_public_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
53: g_public_out_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 50: g_public_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

46: -- ref desgs and sub comps have parent rev comps and grand parent rev items ifce keys
47:
48: g_public_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
49: g_public_out_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
50: g_public_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
51: g_public_out_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
52: g_public_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
53: g_public_out_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
54: g_public_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;

Line 51: g_public_out_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

47:
48: g_public_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
49: g_public_out_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
50: g_public_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
51: g_public_out_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
52: g_public_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
53: g_public_out_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
54: g_public_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;
55: g_public_out_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;

Line 52: g_public_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

48: g_public_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
49: g_public_out_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
50: g_public_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
51: g_public_out_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
52: g_public_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
53: g_public_out_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
54: g_public_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;
55: g_public_out_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;
56: g_public_rev_comp_tbl Bom_Bo_PUB.Rev_Component_Tbl_Type;

Line 53: g_public_out_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

49: g_public_out_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
50: g_public_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
51: g_public_out_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
52: g_public_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
53: g_public_out_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
54: g_public_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;
55: g_public_out_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;
56: g_public_rev_comp_tbl Bom_Bo_PUB.Rev_Component_Tbl_Type;
57: g_public_out_rev_comp_tbl Bom_Bo_PUB.Rev_Component_Tbl_Type;

Line 54: g_public_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;

50: g_public_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
51: g_public_out_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
52: g_public_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
53: g_public_out_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
54: g_public_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;
55: g_public_out_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;
56: g_public_rev_comp_tbl Bom_Bo_PUB.Rev_Component_Tbl_Type;
57: g_public_out_rev_comp_tbl Bom_Bo_PUB.Rev_Component_Tbl_Type;
58: g_public_ref_des_tbl Bom_Bo_PUB.Ref_Designator_Tbl_Type;

Line 55: g_public_out_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;

51: g_public_out_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
52: g_public_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
53: g_public_out_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
54: g_public_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;
55: g_public_out_lines_tbl ENG_Eco_PUB.Change_Line_Tbl_Type;
56: g_public_rev_comp_tbl Bom_Bo_PUB.Rev_Component_Tbl_Type;
57: g_public_out_rev_comp_tbl Bom_Bo_PUB.Rev_Component_Tbl_Type;
58: g_public_ref_des_tbl Bom_Bo_PUB.Ref_Designator_Tbl_Type;
59: g_public_out_ref_des_tbl Bom_Bo_PUB.Ref_Designator_Tbl_Type;

Line 1031: p_eco_rec ENG_Eco_PUB.Eco_Rec_Type

1027: END Update_Interface_Tables;
1028:
1029:
1030: PROCEDURE Update_Eco_Interface (
1031: p_eco_rec ENG_Eco_PUB.Eco_Rec_Type
1032: ) IS
1033: BEGIN
1034: UPDATE eng_eng_changes_interface
1035: SET ATTRIBUTE7 = p_eco_rec.attribute7

Line 1090: p_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type

1086: END Update_Eco_Interface;
1087:
1088:
1089: PROCEDURE Update_Eco_Revisions_Interface (
1090: p_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type
1091: ) IS
1092: BEGIN
1093: FOR i IN 1..p_rev_tbl.COUNT LOOP
1094: UPDATE eng_eco_revisions_interface SET

Line 1134: p_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type

1130: END Update_Eco_Revisions_Interface;
1131:
1132:
1133: PROCEDURE Update_Revised_Items_Interface (
1134: p_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type
1135: ) IS
1136: BEGIN
1137: FOR i IN 1..p_rev_item_tbl.COUNT LOOP
1138: UPDATE eng_revised_items_interface SET

Line 1397: p_error_tbl ENG_Eco_PUB.Error_Tbl_Type,

1393: END Update_Ref_Desig_Interface;
1394:
1395: /*
1396: PROCEDURE Update_Error_Table (
1397: p_error_tbl ENG_Eco_PUB.Error_Tbl_Type,
1398: p_top_ifce_key VARCHAR2 DEFAULT NULL,
1399: x_unexp_error OUT NOCOPY VARCHAR2
1400: ) IS
1401: BEGIN

Line 2961: -- l_error_tbl ENG_Eco_PUB.Error_Tbl_Type;

2957: l_return_status VARCHAR2(1);
2958: l_msg_count NUMBER;
2959: l_msg_data VARCHAR2(2000);
2960: l_unexp_error VARCHAR2(1000);
2961: -- l_error_tbl ENG_Eco_PUB.Error_Tbl_Type;
2962: l_log_msg VARCHAR2(2000);
2963: l_err_text VARCHAR2(2000);
2964:
2965: l_top_ifce_key VARCHAR2(240);

Line 3370: Eng_Eco_Pub.Process_Eco (

3366: IF g_ECO_ifce_key IS NULL
3367: THEN
3368: g_ECO_exists := TRUE;
3369: --dbms_output.put_line('No ifce key - Call Public API for ECO record');
3370: Eng_Eco_Pub.Process_Eco (
3371: p_api_version_number => 1.0,
3372: p_init_msg_list => true,
3373: --p_commit => FND_API.G_FALSE,
3374: x_return_status => l_return_status,

Line 3499: Eng_Eco_Pub.Process_Eco (

3495:
3496: stmt_num := 35;
3497: --dbms_output.put_line('ifce key exists - Call Public API for ECO entity');
3498:
3499: Eng_Eco_Pub.Process_Eco (
3500: p_api_version_number => 1.0,
3501: p_init_msg_list => true,
3502: x_return_status => l_return_status,
3503: x_msg_count => l_msg_count,

Line 3667: Eng_Eco_Pub.Process_Eco (

3663: -- Call Public API
3664:
3665: stmt_num := 77;
3666: --dbms_output.put_line('No ECO Headers - Call Public API with items starting hierarchy');
3667: Eng_Eco_Pub.Process_Eco (
3668: p_api_version_number => 1.0,
3669: p_init_msg_list => true,
3670: --p_commit => FND_API.G_FALSE,
3671: x_return_status => l_return_status,

Line 3674: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

3670: --p_commit => FND_API.G_FALSE,
3671: x_return_status => l_return_status,
3672: x_msg_count => l_msg_count,
3673: --x_msg_data => l_msg_data,
3674: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3675: p_eco_revision_tbl => g_public_rev_tbl,
3676: p_revised_item_tbl => g_public_rev_item_tbl,
3677: p_rev_component_tbl => g_public_rev_comp_tbl,
3678: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 3805: Eng_Eco_Pub.Process_Eco (

3801: -- Call Public API
3802:
3803: stmt_num := 115;
3804: --dbms_output.put_line('No ECO Headers - Call Public API with revs starting hierarchy');
3805: Eng_Eco_Pub.Process_Eco (
3806: p_api_version_number => 1.0,
3807: p_init_msg_list => true,
3808: --p_commit => FND_API.G_FALSE,
3809: x_return_status => l_return_status,

Line 3812: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

3808: --p_commit => FND_API.G_FALSE,
3809: x_return_status => l_return_status,
3810: x_msg_count => l_msg_count,
3811: --x_msg_data => l_msg_data,
3812: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3813: p_eco_revision_tbl => g_public_rev_tbl,
3814: p_revised_item_tbl => g_public_rev_item_tbl,
3815: p_rev_component_tbl => g_public_rev_comp_tbl,
3816: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 3940: Eng_Eco_Pub.Process_Eco (

3936: -- Call Public API
3937:
3938: stmt_num := 151;
3939: --dbms_output.put_line('No ECO Headers - Call Public API with comps starting hierarchy');
3940: Eng_Eco_Pub.Process_Eco (
3941: p_api_version_number => 1.0,
3942: p_init_msg_list => true,
3943: --p_commit => FND_API.G_FALSE,
3944: x_return_status => l_return_status,

Line 3947: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

3943: --p_commit => FND_API.G_FALSE,
3944: x_return_status => l_return_status,
3945: x_msg_count => l_msg_count,
3946: --x_msg_data => l_msg_data,
3947: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3948: p_eco_revision_tbl => g_public_rev_tbl,
3949: p_revised_item_tbl => g_public_rev_item_tbl,
3950: p_rev_component_tbl => g_public_rev_comp_tbl,
3951: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 4062: Eng_Eco_Pub.Process_Eco (

4058: -- Call Public API
4059:
4060: stmt_num := 181;
4061: --dbms_output.put_line('No ECO Headers - Call Public API with desgs starting hierarchy');
4062: Eng_Eco_Pub.Process_Eco (
4063: p_api_version_number => 1.0,
4064: p_init_msg_list => true,
4065: --p_commit => FND_API.G_FALSE,
4066: x_return_status => l_return_status,

Line 4069: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

4065: --p_commit => FND_API.G_FALSE,
4066: x_return_status => l_return_status,
4067: x_msg_count => l_msg_count,
4068: --x_msg_data => l_msg_data,
4069: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4070: p_eco_revision_tbl => g_public_rev_tbl,
4071: p_revised_item_tbl => g_public_rev_item_tbl,
4072: p_rev_component_tbl => g_public_rev_comp_tbl,
4073: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 4180: Eng_Eco_Pub.Process_Eco (

4176: -- Call Public API
4177:
4178: stmt_num := 207;
4179: --dbms_output.put_line('No ECO Headers - Call Public API with sbcs starting hierarchy');
4180: Eng_Eco_Pub.Process_Eco (
4181: p_api_version_number => 1.0,
4182: p_init_msg_list => true,
4183: --p_commit => FND_API.G_FALSE,
4184: x_return_status => l_return_status,

Line 4187: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

4183: --p_commit => FND_API.G_FALSE,
4184: x_return_status => l_return_status,
4185: x_msg_count => l_msg_count,
4186: --x_msg_data => l_msg_data,
4187: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4188: p_eco_revision_tbl => g_public_rev_tbl,
4189: p_revised_item_tbl => g_public_rev_item_tbl,
4190: p_rev_component_tbl => g_public_rev_comp_tbl,
4191: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 4297: Eng_Eco_Pub.Process_Eco (

4293: -- Call Public API
4294:
4295: stmt_num := 181;
4296: --dbms_output.put_line('No ECO Headers - Call Public API with desgs starting hierarchy');
4297: Eng_Eco_Pub.Process_Eco (
4298: p_api_version_number => 1.0,
4299: p_init_msg_list => true,
4300: x_return_status => l_return_status,
4301: x_msg_count => l_msg_count,

Line 4414: Eng_Eco_Pub.Process_Eco (

4410:
4411: -- Call Public API
4412:
4413: stmt_num := 181;
4414: Eng_Eco_Pub.Process_Eco (
4415: p_api_version_number => 1.0,
4416: p_init_msg_list => true,
4417: x_return_status => l_return_status,
4418: x_msg_count => l_msg_count,

Line 4532: Eng_Eco_Pub.Process_Eco (

4528:
4529: -- Call Public API
4530:
4531: stmt_num := 181;
4532: Eng_Eco_Pub.Process_Eco (
4533: p_api_version_number => 1.0,
4534: p_init_msg_list => true,
4535: x_return_status => l_return_status,
4536: x_msg_count => l_msg_count,

Line 4641: Eng_Eco_Pub.Process_Eco (

4637: g_public_rev_tbl(q).transaction_type := c7rec.transaction_type;
4638:
4639: stmt_num := 226;
4640: --dbms_output.put_line('Call Public API for revision record');
4641: Eng_Eco_Pub.Process_Eco (
4642: p_api_version_number => 1.0,
4643: p_init_msg_list => true,
4644: --p_commit => FND_API.G_FALSE,
4645: x_return_status => l_return_status,

Line 4648: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

4644: --p_commit => FND_API.G_FALSE,
4645: x_return_status => l_return_status,
4646: x_msg_count => l_msg_count,
4647: --x_msg_data => l_msg_data,
4648: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4649: p_eco_revision_tbl => g_public_rev_tbl,
4650: p_revised_item_tbl => g_public_rev_item_tbl,
4651: p_rev_component_tbl => g_public_rev_comp_tbl,
4652: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 4800: Eng_Eco_Pub.Process_Eco (

4796: stmt_num := 244;
4797: Move_Encoin_Struct_To_Public;
4798:
4799: stmt_num := 245;
4800: Eng_Eco_Pub.Process_Eco (
4801: p_api_version_number => 1.0,
4802: p_init_msg_list => true,
4803: --p_commit => FND_API.G_FALSE,
4804: x_return_status => l_return_status,

Line 4807: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

4803: --p_commit => FND_API.G_FALSE,
4804: x_return_status => l_return_status,
4805: x_msg_count => l_msg_count,
4806: --x_msg_data => l_msg_data,
4807: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4808: p_eco_revision_tbl => g_public_rev_tbl,
4809: p_revised_item_tbl => g_public_rev_item_tbl,
4810: p_rev_component_tbl => g_public_rev_comp_tbl,
4811: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 4902: Eng_Eco_Pub.Process_Eco (

4898: -- Call Public API
4899:
4900: stmt_num := 267;
4901: --dbms_output.put_line('Ifce key exists - Call Public API for item');
4902: Eng_Eco_Pub.Process_Eco (
4903: p_api_version_number => 1.0,
4904: p_init_msg_list => true,
4905: --p_commit => FND_API.G_FALSE,
4906: x_return_status => l_return_status,

Line 4909: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

4905: --p_commit => FND_API.G_FALSE,
4906: x_return_status => l_return_status,
4907: x_msg_count => l_msg_count,
4908: --x_msg_data => l_msg_data,
4909: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4910: p_eco_revision_tbl => g_public_rev_tbl,
4911: p_revised_item_tbl => g_public_rev_item_tbl,
4912: p_rev_component_tbl => g_public_rev_comp_tbl,
4913: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5051: Eng_Eco_Pub.Process_Eco (

5047: -- Call Public API
5048:
5049: stmt_num := 304;
5050: --dbms_output.put_line('No Items - Call Public API with comps starting hierarchy');
5051: Eng_Eco_Pub.Process_Eco (
5052: p_api_version_number => 1.0,
5053: p_init_msg_list => true,
5054: --p_commit => FND_API.G_FALSE,
5055: x_return_status => l_return_status,

Line 5058: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5054: --p_commit => FND_API.G_FALSE,
5055: x_return_status => l_return_status,
5056: x_msg_count => l_msg_count,
5057: --x_msg_data => l_msg_data,
5058: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5059: p_eco_revision_tbl => g_public_rev_tbl,
5060: p_revised_item_tbl => g_public_rev_item_tbl,
5061: p_rev_component_tbl => g_public_rev_comp_tbl,
5062: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5175: Eng_Eco_Pub.Process_Eco (

5171: -- Call Public API
5172:
5173: stmt_num := 334;
5174: --dbms_output.put_line('No Items - Call Public API with desgs starting hierarchy');
5175: Eng_Eco_Pub.Process_Eco (
5176: p_api_version_number => 1.0,
5177: p_init_msg_list => true,
5178: --p_commit => FND_API.G_FALSE,
5179: x_return_status => l_return_status,

Line 5182: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5178: --p_commit => FND_API.G_FALSE,
5179: x_return_status => l_return_status,
5180: x_msg_count => l_msg_count,
5181: --x_msg_data => l_msg_data,
5182: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5183: p_eco_revision_tbl => g_public_rev_tbl,
5184: p_revised_item_tbl => g_public_rev_item_tbl,
5185: p_rev_component_tbl => g_public_rev_comp_tbl,
5186: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5294: Eng_Eco_Pub.Process_Eco (

5290: -- Call Public API
5291:
5292: stmt_num := 360;
5293: --dbms_output.put_line('No Items - Call Public API with sbcs starting hierarchy');
5294: Eng_Eco_Pub.Process_Eco (
5295: p_api_version_number => 1.0,
5296: p_init_msg_list => true,
5297: --p_commit => FND_API.G_FALSE,
5298: x_return_status => l_return_status,

Line 5301: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5297: --p_commit => FND_API.G_FALSE,
5298: x_return_status => l_return_status,
5299: x_msg_count => l_msg_count,
5300: --x_msg_data => l_msg_data,
5301: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5302: p_eco_revision_tbl => g_public_rev_tbl,
5303: p_revised_item_tbl => g_public_rev_item_tbl,
5304: p_rev_component_tbl => g_public_rev_comp_tbl,
5305: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5471: Eng_Eco_Pub.Process_Eco (

5467: --dbms_output.put_line('No ifce key - Call Public API for comp');
5468: Move_Encoin_Struct_To_Public;
5469:
5470: stmt_num := 382.5;
5471: Eng_Eco_Pub.Process_Eco (
5472: p_api_version_number => 1.0,
5473: p_init_msg_list => true,
5474: --p_commit => FND_API.G_FALSE,
5475: x_return_status => l_return_status,

Line 5478: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5474: --p_commit => FND_API.G_FALSE,
5475: x_return_status => l_return_status,
5476: x_msg_count => l_msg_count,
5477: --x_msg_data => l_msg_data,
5478: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5479: p_eco_revision_tbl => g_public_rev_tbl,
5480: p_revised_item_tbl => g_public_rev_item_tbl,
5481: p_rev_component_tbl => g_public_rev_comp_tbl,
5482: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5559: Eng_Eco_Pub.Process_Eco (

5555: -- Call Public API
5556:
5557: stmt_num := 402;
5558: --dbms_output.put_line('Ifce key exists - Call Public API for comp');
5559: Eng_Eco_Pub.Process_Eco (
5560: p_api_version_number => 1.0,
5561: p_init_msg_list => true,
5562: --p_commit => FND_API.G_FALSE,
5563: x_return_status => l_return_status,

Line 5566: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5562: --p_commit => FND_API.G_FALSE,
5563: x_return_status => l_return_status,
5564: x_msg_count => l_msg_count,
5565: --x_msg_data => l_msg_data,
5566: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5567: p_eco_revision_tbl => g_public_rev_tbl,
5568: p_revised_item_tbl => g_public_rev_item_tbl,
5569: p_rev_component_tbl => g_public_rev_comp_tbl,
5570: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5706: Eng_Eco_Pub.Process_Eco (

5702: -- Call Public API
5703:
5704: stmt_num := 434;
5705: --dbms_output.put_line('No Comps - Call Public API with desgs starting hierarchy');
5706: Eng_Eco_Pub.Process_Eco (
5707: p_api_version_number => 1.0,
5708: p_init_msg_list => true,
5709: --p_commit => FND_API.G_FALSE,
5710: x_return_status => l_return_status,

Line 5713: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5709: --p_commit => FND_API.G_FALSE,
5710: x_return_status => l_return_status,
5711: x_msg_count => l_msg_count,
5712: --x_msg_data => l_msg_data,
5713: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5714: p_eco_revision_tbl => g_public_rev_tbl,
5715: p_revised_item_tbl => g_public_rev_item_tbl,
5716: p_rev_component_tbl => g_public_rev_comp_tbl,
5717: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5820: Eng_Eco_Pub.Process_Eco (

5816: -- Call Public API
5817:
5818: stmt_num := 459;
5819: --dbms_output.put_line('No Comps - Call Public API with sbcs starting hierarchy');
5820: Eng_Eco_Pub.Process_Eco (
5821: p_api_version_number => 1.0,
5822: p_init_msg_list => true,
5823: --p_commit => FND_API.G_FALSE,
5824: x_return_status => l_return_status,

Line 5827: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5823: --p_commit => FND_API.G_FALSE,
5824: x_return_status => l_return_status,
5825: x_msg_count => l_msg_count,
5826: --x_msg_data => l_msg_data,
5827: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5828: p_eco_revision_tbl => g_public_rev_tbl,
5829: p_revised_item_tbl => g_public_rev_item_tbl,
5830: p_rev_component_tbl => g_public_rev_comp_tbl,
5831: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5942: Eng_Eco_Pub.Process_Eco (

5938:
5939:
5940: stmt_num := 478;
5941: --dbms_output.put_line('Call Public API for Reference Designator entity');
5942: Eng_Eco_Pub.Process_Eco (
5943: p_api_version_number => 1.0,
5944: p_init_msg_list => true,
5945: --p_commit => FND_API.G_FALSE,
5946: x_return_status => l_return_status,

Line 5949: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5945: --p_commit => FND_API.G_FALSE,
5946: x_return_status => l_return_status,
5947: x_msg_count => l_msg_count,
5948: --x_msg_data => l_msg_data,
5949: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5950: p_eco_revision_tbl => g_public_rev_tbl,
5951: p_revised_item_tbl => g_public_rev_item_tbl,
5952: p_rev_component_tbl => g_public_rev_comp_tbl,
5953: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 6072: Eng_Eco_Pub.Process_Eco (

6068: g_public_sub_comp_tbl(z).New_revised_Item_Revision := c16rec.New_revised_Item_Revision;
6069:
6070: stmt_num := 497;
6071: --dbms_output.put_line('Call Public API from Substitute Component entity');
6072: Eng_Eco_Pub.Process_Eco (
6073: p_api_version_number => 1.0,
6074: p_init_msg_list => true,
6075: --p_commit => FND_API.G_FALSE,
6076: x_return_status => l_return_status,

Line 6079: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

6075: --p_commit => FND_API.G_FALSE,
6076: x_return_status => l_return_status,
6077: x_msg_count => l_msg_count,
6078: --x_msg_data => l_msg_data,
6079: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
6080: p_eco_revision_tbl => g_public_rev_tbl,
6081: p_revised_item_tbl => g_public_rev_item_tbl,
6082: p_rev_component_tbl => g_public_rev_comp_tbl,
6083: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 6304: -- l_error_tbl ENG_Eco_PUB.Error_Tbl_Type;

6300: l_msg_count NUMBER;
6301: l_msg_data VARCHAR2(2000);
6302: l_unexp_error VARCHAR2(1000);
6303: l_transaction_id NUMBER;
6304: -- l_error_tbl ENG_Eco_PUB.Error_Tbl_Type;
6305: -- l_log_msg VARCHAR2(2000);
6306: -- l_err_text VARCHAR2(2000);
6307:
6308: r NUMBER := 0;

Line 6511: Eng_Eco_Pub.Process_Eco (

6507: stmt_num := 244;
6508: Move_Encoin_Struct_To_Public;
6509:
6510: stmt_num := 245;
6511: Eng_Eco_Pub.Process_Eco (
6512: p_api_version_number => 1.0,
6513: p_init_msg_list => true,
6514: --p_commit => FND_API.G_FALSE,
6515: x_return_status => l_return_status,

Line 6518: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

6514: --p_commit => FND_API.G_FALSE,
6515: x_return_status => l_return_status,
6516: x_msg_count => l_msg_count,
6517: --x_msg_data => l_msg_data,
6518: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
6519: p_eco_revision_tbl => g_public_rev_tbl,
6520: p_revised_item_tbl => g_public_rev_item_tbl,
6521: p_rev_component_tbl => g_public_rev_comp_tbl,
6522: p_ref_designator_tbl => g_public_ref_des_tbl,