eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_GENEALOGY_REPORT_GEN dependencies on INV_GENEALOGY_REPORT_GEN

Line 1: PACKAGE BODY inv_genealogy_report_gen AS

1: PACKAGE BODY inv_genealogy_report_gen AS
2: /* $Header: INVLTGNB.pls 120.11 2006/10/03 15:29:46 lgao noship $ */
3: --
4: -- File : INVLTGNB.pls
5: -- Content : inv_genealogy_report_gen Body

Line 5: -- Content : inv_genealogy_report_gen Body

1: PACKAGE BODY inv_genealogy_report_gen AS
2: /* $Header: INVLTGNB.pls 120.11 2006/10/03 15:29:46 lgao noship $ */
3: --
4: -- File : INVLTGNB.pls
5: -- Content : inv_genealogy_report_gen Body
6: -- Description : generate XML file for genealogy report
7: -- Notes :
8: -- Modified : 07/18/05 lgao created orginal file
9: --

Line 10: g_pkg_name CONSTANT VARCHAR2(30) := 'inv_genealogy_report_gen';

6: -- Description : generate XML file for genealogy report
7: -- Notes :
8: -- Modified : 07/18/05 lgao created orginal file
9: --
10: g_pkg_name CONSTANT VARCHAR2(30) := 'inv_genealogy_report_gen';
11: g_debug NUMBER;
12: g_inventory_item_id NUMBER;
13: g_organization_id NUMBER;
14: g_organization_desc VARCHAR2(240);

Line 67: ( p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type

63: , p_wip_entity_name IN VARCHAR2
64: , p_level IN NUMBER -- 1 query item, 2 component item
65: );
66: Procedure write_item_info
67: ( p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type
68: );
69:
70: Procedure write_lot_info
71: ( p_lot_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.lot_attributes_rec_type

Line 71: ( p_lot_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.lot_attributes_rec_type

67: ( p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type
68: );
69:
70: Procedure write_lot_info
71: ( p_lot_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.lot_attributes_rec_type
72: );
73:
74: Procedure write_serial_info
75: ( p_serial_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.serial_attributes_rec_type

Line 75: ( p_serial_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.serial_attributes_rec_type

71: ( p_lot_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.lot_attributes_rec_type
72: );
73:
74: Procedure write_serial_info
75: ( p_serial_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.serial_attributes_rec_type
76: );
77:
78: Procedure write_work_order_info
79: ( p_work_order_header_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_header_rec_type

Line 79: ( p_work_order_header_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_header_rec_type

75: ( p_serial_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.serial_attributes_rec_type
76: );
77:
78: Procedure write_work_order_info
79: ( p_work_order_header_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_header_rec_type
80: , p_work_order_dtl_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_dtl_rec_type
81: , p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type
82: );
83:

Line 80: , p_work_order_dtl_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_dtl_rec_type

76: );
77:
78: Procedure write_work_order_info
79: ( p_work_order_header_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_header_rec_type
80: , p_work_order_dtl_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_dtl_rec_type
81: , p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type
82: );
83:
84: Procedure write_material_txn_info

Line 81: , p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type

77:
78: Procedure write_work_order_info
79: ( p_work_order_header_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_header_rec_type
80: , p_work_order_dtl_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_dtl_rec_type
81: , p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type
82: );
83:
84: Procedure write_material_txn_info
85: ( p_material_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.material_txn_rec_type

Line 85: ( p_material_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.material_txn_rec_type

81: , p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type
82: );
83:
84: Procedure write_material_txn_info
85: ( p_material_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.material_txn_rec_type
86: );
87:
88: Procedure write_pending_txn_info
89: ( p_pending_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.pending_txn_rec_type

Line 89: ( p_pending_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.pending_txn_rec_type

85: ( p_material_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.material_txn_rec_type
86: );
87:
88: Procedure write_pending_txn_info
89: ( p_pending_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.pending_txn_rec_type
90: );
91:
92: Procedure write_product_info
93: ( p_product_rec IN OUT NOCOPY inv_genealogy_report_gen.product_rec_type

Line 93: ( p_product_rec IN OUT NOCOPY inv_genealogy_report_gen.product_rec_type

89: ( p_pending_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.pending_txn_rec_type
90: );
91:
92: Procedure write_product_info
93: ( p_product_rec IN OUT NOCOPY inv_genealogy_report_gen.product_rec_type
94: );
95:
96: Procedure write_component_info
97: ( p_component_rec IN OUT NOCOPY inv_genealogy_report_gen.component_rec_type

Line 97: ( p_component_rec IN OUT NOCOPY inv_genealogy_report_gen.component_rec_type

93: ( p_product_rec IN OUT NOCOPY inv_genealogy_report_gen.product_rec_type
94: );
95:
96: Procedure write_component_info
97: ( p_component_rec IN OUT NOCOPY inv_genealogy_report_gen.component_rec_type
98: );
99:
100: Procedure write_quality_collections_info
101: ( p_quality_collections_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_collections_rec_type

Line 101: ( p_quality_collections_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_collections_rec_type

97: ( p_component_rec IN OUT NOCOPY inv_genealogy_report_gen.component_rec_type
98: );
99:
100: Procedure write_quality_collections_info
101: ( p_quality_collections_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_collections_rec_type
102: );
103:
104: Procedure write_quality_samples_info
105: ( p_quality_samples_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_samples_rec_type

Line 105: ( p_quality_samples_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_samples_rec_type

101: ( p_quality_collections_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_collections_rec_type
102: );
103:
104: Procedure write_quality_samples_info
105: ( p_quality_samples_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_samples_rec_type
106: );
107:
108: Procedure write_lotbased_wip_txn_info
109: ( p_lotbased_wip_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.lotbased_wip_txn_rec_type

Line 109: ( p_lotbased_wip_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.lotbased_wip_txn_rec_type

105: ( p_quality_samples_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_samples_rec_type
106: );
107:
108: Procedure write_lotbased_wip_txn_info
109: ( p_lotbased_wip_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.lotbased_wip_txn_rec_type
110: );
111:
112: Procedure write_move_txn_info
113: ( p_move_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.move_txn_rec_type

Line 113: ( p_move_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.move_txn_rec_type

109: ( p_lotbased_wip_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.lotbased_wip_txn_rec_type
110: );
111:
112: Procedure write_move_txn_info
113: ( p_move_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.move_txn_rec_type
114: );
115:
116: Procedure write_grade_status_info
117: ( p_grade_status_rec IN OUT NOCOPY inv_genealogy_report_gen.grade_status_rec_type

Line 117: ( p_grade_status_rec IN OUT NOCOPY inv_genealogy_report_gen.grade_status_rec_type

113: ( p_move_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.move_txn_rec_type
114: );
115:
116: Procedure write_grade_status_info
117: ( p_grade_status_rec IN OUT NOCOPY inv_genealogy_report_gen.grade_status_rec_type
118: );
119:
120: procedure get_all_children
121: ( p_object_id IN NUMBER

Line 635: l_item_info_rec inv_genealogy_report_gen.item_info_rec_type;

631: l_allow_security VARCHAR2(1);
632: l_security Number;
633: x_return_status VARCHAR2(5);
634:
635: l_item_info_rec inv_genealogy_report_gen.item_info_rec_type;
636: l_lot_attributes_rec inv_genealogy_report_gen.lot_attributes_rec_type;
637: l_serial_attributes_rec inv_genealogy_report_gen.serial_attributes_rec_type;
638: l_work_order_header_rec inv_genealogy_report_gen.work_order_header_rec_type;
639: l_work_order_dtl_rec inv_genealogy_report_gen.work_order_dtl_rec_type ;

Line 636: l_lot_attributes_rec inv_genealogy_report_gen.lot_attributes_rec_type;

632: l_security Number;
633: x_return_status VARCHAR2(5);
634:
635: l_item_info_rec inv_genealogy_report_gen.item_info_rec_type;
636: l_lot_attributes_rec inv_genealogy_report_gen.lot_attributes_rec_type;
637: l_serial_attributes_rec inv_genealogy_report_gen.serial_attributes_rec_type;
638: l_work_order_header_rec inv_genealogy_report_gen.work_order_header_rec_type;
639: l_work_order_dtl_rec inv_genealogy_report_gen.work_order_dtl_rec_type ;
640: l_material_txn_rec inv_genealogy_report_gen.material_txn_rec_type ;

Line 637: l_serial_attributes_rec inv_genealogy_report_gen.serial_attributes_rec_type;

633: x_return_status VARCHAR2(5);
634:
635: l_item_info_rec inv_genealogy_report_gen.item_info_rec_type;
636: l_lot_attributes_rec inv_genealogy_report_gen.lot_attributes_rec_type;
637: l_serial_attributes_rec inv_genealogy_report_gen.serial_attributes_rec_type;
638: l_work_order_header_rec inv_genealogy_report_gen.work_order_header_rec_type;
639: l_work_order_dtl_rec inv_genealogy_report_gen.work_order_dtl_rec_type ;
640: l_material_txn_rec inv_genealogy_report_gen.material_txn_rec_type ;
641: l_pending_txn_rec inv_genealogy_report_gen.pending_txn_rec_type ;

Line 638: l_work_order_header_rec inv_genealogy_report_gen.work_order_header_rec_type;

634:
635: l_item_info_rec inv_genealogy_report_gen.item_info_rec_type;
636: l_lot_attributes_rec inv_genealogy_report_gen.lot_attributes_rec_type;
637: l_serial_attributes_rec inv_genealogy_report_gen.serial_attributes_rec_type;
638: l_work_order_header_rec inv_genealogy_report_gen.work_order_header_rec_type;
639: l_work_order_dtl_rec inv_genealogy_report_gen.work_order_dtl_rec_type ;
640: l_material_txn_rec inv_genealogy_report_gen.material_txn_rec_type ;
641: l_pending_txn_rec inv_genealogy_report_gen.pending_txn_rec_type ;
642: l_product_rec inv_genealogy_report_gen.product_rec_type ;

Line 639: l_work_order_dtl_rec inv_genealogy_report_gen.work_order_dtl_rec_type ;

635: l_item_info_rec inv_genealogy_report_gen.item_info_rec_type;
636: l_lot_attributes_rec inv_genealogy_report_gen.lot_attributes_rec_type;
637: l_serial_attributes_rec inv_genealogy_report_gen.serial_attributes_rec_type;
638: l_work_order_header_rec inv_genealogy_report_gen.work_order_header_rec_type;
639: l_work_order_dtl_rec inv_genealogy_report_gen.work_order_dtl_rec_type ;
640: l_material_txn_rec inv_genealogy_report_gen.material_txn_rec_type ;
641: l_pending_txn_rec inv_genealogy_report_gen.pending_txn_rec_type ;
642: l_product_rec inv_genealogy_report_gen.product_rec_type ;
643: l_component_rec inv_genealogy_report_gen.component_rec_type ;

Line 640: l_material_txn_rec inv_genealogy_report_gen.material_txn_rec_type ;

636: l_lot_attributes_rec inv_genealogy_report_gen.lot_attributes_rec_type;
637: l_serial_attributes_rec inv_genealogy_report_gen.serial_attributes_rec_type;
638: l_work_order_header_rec inv_genealogy_report_gen.work_order_header_rec_type;
639: l_work_order_dtl_rec inv_genealogy_report_gen.work_order_dtl_rec_type ;
640: l_material_txn_rec inv_genealogy_report_gen.material_txn_rec_type ;
641: l_pending_txn_rec inv_genealogy_report_gen.pending_txn_rec_type ;
642: l_product_rec inv_genealogy_report_gen.product_rec_type ;
643: l_component_rec inv_genealogy_report_gen.component_rec_type ;
644: l_quality_collections_rec inv_genealogy_report_gen.quality_collections_rec_type;

Line 641: l_pending_txn_rec inv_genealogy_report_gen.pending_txn_rec_type ;

637: l_serial_attributes_rec inv_genealogy_report_gen.serial_attributes_rec_type;
638: l_work_order_header_rec inv_genealogy_report_gen.work_order_header_rec_type;
639: l_work_order_dtl_rec inv_genealogy_report_gen.work_order_dtl_rec_type ;
640: l_material_txn_rec inv_genealogy_report_gen.material_txn_rec_type ;
641: l_pending_txn_rec inv_genealogy_report_gen.pending_txn_rec_type ;
642: l_product_rec inv_genealogy_report_gen.product_rec_type ;
643: l_component_rec inv_genealogy_report_gen.component_rec_type ;
644: l_quality_collections_rec inv_genealogy_report_gen.quality_collections_rec_type;
645: l_quality_samples_rec inv_genealogy_report_gen.quality_samples_rec_type;

Line 642: l_product_rec inv_genealogy_report_gen.product_rec_type ;

638: l_work_order_header_rec inv_genealogy_report_gen.work_order_header_rec_type;
639: l_work_order_dtl_rec inv_genealogy_report_gen.work_order_dtl_rec_type ;
640: l_material_txn_rec inv_genealogy_report_gen.material_txn_rec_type ;
641: l_pending_txn_rec inv_genealogy_report_gen.pending_txn_rec_type ;
642: l_product_rec inv_genealogy_report_gen.product_rec_type ;
643: l_component_rec inv_genealogy_report_gen.component_rec_type ;
644: l_quality_collections_rec inv_genealogy_report_gen.quality_collections_rec_type;
645: l_quality_samples_rec inv_genealogy_report_gen.quality_samples_rec_type;
646: l_move_txn_rec inv_genealogy_report_gen.move_txn_rec_type ;

Line 643: l_component_rec inv_genealogy_report_gen.component_rec_type ;

639: l_work_order_dtl_rec inv_genealogy_report_gen.work_order_dtl_rec_type ;
640: l_material_txn_rec inv_genealogy_report_gen.material_txn_rec_type ;
641: l_pending_txn_rec inv_genealogy_report_gen.pending_txn_rec_type ;
642: l_product_rec inv_genealogy_report_gen.product_rec_type ;
643: l_component_rec inv_genealogy_report_gen.component_rec_type ;
644: l_quality_collections_rec inv_genealogy_report_gen.quality_collections_rec_type;
645: l_quality_samples_rec inv_genealogy_report_gen.quality_samples_rec_type;
646: l_move_txn_rec inv_genealogy_report_gen.move_txn_rec_type ;
647: l_lotbased_wip_txn_rec inv_genealogy_report_gen.lotbased_wip_txn_rec_type ;

Line 644: l_quality_collections_rec inv_genealogy_report_gen.quality_collections_rec_type;

640: l_material_txn_rec inv_genealogy_report_gen.material_txn_rec_type ;
641: l_pending_txn_rec inv_genealogy_report_gen.pending_txn_rec_type ;
642: l_product_rec inv_genealogy_report_gen.product_rec_type ;
643: l_component_rec inv_genealogy_report_gen.component_rec_type ;
644: l_quality_collections_rec inv_genealogy_report_gen.quality_collections_rec_type;
645: l_quality_samples_rec inv_genealogy_report_gen.quality_samples_rec_type;
646: l_move_txn_rec inv_genealogy_report_gen.move_txn_rec_type ;
647: l_lotbased_wip_txn_rec inv_genealogy_report_gen.lotbased_wip_txn_rec_type ;
648: l_grade_status_rec inv_genealogy_report_gen.grade_status_rec_type ;

Line 645: l_quality_samples_rec inv_genealogy_report_gen.quality_samples_rec_type;

641: l_pending_txn_rec inv_genealogy_report_gen.pending_txn_rec_type ;
642: l_product_rec inv_genealogy_report_gen.product_rec_type ;
643: l_component_rec inv_genealogy_report_gen.component_rec_type ;
644: l_quality_collections_rec inv_genealogy_report_gen.quality_collections_rec_type;
645: l_quality_samples_rec inv_genealogy_report_gen.quality_samples_rec_type;
646: l_move_txn_rec inv_genealogy_report_gen.move_txn_rec_type ;
647: l_lotbased_wip_txn_rec inv_genealogy_report_gen.lotbased_wip_txn_rec_type ;
648: l_grade_status_rec inv_genealogy_report_gen.grade_status_rec_type ;
649:

Line 646: l_move_txn_rec inv_genealogy_report_gen.move_txn_rec_type ;

642: l_product_rec inv_genealogy_report_gen.product_rec_type ;
643: l_component_rec inv_genealogy_report_gen.component_rec_type ;
644: l_quality_collections_rec inv_genealogy_report_gen.quality_collections_rec_type;
645: l_quality_samples_rec inv_genealogy_report_gen.quality_samples_rec_type;
646: l_move_txn_rec inv_genealogy_report_gen.move_txn_rec_type ;
647: l_lotbased_wip_txn_rec inv_genealogy_report_gen.lotbased_wip_txn_rec_type ;
648: l_grade_status_rec inv_genealogy_report_gen.grade_status_rec_type ;
649:
650: Cursor get_wip IS

Line 647: l_lotbased_wip_txn_rec inv_genealogy_report_gen.lotbased_wip_txn_rec_type ;

643: l_component_rec inv_genealogy_report_gen.component_rec_type ;
644: l_quality_collections_rec inv_genealogy_report_gen.quality_collections_rec_type;
645: l_quality_samples_rec inv_genealogy_report_gen.quality_samples_rec_type;
646: l_move_txn_rec inv_genealogy_report_gen.move_txn_rec_type ;
647: l_lotbased_wip_txn_rec inv_genealogy_report_gen.lotbased_wip_txn_rec_type ;
648: l_grade_status_rec inv_genealogy_report_gen.grade_status_rec_type ;
649:
650: Cursor get_wip IS
651: SELECT wip_entity_name

Line 648: l_grade_status_rec inv_genealogy_report_gen.grade_status_rec_type ;

644: l_quality_collections_rec inv_genealogy_report_gen.quality_collections_rec_type;
645: l_quality_samples_rec inv_genealogy_report_gen.quality_samples_rec_type;
646: l_move_txn_rec inv_genealogy_report_gen.move_txn_rec_type ;
647: l_lotbased_wip_txn_rec inv_genealogy_report_gen.lotbased_wip_txn_rec_type ;
648: l_grade_status_rec inv_genealogy_report_gen.grade_status_rec_type ;
649:
650: Cursor get_wip IS
651: SELECT wip_entity_name
652: , entity_type

Line 945: ( p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type

941:
942: End write_genealogy_report;
943:
944: Procedure write_item_info
945: ( p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type
946: ) IS
947: cursor get_more_item_info is
948: Select shelf_life_days
949: , concatenated_segments

Line 976: ( p_lot_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.lot_attributes_rec_type

972: XML_write('retest_interval', p_item_info_rec.retest_interval);
973: End write_item_info;
974:
975: Procedure write_lot_info
976: ( p_lot_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.lot_attributes_rec_type
977: ) IS
978: l_orig_txn_id NUMBER;
979: l_txn_action_id NUMBER;
980: l_txn_type_id NUMBER;

Line 1088: ( p_serial_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.serial_attributes_rec_type

1084: write_group_end('Lot_attributes');
1085: End write_lot_info;
1086:
1087: Procedure write_serial_info
1088: ( p_serial_attributes_rec IN OUT NOCOPY inv_genealogy_report_gen.serial_attributes_rec_type
1089: ) IS
1090: l_wip_entity_id NUMBER;
1091: l_inventory_item_id NUMBER;
1092:

Line 1161: ( p_work_order_header_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_header_rec_type

1157: write_group_end('Serial_Info');
1158: End write_serial_info;
1159:
1160: Procedure write_work_order_info
1161: ( p_work_order_header_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_header_rec_type
1162: , p_work_order_dtl_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_dtl_rec_type
1163: , p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type
1164: ) IS
1165:

Line 1162: , p_work_order_dtl_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_dtl_rec_type

1158: End write_serial_info;
1159:
1160: Procedure write_work_order_info
1161: ( p_work_order_header_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_header_rec_type
1162: , p_work_order_dtl_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_dtl_rec_type
1163: , p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type
1164: ) IS
1165:
1166: l_batch_status VARCHAR2(10);

Line 1163: , p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type

1159:
1160: Procedure write_work_order_info
1161: ( p_work_order_header_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_header_rec_type
1162: , p_work_order_dtl_rec IN OUT NOCOPY inv_genealogy_report_gen.work_order_dtl_rec_type
1163: , p_item_info_rec IN OUT NOCOPY inv_genealogy_report_gen.item_info_rec_type
1164: ) IS
1165:
1166: l_batch_status VARCHAR2(10);
1167: l_job_status VARCHAR2(10);

Line 1301: ( p_material_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.material_txn_rec_type

1297:
1298: End write_work_order_info;
1299:
1300: Procedure write_material_txn_info
1301: ( p_material_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.material_txn_rec_type
1302: ) IS
1303:
1304: l_transaction_type_id NUMBER;
1305: l_locator_id NUMBER;

Line 1505: ( p_pending_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.pending_txn_rec_type

1501: Close l_rec_query;
1502: End write_material_txn_info;
1503:
1504: Procedure write_pending_txn_info
1505: ( p_pending_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.pending_txn_rec_type
1506: ) IS
1507: l_transaction_type_id NUMBER;
1508: l_locator_id NUMBER;
1509: l_txn_status_code NUMBER;

Line 1687: ( p_product_rec IN OUT NOCOPY inv_genealogy_report_gen.product_rec_type

1683:
1684: End write_pending_txn_info;
1685:
1686: Procedure write_product_info
1687: ( p_product_rec IN OUT NOCOPY inv_genealogy_report_gen.product_rec_type
1688: ) IS
1689:
1690: l_locator_id NUMBER;
1691:

Line 1771: ( p_component_rec IN OUT NOCOPY inv_genealogy_report_gen.component_rec_type

1767:
1768: End write_product_info;
1769:
1770: Procedure write_component_info
1771: ( p_component_rec IN OUT NOCOPY inv_genealogy_report_gen.component_rec_type
1772: ) IS
1773:
1774: l_locator_id NUMBER;
1775:

Line 1850: ( p_quality_collections_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_collections_rec_type

1846:
1847: End write_component_info;
1848:
1849: Procedure write_quality_collections_info
1850: ( p_quality_collections_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_collections_rec_type
1851: ) IS
1852:
1853: l_where VARCHAR2(2000);
1854: l_query VARCHAR2(5000);

Line 1937: ( p_quality_samples_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_samples_rec_type

1933:
1934: End write_quality_collections_info;
1935:
1936: Procedure write_quality_samples_info
1937: ( p_quality_samples_rec IN OUT NOCOPY inv_genealogy_report_gen.quality_samples_rec_type
1938: ) IS
1939:
1940: l_locator_id NUMBER;
1941: l_count NUMBER;

Line 2103: ( p_lotbased_wip_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.lotbased_wip_txn_rec_type

2099:
2100: End write_quality_samples_info;
2101:
2102: Procedure write_lotbased_wip_txn_info
2103: ( p_lotbased_wip_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.lotbased_wip_txn_rec_type
2104: ) IS
2105: l_user_name VARCHAR2(240);
2106: l_wip_entity_name VARCHAR2(240);
2107: l_item_no VARCHAR2(240);

Line 2170: ( p_move_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.move_txn_rec_type

2166:
2167: End write_lotbased_wip_txn_info;
2168:
2169: Procedure write_move_txn_info
2170: ( p_move_txn_rec IN OUT NOCOPY inv_genealogy_report_gen.move_txn_rec_type
2171: ) IS
2172: l_user_name VARCHAR2(240);
2173: l_wip_entity_name VARCHAR2(240);
2174: l_item_no VARCHAR2(240);

Line 2258: ( p_grade_status_rec IN OUT NOCOPY inv_genealogy_report_gen.grade_status_rec_type

2254:
2255: End write_move_txn_info;
2256:
2257: Procedure write_grade_status_info
2258: ( p_grade_status_rec IN OUT NOCOPY inv_genealogy_report_gen.grade_status_rec_type
2259: ) IS
2260:
2261: l_user_id NUMBER;
2262: cursor get_grade_status is