DBA Data[Home] [Help]

APPS.BOM_OP_SEQ_UTIL dependencies on BOM_RTG_PUB

Line 47: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type

43: , p_effectivity_date IN DATE
44: , p_routing_sequence_id IN NUMBER
45: , p_operation_type IN NUMBER
46: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
47: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
48: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
49: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
50: , x_return_status IN OUT NOCOPY VARCHAR2
51: )

Line 48: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

44: , p_routing_sequence_id IN NUMBER
45: , p_operation_type IN NUMBER
46: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
47: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
48: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
49: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
50: , x_return_status IN OUT NOCOPY VARCHAR2
51: )
52:

Line 57: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

53:
54: IS
55:
56: /* Define Variable */
57: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
58: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
59: l_err_text VARCHAR2(2000);
60:
61: BEGIN

Line 58: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;

54: IS
55:
56: /* Define Variable */
57: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
58: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
59: l_err_text VARCHAR2(2000);
60:
61: BEGIN
62:

Line 78: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp

74: , x_return_status => x_return_status
75: ) ;
76:
77: -- Convert the ECO record to Routing Record
78: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp
79: ( p_com_operation_rec => l_com_operation_rec
80: , p_com_op_unexp_rec => l_com_op_unexp_rec
81: , x_rtg_operation_rec => x_operation_rec
82: , x_rtg_op_unexp_rec => x_op_unexp_rec

Line 106: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type

102: , p_effectivity_date IN DATE
103: , p_routing_sequence_id IN NUMBER
104: , p_operation_type IN NUMBER
105: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
106: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
107: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
108: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
109: , x_return_status IN OUT NOCOPY VARCHAR2
110: )

Line 107: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

103: , p_routing_sequence_id IN NUMBER
104: , p_operation_type IN NUMBER
105: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
106: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
107: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
108: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
109: , x_return_status IN OUT NOCOPY VARCHAR2
110: )
111:

Line 116: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

112:
113: IS
114:
115: /* Define Variable */
116: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
117: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
118: l_err_text VARCHAR2(2000);
119:
120: BEGIN

Line 117: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;

113: IS
114:
115: /* Define Variable */
116: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
117: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
118: l_err_text VARCHAR2(2000);
119:
120: BEGIN
121:

Line 137: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp

133: , x_return_status => x_return_status
134: );
135:
136: -- Convert the Common record to Revised Operation record
137: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp
138: ( p_com_operation_rec => l_com_operation_rec
139: , p_com_op_unexp_rec => l_com_op_unexp_rec
140: , x_rev_operation_rec => x_rev_operation_rec
141: , x_rev_op_unexp_rec => x_rev_op_unexp_rec

Line 169: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

165: , p_effectivity_date IN DATE
166: , p_routing_sequence_id IN NUMBER
167: , p_operation_type IN NUMBER
168: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
169: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
170: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
171: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
172: , x_return_status IN OUT NOCOPY VARCHAR2
173: )

Line 170: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

166: , p_routing_sequence_id IN NUMBER
167: , p_operation_type IN NUMBER
168: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
169: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
170: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
171: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
172: , x_return_status IN OUT NOCOPY VARCHAR2
173: )
174: IS

Line 177: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

173: )
174: IS
175:
176: /* Define Variable */
177: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
178: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
179: l_bo_id VARCHAR2(3) ;
180: l_err_text VARCHAR2(2000);
181:

Line 178: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;

174: IS
175:
176: /* Define Variable */
177: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
178: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
179: l_bo_id VARCHAR2(3) ;
180: l_err_text VARCHAR2(2000);
181:
182:

Line 365: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

361: * user has to perform any insert/update/deletes to the
362: * Operation Sequences table.
363: *********************************************************************/
364: PROCEDURE Perform_Writes
365: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
366: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
367: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
368: , x_return_status IN OUT NOCOPY VARCHAR2
369: )

Line 366: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

362: * Operation Sequences table.
363: *********************************************************************/
364: PROCEDURE Perform_Writes
365: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
366: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
367: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
368: , x_return_status IN OUT NOCOPY VARCHAR2
369: )
370: IS

Line 371: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

367: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
368: , x_return_status IN OUT NOCOPY VARCHAR2
369: )
370: IS
371: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
372: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
373:
374: BEGIN
375: -- Convert Routing Operation to Common Operation

Line 372: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

368: , x_return_status IN OUT NOCOPY VARCHAR2
369: )
370: IS
371: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
372: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
373:
374: BEGIN
375: -- Convert Routing Operation to Common Operation
376: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

Line 376: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

372: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
373:
374: BEGIN
375: -- Convert Routing Operation to Common Operation
376: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
377: ( p_rtg_operation_rec => p_operation_rec
378: , p_rtg_op_unexp_rec => p_op_unexp_rec
379: , x_com_operation_rec => l_com_operation_rec
380: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 388: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC

384:
385: Bom_Op_Seq_UTIL.Perform_Writes
386: ( p_com_operation_rec => l_com_operation_rec
387: , p_com_op_unexp_rec => l_com_op_unexp_rec
388: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC
389: , x_return_status => x_return_status
390: , x_mesg_token_tbl => x_mesg_token_tbl
391: ) ;
392:

Line 410: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

406: * user has to perform any insert/update/deletes to the
407: * Operation Sequences table.
408: *********************************************************************/
409: PROCEDURE Perform_Writes
410: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
411: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
412: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
413: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
414: , x_return_status IN OUT NOCOPY VARCHAR2

Line 411: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

407: * Operation Sequences table.
408: *********************************************************************/
409: PROCEDURE Perform_Writes
410: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
411: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
412: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
413: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
414: , x_return_status IN OUT NOCOPY VARCHAR2
415: )

Line 412: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type

408: *********************************************************************/
409: PROCEDURE Perform_Writes
410: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
411: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
412: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
413: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
414: , x_return_status IN OUT NOCOPY VARCHAR2
415: )
416: IS

Line 417: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

413: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
414: , x_return_status IN OUT NOCOPY VARCHAR2
415: )
416: IS
417: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
418: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
419:
420: BEGIN
421: -- Convert Revised Operation to Common Operation

Line 418: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

414: , x_return_status IN OUT NOCOPY VARCHAR2
415: )
416: IS
417: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
418: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
419:
420: BEGIN
421: -- Convert Revised Operation to Common Operation
422: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

Line 422: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

418: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
419:
420: BEGIN
421: -- Convert Revised Operation to Common Operation
422: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
423: ( p_rev_operation_rec => p_rev_operation_rec
424: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
425: , x_com_operation_rec => l_com_operation_rec
426: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 434: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC

430: -- Call Perform Writes Procedure
431: Bom_Op_Seq_UTIL.Perform_Writes
432: ( p_com_operation_rec => l_com_operation_rec
433: , p_com_op_unexp_rec => l_com_op_unexp_rec
434: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC
435: , x_return_status => x_return_status
436: , x_mesg_token_tbl => x_mesg_token_tbl
437: ) ;
438:

Line 453: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

449: * Operation Sequences table.
450: *********************************************************************/
451:
452: PROCEDURE Perform_Writes
453: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
454: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
455: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
456: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
457: , x_return_status IN OUT NOCOPY VARCHAR2

Line 454: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

450: *********************************************************************/
451:
452: PROCEDURE Perform_Writes
453: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
454: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
455: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
456: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
457: , x_return_status IN OUT NOCOPY VARCHAR2
458: )

Line 455: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type

451:
452: PROCEDURE Perform_Writes
453: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
454: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
455: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
456: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
457: , x_return_status IN OUT NOCOPY VARCHAR2
458: )
459:

Line 462: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

458: )
459:
460: IS
461:
462: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
463: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
464: l_routing_sequence_id NUMBER ; -- Routing Sequence Id
465: l_routing_type NUMBER ; -- Routing Type
466:

Line 463: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

459:
460: IS
461:
462: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
463: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
464: l_routing_sequence_id NUMBER ; -- Routing Sequence Id
465: l_routing_type NUMBER ; -- Routing Type
466:
467: -- Error Handlig Variables

Line 1424: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

1420: * table; BOM_OPERATION_SEQUENCES.
1421: *
1422: *****************************************************************************/
1423: PROCEDURE Insert_Row
1424: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1425: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1426: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1427: , x_return_status IN OUT NOCOPY VARCHAR2
1428: )

Line 1425: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1421: *
1422: *****************************************************************************/
1423: PROCEDURE Insert_Row
1424: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1425: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1426: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1427: , x_return_status IN OUT NOCOPY VARCHAR2
1428: )
1429: IS

Line 1720: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

1716: * the user given values. Any errors will be returned by filling
1717: * the Mesg_Token_Tbl and setting the return_status.
1718: ****************************************************************************/
1719: PROCEDURE Update_Row
1720: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1721: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1722: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1723: , x_return_status IN OUT NOCOPY VARCHAR2
1724: )

Line 1721: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1717: * the Mesg_Token_Tbl and setting the return_status.
1718: ****************************************************************************/
1719: PROCEDURE Update_Row
1720: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1721: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1722: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1723: , x_return_status IN OUT NOCOPY VARCHAR2
1724: )
1725: IS

Line 1889: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

1885: * For RTG BO, Procedure will perfrom an Delete from the
1886: * BOM_Operation_Sequences by creating a delete Group.
1887: *********************************************************************/
1888: PROCEDURE Delete_Row
1889: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1890: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1891: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1892: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1893: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1890: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1886: * BOM_Operation_Sequences by creating a delete Group.
1887: *********************************************************************/
1888: PROCEDURE Delete_Row
1889: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1890: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1891: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1892: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1893: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1894: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1891: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

1887: *********************************************************************/
1888: PROCEDURE Delete_Row
1889: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1890: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1891: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1892: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1893: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1894: , x_return_status IN OUT NOCOPY VARCHAR2
1895: )

Line 1892: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1888: PROCEDURE Delete_Row
1889: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1890: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1891: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1892: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1893: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1894: , x_return_status IN OUT NOCOPY VARCHAR2
1895: )
1896: IS

Line 1898: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1894: , x_return_status IN OUT NOCOPY VARCHAR2
1895: )
1896: IS
1897:
1898: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1899: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1900: l_dg_sequence_id NUMBER;
1901:
1902:

Line 1899: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1895: )
1896: IS
1897:
1898: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1899: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1900: l_dg_sequence_id NUMBER;
1901:
1902:
1903: -- Error Handlig Variables