APPS.BOM_DEFAULT_RTG_HEADER dependencies on BOM_RTG_PUB

Line 51: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type

47:
48: END Get_routing_Sequence;
49:
50: PROCEDURE Get_Flex_Rtg_Header
51: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
52: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
53: )
54: IS
55: BEGIN

Line 52: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type

48: END Get_routing_Sequence;
49:
50: PROCEDURE Get_Flex_Rtg_Header
51: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
52: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
53: )
54: IS
55: BEGIN
56:

Line 224: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type

220: * Purpose : Attribute Defaulting will default the necessary null
221: * attribute with appropriate values.
222: **********************************************************************/
223: PROCEDURE Attribute_Defaulting
224: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
225: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
226: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
227: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
228: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 225: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

221: * attribute with appropriate values.
222: **********************************************************************/
223: PROCEDURE Attribute_Defaulting
224: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
225: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
226: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
227: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
228: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
229: , x_return_status IN OUT NOCOPY VARCHAR2

Line 226: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type

222: **********************************************************************/
223: PROCEDURE Attribute_Defaulting
224: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
225: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
226: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
227: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
228: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
229: , x_return_status IN OUT NOCOPY VARCHAR2
230: )

Line 227: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

223: PROCEDURE Attribute_Defaulting
224: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
225: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
226: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
227: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
228: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
229: , x_return_status IN OUT NOCOPY VARCHAR2
230: )
231: IS

Line 336: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type

332: * Purpose : Entity Attribute Defaulting will default the necessary
333: * entity level attribute with appropriate values.
334: **********************************************************************/
335: PROCEDURE Entity_Attribute_Defaulting
336: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
337: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
338: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
339: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
340: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 337: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

333: * entity level attribute with appropriate values.
334: **********************************************************************/
335: PROCEDURE Entity_Attribute_Defaulting
336: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
337: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
338: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
339: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
340: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
341: , x_return_status IN OUT NOCOPY VARCHAR2

Line 338: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type

334: **********************************************************************/
335: PROCEDURE Entity_Attribute_Defaulting
336: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
337: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
338: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
339: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
340: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
341: , x_return_status IN OUT NOCOPY VARCHAR2
342: )

Line 339: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

335: PROCEDURE Entity_Attribute_Defaulting
336: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
337: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
338: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
339: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
340: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
341: , x_return_status IN OUT NOCOPY VARCHAR2
342: )
343: IS

Line 524: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type

520: * value from the old record.
521: * This procedure is not called CREATE
522: ********************************************************************/
523: PROCEDURE Populate_Null_Columns
524: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
525: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
526: , p_old_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
527: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
528: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type

Line 525: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

521: * This procedure is not called CREATE
522: ********************************************************************/
523: PROCEDURE Populate_Null_Columns
524: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
525: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
526: , p_old_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
527: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
528: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
529: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

Line 526: , p_old_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type

522: ********************************************************************/
523: PROCEDURE Populate_Null_Columns
524: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
525: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
526: , p_old_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
527: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
528: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
529: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
530: )

Line 527: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

523: PROCEDURE Populate_Null_Columns
524: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
525: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
526: , p_old_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
527: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
528: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
529: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
530: )
531: IS

Line 528: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type

524: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
525: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
526: , p_old_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
527: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
528: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
529: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
530: )
531: IS
532: --bug:4285921 Cursor to get completion subinventory and locator id.

Line 529: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

525: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
526: , p_old_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
527: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
528: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
529: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
530: )
531: IS
532: --bug:4285921 Cursor to get completion subinventory and locator id.
533: CURSOR l_CommonRtg_csr (P_CommRtgSeqId NUMBER, P_OrgId NUMBER, P_Alt VARCHAR2) IS