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 1030: ( p_ECO_rec IN Eng_Eco_Pub.ECO_Rec_Type

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

Line 1031: , p_old_eco_unexp_rec IN Eng_Eco_Pub.ECO_Unexposed_Rec_Type

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

Line 1032: , P_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.ECO_Unexposed_Rec_Type

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

Line 1848: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

1844: ****************************************************************************/
1845: PROCEDURE Revised_Item_VID
1846: ( x_Return_Status OUT NOCOPY VARCHAR2
1847: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1848: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1849: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1850: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1851: )
1852: IS

Line 1849: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

1845: PROCEDURE Revised_Item_VID
1846: ( x_Return_Status OUT NOCOPY VARCHAR2
1847: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1848: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1849: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1850: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1851: )
1852: IS
1853: l_return_value NUMBER;

Line 1850: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

1846: ( x_Return_Status OUT NOCOPY VARCHAR2
1847: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1848: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1849: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1850: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1851: )
1852: IS
1853: l_return_value NUMBER;
1854: l_Return_Status VARCHAR2(1);

Line 1857: l_Rev_Item_Unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

1853: l_return_value NUMBER;
1854: l_Return_Status VARCHAR2(1);
1855: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1856: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1857: l_Rev_Item_Unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
1858: l_Err_Text VARCHAR2(2000);
1859: l_bill_seq_id NUMBER;
1860: l_eco_type VARCHAR2(3);
1861: l_from_revision VARCHAR2(3) := NULL;

Line 2312: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type

2308:
2309: PROCEDURE ECO_Header_VID
2310: ( x_Return_Status OUT NOCOPY VARCHAR2
2311: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2312: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
2313: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2314: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2315: )
2316: IS

Line 2313: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type

2309: PROCEDURE ECO_Header_VID
2310: ( x_Return_Status OUT NOCOPY VARCHAR2
2311: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2312: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
2313: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2314: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2315: )
2316: IS
2317: l_err_text VARCHAR2(2000) := NULL;

Line 2314: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type

2310: ( x_Return_Status OUT NOCOPY VARCHAR2
2311: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2312: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
2313: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2314: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2315: )
2316: IS
2317: l_err_text VARCHAR2(2000) := NULL;
2318: l_return_value NUMBER;

Line 2322: l_ECO_Unexp_Rec Eng_Eco_Pub.Eco_Unexposed_Rec_Type;

2318: l_return_value NUMBER;
2319: l_Return_Status VARCHAR2(1);
2320: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2321: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2322: l_ECO_Unexp_Rec Eng_Eco_Pub.Eco_Unexposed_Rec_Type;
2323:
2324:
2325: l_change_mgmt_type_code VARCHAR2(30) ;
2326: l_source_type_code VARCHAR2(30) ;

Line 3008: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type

3004: * the eco header columns that form the unique key for this
3005: * entity.
3006: ******************************************************************************/
3007: PROCEDURE ECO_Header_UUI_To_UI
3008: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
3009: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3010: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3011: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3012: , x_Return_Status OUT NOCOPY VARCHAR2

Line 3009: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type

3005: * entity.
3006: ******************************************************************************/
3007: PROCEDURE ECO_Header_UUI_To_UI
3008: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
3009: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3010: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3011: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3012: , x_Return_Status OUT NOCOPY VARCHAR2
3013: )

Line 3010: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type

3006: ******************************************************************************/
3007: PROCEDURE ECO_Header_UUI_To_UI
3008: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
3009: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3010: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3011: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3012: , x_Return_Status OUT NOCOPY VARCHAR2
3013: )
3014: IS

Line 3040: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type

3036: * the ECO revision columns that form the unique key for this
3037: * entity.
3038: ******************************************************************************/
3039: PROCEDURE ECO_Revision_UUI_To_UI
3040: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
3041: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3042: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3043: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3044: , x_Return_Status OUT NOCOPY VARCHAR2

Line 3041: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type

3037: * entity.
3038: ******************************************************************************/
3039: PROCEDURE ECO_Revision_UUI_To_UI
3040: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
3041: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3042: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3043: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3044: , x_Return_Status OUT NOCOPY VARCHAR2
3045: )

Line 3042: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type

3038: ******************************************************************************/
3039: PROCEDURE ECO_Revision_UUI_To_UI
3040: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
3041: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3042: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3043: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3044: , x_Return_Status OUT NOCOPY VARCHAR2
3045: )
3046: IS

Line 3085: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

3081: * the revised item columns that form the unique key for this
3082: * entity.
3083: ******************************************************************************/
3084: PROCEDURE Revised_Item_UUI_To_UI
3085: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3086: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3087: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3088: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3089: , x_Return_Status OUT NOCOPY VARCHAR2

Line 3086: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

3082: * entity.
3083: ******************************************************************************/
3084: PROCEDURE Revised_Item_UUI_To_UI
3085: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3086: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3087: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3088: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3089: , x_Return_Status OUT NOCOPY VARCHAR2
3090: )

Line 3087: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

3083: ******************************************************************************/
3084: PROCEDURE Revised_Item_UUI_To_UI
3085: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3086: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3087: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3088: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3089: , x_Return_Status OUT NOCOPY VARCHAR2
3090: )
3091: IS

Line 3093: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

3089: , x_Return_Status OUT NOCOPY VARCHAR2
3090: )
3091: IS
3092: l_err_text VARCHAR2(2000);
3093: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
3094: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3095: l_return_status VARCHAR2(1);
3096: l_dummy VARCHAR2(30);
3097: BEGIN

Line 3949: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

3945:
3946: END RtgAndRevitem_UUI_To_UI ;
3947:
3948: PROCEDURE Change_Line_UUI_To_UI
3949: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
3950: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3951: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3952: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3953: , x_Return_Status OUT NOCOPY VARCHAR2

Line 3950: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

3946: END RtgAndRevitem_UUI_To_UI ;
3947:
3948: PROCEDURE Change_Line_UUI_To_UI
3949: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
3950: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3951: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3952: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3953: , x_Return_Status OUT NOCOPY VARCHAR2
3954: )

Line 3951: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

3947:
3948: PROCEDURE Change_Line_UUI_To_UI
3949: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
3950: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3951: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3952: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3953: , x_Return_Status OUT NOCOPY VARCHAR2
3954: )
3955: IS

Line 3958: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;

3954: )
3955: IS
3956:
3957: l_err_text VARCHAR2(2000);
3958: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
3959: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3960: l_return_status VARCHAR2(1);
3961: BEGIN
3962:

Line 4013: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

4009: END Change_Line_UUI_To_UI ;
4010:
4011:
4012: PROCEDURE Change_Line_VID
4013: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
4014: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4015: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4016: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4017: , x_Return_Status OUT NOCOPY VARCHAR2

Line 4014: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

4010:
4011:
4012: PROCEDURE Change_Line_VID
4013: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
4014: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4015: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4016: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4017: , x_Return_Status OUT NOCOPY VARCHAR2
4018: )

Line 4015: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

4011:
4012: PROCEDURE Change_Line_VID
4013: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
4014: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4015: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4016: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4017: , x_Return_Status OUT NOCOPY VARCHAR2
4018: )
4019: IS

Line 4027: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;

4023: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4024: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4025: l_change_mgmt_type_code VARCHAR2(30);
4026: l_hdr_change_mgmt_type_code VARCHAR2(30);
4027: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
4028: l_dynamic_sql VARCHAR2(4000);
4029: l_dynamic_cursor INTEGER;
4030: l_dummy INTEGER;
4031: