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 1027: p_eco_rec ENG_Eco_PUB.Eco_Rec_Type

1023: END Update_Interface_Tables;
1024:
1025:
1026: PROCEDURE Update_Eco_Interface (
1027: p_eco_rec ENG_Eco_PUB.Eco_Rec_Type
1028: ) IS
1029: BEGIN
1030: UPDATE eng_eng_changes_interface
1031: SET ATTRIBUTE7 = p_eco_rec.attribute7

Line 1086: p_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type

1082: END Update_Eco_Interface;
1083:
1084:
1085: PROCEDURE Update_Eco_Revisions_Interface (
1086: p_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type
1087: ) IS
1088: BEGIN
1089: FOR i IN 1..p_rev_tbl.COUNT LOOP
1090: UPDATE eng_eco_revisions_interface SET

Line 1130: p_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type

1126: END Update_Eco_Revisions_Interface;
1127:
1128:
1129: PROCEDURE Update_Revised_Items_Interface (
1130: p_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type
1131: ) IS
1132: BEGIN
1133: FOR i IN 1..p_rev_item_tbl.COUNT LOOP
1134: UPDATE eng_revised_items_interface SET

Line 1393: p_error_tbl ENG_Eco_PUB.Error_Tbl_Type,

1389: END Update_Ref_Desig_Interface;
1390:
1391: /*
1392: PROCEDURE Update_Error_Table (
1393: p_error_tbl ENG_Eco_PUB.Error_Tbl_Type,
1394: p_top_ifce_key VARCHAR2 DEFAULT NULL,
1395: x_unexp_error OUT NOCOPY VARCHAR2
1396: ) IS
1397: BEGIN

Line 2955: -- l_error_tbl ENG_Eco_PUB.Error_Tbl_Type;

2951: l_return_status VARCHAR2(1);
2952: l_msg_count NUMBER;
2953: l_msg_data VARCHAR2(2000);
2954: l_unexp_error VARCHAR2(1000);
2955: -- l_error_tbl ENG_Eco_PUB.Error_Tbl_Type;
2956: l_log_msg VARCHAR2(2000);
2957: l_err_text VARCHAR2(2000);
2958:
2959: l_top_ifce_key VARCHAR2(240);

Line 3364: Eng_Eco_Pub.Process_Eco (

3360: IF g_ECO_ifce_key IS NULL
3361: THEN
3362: g_ECO_exists := TRUE;
3363: --dbms_output.put_line('No ifce key - Call Public API for ECO record');
3364: Eng_Eco_Pub.Process_Eco (
3365: p_api_version_number => 1.0,
3366: p_init_msg_list => true,
3367: --p_commit => FND_API.G_FALSE,
3368: x_return_status => l_return_status,

Line 3492: Eng_Eco_Pub.Process_Eco (

3488:
3489: stmt_num := 35;
3490: --dbms_output.put_line('ifce key exists - Call Public API for ECO entity');
3491:
3492: Eng_Eco_Pub.Process_Eco (
3493: p_api_version_number => 1.0,
3494: p_init_msg_list => true,
3495: x_return_status => l_return_status,
3496: x_msg_count => l_msg_count,

Line 3659: Eng_Eco_Pub.Process_Eco (

3655: -- Call Public API
3656:
3657: stmt_num := 77;
3658: --dbms_output.put_line('No ECO Headers - Call Public API with items starting hierarchy');
3659: Eng_Eco_Pub.Process_Eco (
3660: p_api_version_number => 1.0,
3661: p_init_msg_list => true,
3662: --p_commit => FND_API.G_FALSE,
3663: x_return_status => l_return_status,

Line 3666: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

3662: --p_commit => FND_API.G_FALSE,
3663: x_return_status => l_return_status,
3664: x_msg_count => l_msg_count,
3665: --x_msg_data => l_msg_data,
3666: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3667: p_eco_revision_tbl => g_public_rev_tbl,
3668: p_revised_item_tbl => g_public_rev_item_tbl,
3669: p_rev_component_tbl => g_public_rev_comp_tbl,
3670: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 3796: Eng_Eco_Pub.Process_Eco (

3792: -- Call Public API
3793:
3794: stmt_num := 115;
3795: --dbms_output.put_line('No ECO Headers - Call Public API with revs starting hierarchy');
3796: Eng_Eco_Pub.Process_Eco (
3797: p_api_version_number => 1.0,
3798: p_init_msg_list => true,
3799: --p_commit => FND_API.G_FALSE,
3800: x_return_status => l_return_status,

Line 3803: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

3799: --p_commit => FND_API.G_FALSE,
3800: x_return_status => l_return_status,
3801: x_msg_count => l_msg_count,
3802: --x_msg_data => l_msg_data,
3803: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3804: p_eco_revision_tbl => g_public_rev_tbl,
3805: p_revised_item_tbl => g_public_rev_item_tbl,
3806: p_rev_component_tbl => g_public_rev_comp_tbl,
3807: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 3930: Eng_Eco_Pub.Process_Eco (

3926: -- Call Public API
3927:
3928: stmt_num := 151;
3929: --dbms_output.put_line('No ECO Headers - Call Public API with comps starting hierarchy');
3930: Eng_Eco_Pub.Process_Eco (
3931: p_api_version_number => 1.0,
3932: p_init_msg_list => true,
3933: --p_commit => FND_API.G_FALSE,
3934: x_return_status => l_return_status,

Line 3937: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

3933: --p_commit => FND_API.G_FALSE,
3934: x_return_status => l_return_status,
3935: x_msg_count => l_msg_count,
3936: --x_msg_data => l_msg_data,
3937: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3938: p_eco_revision_tbl => g_public_rev_tbl,
3939: p_revised_item_tbl => g_public_rev_item_tbl,
3940: p_rev_component_tbl => g_public_rev_comp_tbl,
3941: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 4051: Eng_Eco_Pub.Process_Eco (

4047: -- Call Public API
4048:
4049: stmt_num := 181;
4050: --dbms_output.put_line('No ECO Headers - Call Public API with desgs starting hierarchy');
4051: Eng_Eco_Pub.Process_Eco (
4052: p_api_version_number => 1.0,
4053: p_init_msg_list => true,
4054: --p_commit => FND_API.G_FALSE,
4055: x_return_status => l_return_status,

Line 4058: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

4054: --p_commit => FND_API.G_FALSE,
4055: x_return_status => l_return_status,
4056: x_msg_count => l_msg_count,
4057: --x_msg_data => l_msg_data,
4058: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4059: p_eco_revision_tbl => g_public_rev_tbl,
4060: p_revised_item_tbl => g_public_rev_item_tbl,
4061: p_rev_component_tbl => g_public_rev_comp_tbl,
4062: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 4168: Eng_Eco_Pub.Process_Eco (

4164: -- Call Public API
4165:
4166: stmt_num := 207;
4167: --dbms_output.put_line('No ECO Headers - Call Public API with sbcs starting hierarchy');
4168: Eng_Eco_Pub.Process_Eco (
4169: p_api_version_number => 1.0,
4170: p_init_msg_list => true,
4171: --p_commit => FND_API.G_FALSE,
4172: x_return_status => l_return_status,

Line 4175: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

4171: --p_commit => FND_API.G_FALSE,
4172: x_return_status => l_return_status,
4173: x_msg_count => l_msg_count,
4174: --x_msg_data => l_msg_data,
4175: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4176: p_eco_revision_tbl => g_public_rev_tbl,
4177: p_revised_item_tbl => g_public_rev_item_tbl,
4178: p_rev_component_tbl => g_public_rev_comp_tbl,
4179: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 4284: Eng_Eco_Pub.Process_Eco (

4280: -- Call Public API
4281:
4282: stmt_num := 181;
4283: --dbms_output.put_line('No ECO Headers - Call Public API with desgs starting hierarchy');
4284: Eng_Eco_Pub.Process_Eco (
4285: p_api_version_number => 1.0,
4286: p_init_msg_list => true,
4287: x_return_status => l_return_status,
4288: x_msg_count => l_msg_count,

Line 4400: Eng_Eco_Pub.Process_Eco (

4396:
4397: -- Call Public API
4398:
4399: stmt_num := 181;
4400: Eng_Eco_Pub.Process_Eco (
4401: p_api_version_number => 1.0,
4402: p_init_msg_list => true,
4403: x_return_status => l_return_status,
4404: x_msg_count => l_msg_count,

Line 4517: Eng_Eco_Pub.Process_Eco (

4513:
4514: -- Call Public API
4515:
4516: stmt_num := 181;
4517: Eng_Eco_Pub.Process_Eco (
4518: p_api_version_number => 1.0,
4519: p_init_msg_list => true,
4520: x_return_status => l_return_status,
4521: x_msg_count => l_msg_count,

Line 4625: Eng_Eco_Pub.Process_Eco (

4621: g_public_rev_tbl(q).transaction_type := c7rec.transaction_type;
4622:
4623: stmt_num := 226;
4624: --dbms_output.put_line('Call Public API for revision record');
4625: Eng_Eco_Pub.Process_Eco (
4626: p_api_version_number => 1.0,
4627: p_init_msg_list => true,
4628: --p_commit => FND_API.G_FALSE,
4629: x_return_status => l_return_status,

Line 4632: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

4628: --p_commit => FND_API.G_FALSE,
4629: x_return_status => l_return_status,
4630: x_msg_count => l_msg_count,
4631: --x_msg_data => l_msg_data,
4632: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4633: p_eco_revision_tbl => g_public_rev_tbl,
4634: p_revised_item_tbl => g_public_rev_item_tbl,
4635: p_rev_component_tbl => g_public_rev_comp_tbl,
4636: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 4783: Eng_Eco_Pub.Process_Eco (

4779: stmt_num := 244;
4780: Move_Encoin_Struct_To_Public;
4781:
4782: stmt_num := 245;
4783: Eng_Eco_Pub.Process_Eco (
4784: p_api_version_number => 1.0,
4785: p_init_msg_list => true,
4786: --p_commit => FND_API.G_FALSE,
4787: x_return_status => l_return_status,

Line 4790: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

4786: --p_commit => FND_API.G_FALSE,
4787: x_return_status => l_return_status,
4788: x_msg_count => l_msg_count,
4789: --x_msg_data => l_msg_data,
4790: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4791: p_eco_revision_tbl => g_public_rev_tbl,
4792: p_revised_item_tbl => g_public_rev_item_tbl,
4793: p_rev_component_tbl => g_public_rev_comp_tbl,
4794: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 4884: Eng_Eco_Pub.Process_Eco (

4880: -- Call Public API
4881:
4882: stmt_num := 267;
4883: --dbms_output.put_line('Ifce key exists - Call Public API for item');
4884: Eng_Eco_Pub.Process_Eco (
4885: p_api_version_number => 1.0,
4886: p_init_msg_list => true,
4887: --p_commit => FND_API.G_FALSE,
4888: x_return_status => l_return_status,

Line 4891: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

4887: --p_commit => FND_API.G_FALSE,
4888: x_return_status => l_return_status,
4889: x_msg_count => l_msg_count,
4890: --x_msg_data => l_msg_data,
4891: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4892: p_eco_revision_tbl => g_public_rev_tbl,
4893: p_revised_item_tbl => g_public_rev_item_tbl,
4894: p_rev_component_tbl => g_public_rev_comp_tbl,
4895: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5032: Eng_Eco_Pub.Process_Eco (

5028: -- Call Public API
5029:
5030: stmt_num := 304;
5031: --dbms_output.put_line('No Items - Call Public API with comps starting hierarchy');
5032: Eng_Eco_Pub.Process_Eco (
5033: p_api_version_number => 1.0,
5034: p_init_msg_list => true,
5035: --p_commit => FND_API.G_FALSE,
5036: x_return_status => l_return_status,

Line 5039: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5035: --p_commit => FND_API.G_FALSE,
5036: x_return_status => l_return_status,
5037: x_msg_count => l_msg_count,
5038: --x_msg_data => l_msg_data,
5039: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5040: p_eco_revision_tbl => g_public_rev_tbl,
5041: p_revised_item_tbl => g_public_rev_item_tbl,
5042: p_rev_component_tbl => g_public_rev_comp_tbl,
5043: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5155: Eng_Eco_Pub.Process_Eco (

5151: -- Call Public API
5152:
5153: stmt_num := 334;
5154: --dbms_output.put_line('No Items - Call Public API with desgs starting hierarchy');
5155: Eng_Eco_Pub.Process_Eco (
5156: p_api_version_number => 1.0,
5157: p_init_msg_list => true,
5158: --p_commit => FND_API.G_FALSE,
5159: x_return_status => l_return_status,

Line 5162: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5158: --p_commit => FND_API.G_FALSE,
5159: x_return_status => l_return_status,
5160: x_msg_count => l_msg_count,
5161: --x_msg_data => l_msg_data,
5162: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5163: p_eco_revision_tbl => g_public_rev_tbl,
5164: p_revised_item_tbl => g_public_rev_item_tbl,
5165: p_rev_component_tbl => g_public_rev_comp_tbl,
5166: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5273: Eng_Eco_Pub.Process_Eco (

5269: -- Call Public API
5270:
5271: stmt_num := 360;
5272: --dbms_output.put_line('No Items - Call Public API with sbcs starting hierarchy');
5273: Eng_Eco_Pub.Process_Eco (
5274: p_api_version_number => 1.0,
5275: p_init_msg_list => true,
5276: --p_commit => FND_API.G_FALSE,
5277: x_return_status => l_return_status,

Line 5280: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5276: --p_commit => FND_API.G_FALSE,
5277: x_return_status => l_return_status,
5278: x_msg_count => l_msg_count,
5279: --x_msg_data => l_msg_data,
5280: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5281: p_eco_revision_tbl => g_public_rev_tbl,
5282: p_revised_item_tbl => g_public_rev_item_tbl,
5283: p_rev_component_tbl => g_public_rev_comp_tbl,
5284: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5447: Eng_Eco_Pub.Process_Eco (

5443: --dbms_output.put_line('No ifce key - Call Public API for comp');
5444: Move_Encoin_Struct_To_Public;
5445:
5446: stmt_num := 382.5;
5447: Eng_Eco_Pub.Process_Eco (
5448: p_api_version_number => 1.0,
5449: p_init_msg_list => true,
5450: --p_commit => FND_API.G_FALSE,
5451: x_return_status => l_return_status,

Line 5454: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5450: --p_commit => FND_API.G_FALSE,
5451: x_return_status => l_return_status,
5452: x_msg_count => l_msg_count,
5453: --x_msg_data => l_msg_data,
5454: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5455: p_eco_revision_tbl => g_public_rev_tbl,
5456: p_revised_item_tbl => g_public_rev_item_tbl,
5457: p_rev_component_tbl => g_public_rev_comp_tbl,
5458: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5534: Eng_Eco_Pub.Process_Eco (

5530: -- Call Public API
5531:
5532: stmt_num := 402;
5533: --dbms_output.put_line('Ifce key exists - Call Public API for comp');
5534: Eng_Eco_Pub.Process_Eco (
5535: p_api_version_number => 1.0,
5536: p_init_msg_list => true,
5537: --p_commit => FND_API.G_FALSE,
5538: x_return_status => l_return_status,

Line 5541: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5537: --p_commit => FND_API.G_FALSE,
5538: x_return_status => l_return_status,
5539: x_msg_count => l_msg_count,
5540: --x_msg_data => l_msg_data,
5541: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5542: p_eco_revision_tbl => g_public_rev_tbl,
5543: p_revised_item_tbl => g_public_rev_item_tbl,
5544: p_rev_component_tbl => g_public_rev_comp_tbl,
5545: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5680: Eng_Eco_Pub.Process_Eco (

5676: -- Call Public API
5677:
5678: stmt_num := 434;
5679: --dbms_output.put_line('No Comps - Call Public API with desgs starting hierarchy');
5680: Eng_Eco_Pub.Process_Eco (
5681: p_api_version_number => 1.0,
5682: p_init_msg_list => true,
5683: --p_commit => FND_API.G_FALSE,
5684: x_return_status => l_return_status,

Line 5687: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5683: --p_commit => FND_API.G_FALSE,
5684: x_return_status => l_return_status,
5685: x_msg_count => l_msg_count,
5686: --x_msg_data => l_msg_data,
5687: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5688: p_eco_revision_tbl => g_public_rev_tbl,
5689: p_revised_item_tbl => g_public_rev_item_tbl,
5690: p_rev_component_tbl => g_public_rev_comp_tbl,
5691: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5793: Eng_Eco_Pub.Process_Eco (

5789: -- Call Public API
5790:
5791: stmt_num := 459;
5792: --dbms_output.put_line('No Comps - Call Public API with sbcs starting hierarchy');
5793: Eng_Eco_Pub.Process_Eco (
5794: p_api_version_number => 1.0,
5795: p_init_msg_list => true,
5796: --p_commit => FND_API.G_FALSE,
5797: x_return_status => l_return_status,

Line 5800: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5796: --p_commit => FND_API.G_FALSE,
5797: x_return_status => l_return_status,
5798: x_msg_count => l_msg_count,
5799: --x_msg_data => l_msg_data,
5800: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5801: p_eco_revision_tbl => g_public_rev_tbl,
5802: p_revised_item_tbl => g_public_rev_item_tbl,
5803: p_rev_component_tbl => g_public_rev_comp_tbl,
5804: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 5914: Eng_Eco_Pub.Process_Eco (

5910:
5911:
5912: stmt_num := 478;
5913: --dbms_output.put_line('Call Public API for Reference Designator entity');
5914: Eng_Eco_Pub.Process_Eco (
5915: p_api_version_number => 1.0,
5916: p_init_msg_list => true,
5917: --p_commit => FND_API.G_FALSE,
5918: x_return_status => l_return_status,

Line 5921: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

5917: --p_commit => FND_API.G_FALSE,
5918: x_return_status => l_return_status,
5919: x_msg_count => l_msg_count,
5920: --x_msg_data => l_msg_data,
5921: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5922: p_eco_revision_tbl => g_public_rev_tbl,
5923: p_revised_item_tbl => g_public_rev_item_tbl,
5924: p_rev_component_tbl => g_public_rev_comp_tbl,
5925: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 6043: Eng_Eco_Pub.Process_Eco (

6039: g_public_sub_comp_tbl(z).New_revised_Item_Revision := c16rec.New_revised_Item_Revision;
6040:
6041: stmt_num := 497;
6042: --dbms_output.put_line('Call Public API from Substitute Component entity');
6043: Eng_Eco_Pub.Process_Eco (
6044: p_api_version_number => 1.0,
6045: p_init_msg_list => true,
6046: --p_commit => FND_API.G_FALSE,
6047: x_return_status => l_return_status,

Line 6050: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

6046: --p_commit => FND_API.G_FALSE,
6047: x_return_status => l_return_status,
6048: x_msg_count => l_msg_count,
6049: --x_msg_data => l_msg_data,
6050: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
6051: p_eco_revision_tbl => g_public_rev_tbl,
6052: p_revised_item_tbl => g_public_rev_item_tbl,
6053: p_rev_component_tbl => g_public_rev_comp_tbl,
6054: p_ref_designator_tbl => g_public_ref_des_tbl,

Line 6269: -- l_error_tbl ENG_Eco_PUB.Error_Tbl_Type;

6265: l_msg_count NUMBER;
6266: l_msg_data VARCHAR2(2000);
6267: l_unexp_error VARCHAR2(1000);
6268: l_transaction_id NUMBER;
6269: -- l_error_tbl ENG_Eco_PUB.Error_Tbl_Type;
6270: -- l_log_msg VARCHAR2(2000);
6271: -- l_err_text VARCHAR2(2000);
6272:
6273: r NUMBER := 0;

Line 6476: Eng_Eco_Pub.Process_Eco (

6472: stmt_num := 244;
6473: Move_Encoin_Struct_To_Public;
6474:
6475: stmt_num := 245;
6476: Eng_Eco_Pub.Process_Eco (
6477: p_api_version_number => 1.0,
6478: p_init_msg_list => true,
6479: --p_commit => FND_API.G_FALSE,
6480: x_return_status => l_return_status,

Line 6483: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,

6479: --p_commit => FND_API.G_FALSE,
6480: x_return_status => l_return_status,
6481: x_msg_count => l_msg_count,
6482: --x_msg_data => l_msg_data,
6483: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
6484: p_eco_revision_tbl => g_public_rev_tbl,
6485: p_revised_item_tbl => g_public_rev_item_tbl,
6486: p_rev_component_tbl => g_public_rev_comp_tbl,
6487: p_ref_designator_tbl => g_public_ref_des_tbl,