APPS.ENG_VAL_TO_ID dependencies on ENG_ECO_PUB

Line 223: , p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

219: END Get_Object_name;
220:
221: PROCEDURE Preprocess_Key
222: ( p_object_name IN VARCHAR2
223: , p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
224: , x_pk1_name IN OUT NOCOPY VARCHAR2
225: , x_pk2_name IN OUT NOCOPY VARCHAR2
226: , x_pk3_name IN OUT NOCOPY VARCHAR2
227: , x_pk4_name IN OUT NOCOPY VARCHAR2

Line 1031: ( p_ECO_rec IN Eng_Eco_Pub.ECO_Rec_Type

1027:
1028: -- Change Order VID conversion procedure
1029: -- changed the signature to get status id :enhancement:5414834
1030: PROCEDURE Change_Order_VID
1031: ( p_ECO_rec IN Eng_Eco_Pub.ECO_Rec_Type
1032: , p_old_eco_unexp_rec IN Eng_Eco_Pub.ECO_Unexposed_Rec_Type
1033: , P_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.ECO_Unexposed_Rec_Type
1034: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1035: , x_return_status OUT NOCOPY VARCHAR2

Line 1032: , p_old_eco_unexp_rec IN Eng_Eco_Pub.ECO_Unexposed_Rec_Type

1028: -- Change Order VID conversion procedure
1029: -- changed the signature to get status id :enhancement:5414834
1030: PROCEDURE Change_Order_VID
1031: ( p_ECO_rec IN Eng_Eco_Pub.ECO_Rec_Type
1032: , p_old_eco_unexp_rec IN Eng_Eco_Pub.ECO_Unexposed_Rec_Type
1033: , P_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.ECO_Unexposed_Rec_Type
1034: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1035: , x_return_status OUT NOCOPY VARCHAR2
1036: )

Line 1033: , P_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.ECO_Unexposed_Rec_Type

1029: -- changed the signature to get status id :enhancement:5414834
1030: PROCEDURE Change_Order_VID
1031: ( p_ECO_rec IN Eng_Eco_Pub.ECO_Rec_Type
1032: , p_old_eco_unexp_rec IN Eng_Eco_Pub.ECO_Unexposed_Rec_Type
1033: , P_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.ECO_Unexposed_Rec_Type
1034: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1035: , x_return_status OUT NOCOPY VARCHAR2
1036: )
1037: IS

Line 1854: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

1850: ****************************************************************************/
1851: PROCEDURE Revised_Item_VID
1852: ( x_Return_Status OUT NOCOPY VARCHAR2
1853: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1854: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1855: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1856: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1857: )
1858: IS

Line 1855: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

1851: PROCEDURE Revised_Item_VID
1852: ( x_Return_Status OUT NOCOPY VARCHAR2
1853: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1854: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1855: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1856: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1857: )
1858: IS
1859: l_return_value NUMBER;

Line 1856: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

1852: ( x_Return_Status OUT NOCOPY VARCHAR2
1853: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1854: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1855: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1856: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1857: )
1858: IS
1859: l_return_value NUMBER;
1860: l_Return_Status VARCHAR2(1);

Line 1863: l_Rev_Item_Unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

1859: l_return_value NUMBER;
1860: l_Return_Status VARCHAR2(1);
1861: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1862: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1863: l_Rev_Item_Unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
1864: l_Err_Text VARCHAR2(2000);
1865: l_bill_seq_id NUMBER;
1866: l_eco_type VARCHAR2(3);
1867: l_from_revision VARCHAR2(3) := NULL;

Line 2318: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type

2314:
2315: PROCEDURE ECO_Header_VID
2316: ( x_Return_Status OUT NOCOPY VARCHAR2
2317: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2318: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
2319: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2320: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2321: )
2322: IS

Line 2319: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type

2315: PROCEDURE ECO_Header_VID
2316: ( x_Return_Status OUT NOCOPY VARCHAR2
2317: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2318: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
2319: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2320: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2321: )
2322: IS
2323: l_err_text VARCHAR2(2000) := NULL;

Line 2320: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type

2316: ( x_Return_Status OUT NOCOPY VARCHAR2
2317: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2318: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
2319: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2320: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2321: )
2322: IS
2323: l_err_text VARCHAR2(2000) := NULL;
2324: l_return_value NUMBER;

Line 2328: l_ECO_Unexp_Rec Eng_Eco_Pub.Eco_Unexposed_Rec_Type;

2324: l_return_value NUMBER;
2325: l_Return_Status VARCHAR2(1);
2326: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2327: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2328: l_ECO_Unexp_Rec Eng_Eco_Pub.Eco_Unexposed_Rec_Type;
2329:
2330:
2331: l_change_mgmt_type_code VARCHAR2(30) ;
2332: l_source_type_code VARCHAR2(30) ;

Line 3014: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type

3010: * the eco header columns that form the unique key for this
3011: * entity.
3012: ******************************************************************************/
3013: PROCEDURE ECO_Header_UUI_To_UI
3014: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
3015: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3016: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3017: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3018: , x_Return_Status OUT NOCOPY VARCHAR2

Line 3015: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type

3011: * entity.
3012: ******************************************************************************/
3013: PROCEDURE ECO_Header_UUI_To_UI
3014: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
3015: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3016: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3017: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3018: , x_Return_Status OUT NOCOPY VARCHAR2
3019: )

Line 3016: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type

3012: ******************************************************************************/
3013: PROCEDURE ECO_Header_UUI_To_UI
3014: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
3015: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3016: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3017: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3018: , x_Return_Status OUT NOCOPY VARCHAR2
3019: )
3020: IS

Line 3046: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type

3042: * the ECO revision columns that form the unique key for this
3043: * entity.
3044: ******************************************************************************/
3045: PROCEDURE ECO_Revision_UUI_To_UI
3046: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
3047: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3048: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3049: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3050: , x_Return_Status OUT NOCOPY VARCHAR2

Line 3047: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type

3043: * entity.
3044: ******************************************************************************/
3045: PROCEDURE ECO_Revision_UUI_To_UI
3046: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
3047: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3048: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3049: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3050: , x_Return_Status OUT NOCOPY VARCHAR2
3051: )

Line 3048: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type

3044: ******************************************************************************/
3045: PROCEDURE ECO_Revision_UUI_To_UI
3046: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
3047: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3048: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3049: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3050: , x_Return_Status OUT NOCOPY VARCHAR2
3051: )
3052: IS

Line 3091: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

3087: * the revised item columns that form the unique key for this
3088: * entity.
3089: ******************************************************************************/
3090: PROCEDURE Revised_Item_UUI_To_UI
3091: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3092: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3093: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3094: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3095: , x_Return_Status OUT NOCOPY VARCHAR2

Line 3092: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

3088: * entity.
3089: ******************************************************************************/
3090: PROCEDURE Revised_Item_UUI_To_UI
3091: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3092: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3093: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3094: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3095: , x_Return_Status OUT NOCOPY VARCHAR2
3096: )

Line 3093: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

3089: ******************************************************************************/
3090: PROCEDURE Revised_Item_UUI_To_UI
3091: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3092: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3093: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3094: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3095: , x_Return_Status OUT NOCOPY VARCHAR2
3096: )
3097: IS

Line 3099: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

3095: , x_Return_Status OUT NOCOPY VARCHAR2
3096: )
3097: IS
3098: l_err_text VARCHAR2(2000);
3099: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
3100: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3101: l_return_status VARCHAR2(1);
3102: l_dummy VARCHAR2(30);
3103: BEGIN

Line 3960: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

3956:
3957: END RtgAndRevitem_UUI_To_UI ;
3958:
3959: PROCEDURE Change_Line_UUI_To_UI
3960: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
3961: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3962: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3963: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3964: , x_Return_Status OUT NOCOPY VARCHAR2

Line 3961: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

3957: END RtgAndRevitem_UUI_To_UI ;
3958:
3959: PROCEDURE Change_Line_UUI_To_UI
3960: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
3961: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3962: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3963: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3964: , x_Return_Status OUT NOCOPY VARCHAR2
3965: )

Line 3962: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

3958:
3959: PROCEDURE Change_Line_UUI_To_UI
3960: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
3961: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3962: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3963: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3964: , x_Return_Status OUT NOCOPY VARCHAR2
3965: )
3966: IS

Line 3969: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;

3965: )
3966: IS
3967:
3968: l_err_text VARCHAR2(2000);
3969: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
3970: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3971: l_return_status VARCHAR2(1);
3972: BEGIN
3973:

Line 4024: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

4020: END Change_Line_UUI_To_UI ;
4021:
4022:
4023: PROCEDURE Change_Line_VID
4024: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
4025: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4026: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4027: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4028: , x_Return_Status OUT NOCOPY VARCHAR2

Line 4025: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

4021:
4022:
4023: PROCEDURE Change_Line_VID
4024: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
4025: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4026: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4027: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4028: , x_Return_Status OUT NOCOPY VARCHAR2
4029: )

Line 4026: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

4022:
4023: PROCEDURE Change_Line_VID
4024: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
4025: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4026: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4027: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4028: , x_Return_Status OUT NOCOPY VARCHAR2
4029: )
4030: IS

Line 4038: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;

4034: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4035: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4036: l_change_mgmt_type_code VARCHAR2(30);
4037: l_hdr_change_mgmt_type_code VARCHAR2(30);
4038: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
4039: l_dynamic_sql VARCHAR2(4000);
4040: l_dynamic_cursor INTEGER;
4041: l_dummy INTEGER;
4042: