11: -- davidng 10/08/03
12: -- and matching_basis record type line_rec_type
13:
14: TYPE Header_Rec_Type IS RECORD
15: (requisition_header_id po_requisition_headers_all.requisition_header_id%TYPE
16: ,preparer_id po_requisition_headers_all.preparer_id%TYPE
17: ,last_update_date po_requisition_headers_all. last_update_date%TYPE
18: ,last_updated_by po_requisition_headers_all.last_updated_by%TYPE
19: ,segment1 po_requisition_headers_all.segment1%TYPE
12: -- and matching_basis record type line_rec_type
13:
14: TYPE Header_Rec_Type IS RECORD
15: (requisition_header_id po_requisition_headers_all.requisition_header_id%TYPE
16: ,preparer_id po_requisition_headers_all.preparer_id%TYPE
17: ,last_update_date po_requisition_headers_all. last_update_date%TYPE
18: ,last_updated_by po_requisition_headers_all.last_updated_by%TYPE
19: ,segment1 po_requisition_headers_all.segment1%TYPE
20: ,summary_flag po_requisition_headers_all.summary_flag%TYPE
13:
14: TYPE Header_Rec_Type IS RECORD
15: (requisition_header_id po_requisition_headers_all.requisition_header_id%TYPE
16: ,preparer_id po_requisition_headers_all.preparer_id%TYPE
17: ,last_update_date po_requisition_headers_all. last_update_date%TYPE
18: ,last_updated_by po_requisition_headers_all.last_updated_by%TYPE
19: ,segment1 po_requisition_headers_all.segment1%TYPE
20: ,summary_flag po_requisition_headers_all.summary_flag%TYPE
21: ,enabled_flag po_requisition_headers_all.enabled_flag%TYPE
14: TYPE Header_Rec_Type IS RECORD
15: (requisition_header_id po_requisition_headers_all.requisition_header_id%TYPE
16: ,preparer_id po_requisition_headers_all.preparer_id%TYPE
17: ,last_update_date po_requisition_headers_all. last_update_date%TYPE
18: ,last_updated_by po_requisition_headers_all.last_updated_by%TYPE
19: ,segment1 po_requisition_headers_all.segment1%TYPE
20: ,summary_flag po_requisition_headers_all.summary_flag%TYPE
21: ,enabled_flag po_requisition_headers_all.enabled_flag%TYPE
22: ,segment2 po_requisition_headers_all.segment2%TYPE
15: (requisition_header_id po_requisition_headers_all.requisition_header_id%TYPE
16: ,preparer_id po_requisition_headers_all.preparer_id%TYPE
17: ,last_update_date po_requisition_headers_all. last_update_date%TYPE
18: ,last_updated_by po_requisition_headers_all.last_updated_by%TYPE
19: ,segment1 po_requisition_headers_all.segment1%TYPE
20: ,summary_flag po_requisition_headers_all.summary_flag%TYPE
21: ,enabled_flag po_requisition_headers_all.enabled_flag%TYPE
22: ,segment2 po_requisition_headers_all.segment2%TYPE
23: ,segment3 po_requisition_headers_all.segment3%TYPE
16: ,preparer_id po_requisition_headers_all.preparer_id%TYPE
17: ,last_update_date po_requisition_headers_all. last_update_date%TYPE
18: ,last_updated_by po_requisition_headers_all.last_updated_by%TYPE
19: ,segment1 po_requisition_headers_all.segment1%TYPE
20: ,summary_flag po_requisition_headers_all.summary_flag%TYPE
21: ,enabled_flag po_requisition_headers_all.enabled_flag%TYPE
22: ,segment2 po_requisition_headers_all.segment2%TYPE
23: ,segment3 po_requisition_headers_all.segment3%TYPE
24: ,segment4 po_requisition_headers_all.segment4%TYPE
17: ,last_update_date po_requisition_headers_all. last_update_date%TYPE
18: ,last_updated_by po_requisition_headers_all.last_updated_by%TYPE
19: ,segment1 po_requisition_headers_all.segment1%TYPE
20: ,summary_flag po_requisition_headers_all.summary_flag%TYPE
21: ,enabled_flag po_requisition_headers_all.enabled_flag%TYPE
22: ,segment2 po_requisition_headers_all.segment2%TYPE
23: ,segment3 po_requisition_headers_all.segment3%TYPE
24: ,segment4 po_requisition_headers_all.segment4%TYPE
25: ,segment5 po_requisition_headers_all.segment5%TYPE
18: ,last_updated_by po_requisition_headers_all.last_updated_by%TYPE
19: ,segment1 po_requisition_headers_all.segment1%TYPE
20: ,summary_flag po_requisition_headers_all.summary_flag%TYPE
21: ,enabled_flag po_requisition_headers_all.enabled_flag%TYPE
22: ,segment2 po_requisition_headers_all.segment2%TYPE
23: ,segment3 po_requisition_headers_all.segment3%TYPE
24: ,segment4 po_requisition_headers_all.segment4%TYPE
25: ,segment5 po_requisition_headers_all.segment5%TYPE
26: ,start_date_active po_requisition_headers_all.start_date_active%TYPE
19: ,segment1 po_requisition_headers_all.segment1%TYPE
20: ,summary_flag po_requisition_headers_all.summary_flag%TYPE
21: ,enabled_flag po_requisition_headers_all.enabled_flag%TYPE
22: ,segment2 po_requisition_headers_all.segment2%TYPE
23: ,segment3 po_requisition_headers_all.segment3%TYPE
24: ,segment4 po_requisition_headers_all.segment4%TYPE
25: ,segment5 po_requisition_headers_all.segment5%TYPE
26: ,start_date_active po_requisition_headers_all.start_date_active%TYPE
27: ,end_date_active po_requisition_headers_all.end_date_active%TYPE
20: ,summary_flag po_requisition_headers_all.summary_flag%TYPE
21: ,enabled_flag po_requisition_headers_all.enabled_flag%TYPE
22: ,segment2 po_requisition_headers_all.segment2%TYPE
23: ,segment3 po_requisition_headers_all.segment3%TYPE
24: ,segment4 po_requisition_headers_all.segment4%TYPE
25: ,segment5 po_requisition_headers_all.segment5%TYPE
26: ,start_date_active po_requisition_headers_all.start_date_active%TYPE
27: ,end_date_active po_requisition_headers_all.end_date_active%TYPE
28: ,last_update_login po_requisition_headers_all.last_update_login%TYPE
21: ,enabled_flag po_requisition_headers_all.enabled_flag%TYPE
22: ,segment2 po_requisition_headers_all.segment2%TYPE
23: ,segment3 po_requisition_headers_all.segment3%TYPE
24: ,segment4 po_requisition_headers_all.segment4%TYPE
25: ,segment5 po_requisition_headers_all.segment5%TYPE
26: ,start_date_active po_requisition_headers_all.start_date_active%TYPE
27: ,end_date_active po_requisition_headers_all.end_date_active%TYPE
28: ,last_update_login po_requisition_headers_all.last_update_login%TYPE
29: ,creation_date po_requisition_headers_all.creation_date%TYPE
22: ,segment2 po_requisition_headers_all.segment2%TYPE
23: ,segment3 po_requisition_headers_all.segment3%TYPE
24: ,segment4 po_requisition_headers_all.segment4%TYPE
25: ,segment5 po_requisition_headers_all.segment5%TYPE
26: ,start_date_active po_requisition_headers_all.start_date_active%TYPE
27: ,end_date_active po_requisition_headers_all.end_date_active%TYPE
28: ,last_update_login po_requisition_headers_all.last_update_login%TYPE
29: ,creation_date po_requisition_headers_all.creation_date%TYPE
30: ,created_by po_requisition_headers_all.created_by%TYPE
23: ,segment3 po_requisition_headers_all.segment3%TYPE
24: ,segment4 po_requisition_headers_all.segment4%TYPE
25: ,segment5 po_requisition_headers_all.segment5%TYPE
26: ,start_date_active po_requisition_headers_all.start_date_active%TYPE
27: ,end_date_active po_requisition_headers_all.end_date_active%TYPE
28: ,last_update_login po_requisition_headers_all.last_update_login%TYPE
29: ,creation_date po_requisition_headers_all.creation_date%TYPE
30: ,created_by po_requisition_headers_all.created_by%TYPE
31: ,description po_requisition_headers_all.description%TYPE
24: ,segment4 po_requisition_headers_all.segment4%TYPE
25: ,segment5 po_requisition_headers_all.segment5%TYPE
26: ,start_date_active po_requisition_headers_all.start_date_active%TYPE
27: ,end_date_active po_requisition_headers_all.end_date_active%TYPE
28: ,last_update_login po_requisition_headers_all.last_update_login%TYPE
29: ,creation_date po_requisition_headers_all.creation_date%TYPE
30: ,created_by po_requisition_headers_all.created_by%TYPE
31: ,description po_requisition_headers_all.description%TYPE
32: ,authorization_status po_requisition_headers_all.authorization_status%TYPE
25: ,segment5 po_requisition_headers_all.segment5%TYPE
26: ,start_date_active po_requisition_headers_all.start_date_active%TYPE
27: ,end_date_active po_requisition_headers_all.end_date_active%TYPE
28: ,last_update_login po_requisition_headers_all.last_update_login%TYPE
29: ,creation_date po_requisition_headers_all.creation_date%TYPE
30: ,created_by po_requisition_headers_all.created_by%TYPE
31: ,description po_requisition_headers_all.description%TYPE
32: ,authorization_status po_requisition_headers_all.authorization_status%TYPE
33: ,note_to_authorizer po_requisition_headers_all.note_to_authorizer%TYPE
26: ,start_date_active po_requisition_headers_all.start_date_active%TYPE
27: ,end_date_active po_requisition_headers_all.end_date_active%TYPE
28: ,last_update_login po_requisition_headers_all.last_update_login%TYPE
29: ,creation_date po_requisition_headers_all.creation_date%TYPE
30: ,created_by po_requisition_headers_all.created_by%TYPE
31: ,description po_requisition_headers_all.description%TYPE
32: ,authorization_status po_requisition_headers_all.authorization_status%TYPE
33: ,note_to_authorizer po_requisition_headers_all.note_to_authorizer%TYPE
34: ,type_lookup_code po_requisition_headers_all.type_lookup_code%TYPE
27: ,end_date_active po_requisition_headers_all.end_date_active%TYPE
28: ,last_update_login po_requisition_headers_all.last_update_login%TYPE
29: ,creation_date po_requisition_headers_all.creation_date%TYPE
30: ,created_by po_requisition_headers_all.created_by%TYPE
31: ,description po_requisition_headers_all.description%TYPE
32: ,authorization_status po_requisition_headers_all.authorization_status%TYPE
33: ,note_to_authorizer po_requisition_headers_all.note_to_authorizer%TYPE
34: ,type_lookup_code po_requisition_headers_all.type_lookup_code%TYPE
35: ,transferred_to_oe_flag po_requisition_headers_all.transferred_to_oe_flag%TYPE
28: ,last_update_login po_requisition_headers_all.last_update_login%TYPE
29: ,creation_date po_requisition_headers_all.creation_date%TYPE
30: ,created_by po_requisition_headers_all.created_by%TYPE
31: ,description po_requisition_headers_all.description%TYPE
32: ,authorization_status po_requisition_headers_all.authorization_status%TYPE
33: ,note_to_authorizer po_requisition_headers_all.note_to_authorizer%TYPE
34: ,type_lookup_code po_requisition_headers_all.type_lookup_code%TYPE
35: ,transferred_to_oe_flag po_requisition_headers_all.transferred_to_oe_flag%TYPE
36: ,attribute_category po_requisition_headers_all.attribute_category%TYPE
29: ,creation_date po_requisition_headers_all.creation_date%TYPE
30: ,created_by po_requisition_headers_all.created_by%TYPE
31: ,description po_requisition_headers_all.description%TYPE
32: ,authorization_status po_requisition_headers_all.authorization_status%TYPE
33: ,note_to_authorizer po_requisition_headers_all.note_to_authorizer%TYPE
34: ,type_lookup_code po_requisition_headers_all.type_lookup_code%TYPE
35: ,transferred_to_oe_flag po_requisition_headers_all.transferred_to_oe_flag%TYPE
36: ,attribute_category po_requisition_headers_all.attribute_category%TYPE
37: ,attribute1 po_requisition_headers_all.attribute1%TYPE
30: ,created_by po_requisition_headers_all.created_by%TYPE
31: ,description po_requisition_headers_all.description%TYPE
32: ,authorization_status po_requisition_headers_all.authorization_status%TYPE
33: ,note_to_authorizer po_requisition_headers_all.note_to_authorizer%TYPE
34: ,type_lookup_code po_requisition_headers_all.type_lookup_code%TYPE
35: ,transferred_to_oe_flag po_requisition_headers_all.transferred_to_oe_flag%TYPE
36: ,attribute_category po_requisition_headers_all.attribute_category%TYPE
37: ,attribute1 po_requisition_headers_all.attribute1%TYPE
38: ,attribute2 po_requisition_headers_all.attribute2%TYPE
31: ,description po_requisition_headers_all.description%TYPE
32: ,authorization_status po_requisition_headers_all.authorization_status%TYPE
33: ,note_to_authorizer po_requisition_headers_all.note_to_authorizer%TYPE
34: ,type_lookup_code po_requisition_headers_all.type_lookup_code%TYPE
35: ,transferred_to_oe_flag po_requisition_headers_all.transferred_to_oe_flag%TYPE
36: ,attribute_category po_requisition_headers_all.attribute_category%TYPE
37: ,attribute1 po_requisition_headers_all.attribute1%TYPE
38: ,attribute2 po_requisition_headers_all.attribute2%TYPE
39: ,attribute3 po_requisition_headers_all.attribute3%TYPE
32: ,authorization_status po_requisition_headers_all.authorization_status%TYPE
33: ,note_to_authorizer po_requisition_headers_all.note_to_authorizer%TYPE
34: ,type_lookup_code po_requisition_headers_all.type_lookup_code%TYPE
35: ,transferred_to_oe_flag po_requisition_headers_all.transferred_to_oe_flag%TYPE
36: ,attribute_category po_requisition_headers_all.attribute_category%TYPE
37: ,attribute1 po_requisition_headers_all.attribute1%TYPE
38: ,attribute2 po_requisition_headers_all.attribute2%TYPE
39: ,attribute3 po_requisition_headers_all.attribute3%TYPE
40: ,attribute4 po_requisition_headers_all.attribute4%TYPE
33: ,note_to_authorizer po_requisition_headers_all.note_to_authorizer%TYPE
34: ,type_lookup_code po_requisition_headers_all.type_lookup_code%TYPE
35: ,transferred_to_oe_flag po_requisition_headers_all.transferred_to_oe_flag%TYPE
36: ,attribute_category po_requisition_headers_all.attribute_category%TYPE
37: ,attribute1 po_requisition_headers_all.attribute1%TYPE
38: ,attribute2 po_requisition_headers_all.attribute2%TYPE
39: ,attribute3 po_requisition_headers_all.attribute3%TYPE
40: ,attribute4 po_requisition_headers_all.attribute4%TYPE
41: ,attribute5 po_requisition_headers_all.attribute5%TYPE
34: ,type_lookup_code po_requisition_headers_all.type_lookup_code%TYPE
35: ,transferred_to_oe_flag po_requisition_headers_all.transferred_to_oe_flag%TYPE
36: ,attribute_category po_requisition_headers_all.attribute_category%TYPE
37: ,attribute1 po_requisition_headers_all.attribute1%TYPE
38: ,attribute2 po_requisition_headers_all.attribute2%TYPE
39: ,attribute3 po_requisition_headers_all.attribute3%TYPE
40: ,attribute4 po_requisition_headers_all.attribute4%TYPE
41: ,attribute5 po_requisition_headers_all.attribute5%TYPE
42: ,on_line_flag po_requisition_headers_all.on_line_flag%TYPE
35: ,transferred_to_oe_flag po_requisition_headers_all.transferred_to_oe_flag%TYPE
36: ,attribute_category po_requisition_headers_all.attribute_category%TYPE
37: ,attribute1 po_requisition_headers_all.attribute1%TYPE
38: ,attribute2 po_requisition_headers_all.attribute2%TYPE
39: ,attribute3 po_requisition_headers_all.attribute3%TYPE
40: ,attribute4 po_requisition_headers_all.attribute4%TYPE
41: ,attribute5 po_requisition_headers_all.attribute5%TYPE
42: ,on_line_flag po_requisition_headers_all.on_line_flag%TYPE
43: ,attribute6 po_requisition_headers_all.attribute6%TYPE
36: ,attribute_category po_requisition_headers_all.attribute_category%TYPE
37: ,attribute1 po_requisition_headers_all.attribute1%TYPE
38: ,attribute2 po_requisition_headers_all.attribute2%TYPE
39: ,attribute3 po_requisition_headers_all.attribute3%TYPE
40: ,attribute4 po_requisition_headers_all.attribute4%TYPE
41: ,attribute5 po_requisition_headers_all.attribute5%TYPE
42: ,on_line_flag po_requisition_headers_all.on_line_flag%TYPE
43: ,attribute6 po_requisition_headers_all.attribute6%TYPE
44: ,attribute7 po_requisition_headers_all.attribute7%TYPE
37: ,attribute1 po_requisition_headers_all.attribute1%TYPE
38: ,attribute2 po_requisition_headers_all.attribute2%TYPE
39: ,attribute3 po_requisition_headers_all.attribute3%TYPE
40: ,attribute4 po_requisition_headers_all.attribute4%TYPE
41: ,attribute5 po_requisition_headers_all.attribute5%TYPE
42: ,on_line_flag po_requisition_headers_all.on_line_flag%TYPE
43: ,attribute6 po_requisition_headers_all.attribute6%TYPE
44: ,attribute7 po_requisition_headers_all.attribute7%TYPE
45: ,attribute8 po_requisition_headers_all.attribute8%TYPE
38: ,attribute2 po_requisition_headers_all.attribute2%TYPE
39: ,attribute3 po_requisition_headers_all.attribute3%TYPE
40: ,attribute4 po_requisition_headers_all.attribute4%TYPE
41: ,attribute5 po_requisition_headers_all.attribute5%TYPE
42: ,on_line_flag po_requisition_headers_all.on_line_flag%TYPE
43: ,attribute6 po_requisition_headers_all.attribute6%TYPE
44: ,attribute7 po_requisition_headers_all.attribute7%TYPE
45: ,attribute8 po_requisition_headers_all.attribute8%TYPE
46: ,attribute9 po_requisition_headers_all.attribute9%TYPE
39: ,attribute3 po_requisition_headers_all.attribute3%TYPE
40: ,attribute4 po_requisition_headers_all.attribute4%TYPE
41: ,attribute5 po_requisition_headers_all.attribute5%TYPE
42: ,on_line_flag po_requisition_headers_all.on_line_flag%TYPE
43: ,attribute6 po_requisition_headers_all.attribute6%TYPE
44: ,attribute7 po_requisition_headers_all.attribute7%TYPE
45: ,attribute8 po_requisition_headers_all.attribute8%TYPE
46: ,attribute9 po_requisition_headers_all.attribute9%TYPE
47: ,attribute10 po_requisition_headers_all.attribute10%TYPE
40: ,attribute4 po_requisition_headers_all.attribute4%TYPE
41: ,attribute5 po_requisition_headers_all.attribute5%TYPE
42: ,on_line_flag po_requisition_headers_all.on_line_flag%TYPE
43: ,attribute6 po_requisition_headers_all.attribute6%TYPE
44: ,attribute7 po_requisition_headers_all.attribute7%TYPE
45: ,attribute8 po_requisition_headers_all.attribute8%TYPE
46: ,attribute9 po_requisition_headers_all.attribute9%TYPE
47: ,attribute10 po_requisition_headers_all.attribute10%TYPE
48: ,attribute11 po_requisition_headers_all.attribute11%TYPE
41: ,attribute5 po_requisition_headers_all.attribute5%TYPE
42: ,on_line_flag po_requisition_headers_all.on_line_flag%TYPE
43: ,attribute6 po_requisition_headers_all.attribute6%TYPE
44: ,attribute7 po_requisition_headers_all.attribute7%TYPE
45: ,attribute8 po_requisition_headers_all.attribute8%TYPE
46: ,attribute9 po_requisition_headers_all.attribute9%TYPE
47: ,attribute10 po_requisition_headers_all.attribute10%TYPE
48: ,attribute11 po_requisition_headers_all.attribute11%TYPE
49: ,attribute12 po_requisition_headers_all.attribute12%TYPE
42: ,on_line_flag po_requisition_headers_all.on_line_flag%TYPE
43: ,attribute6 po_requisition_headers_all.attribute6%TYPE
44: ,attribute7 po_requisition_headers_all.attribute7%TYPE
45: ,attribute8 po_requisition_headers_all.attribute8%TYPE
46: ,attribute9 po_requisition_headers_all.attribute9%TYPE
47: ,attribute10 po_requisition_headers_all.attribute10%TYPE
48: ,attribute11 po_requisition_headers_all.attribute11%TYPE
49: ,attribute12 po_requisition_headers_all.attribute12%TYPE
50: ,attribute13 po_requisition_headers_all.attribute13%TYPE
43: ,attribute6 po_requisition_headers_all.attribute6%TYPE
44: ,attribute7 po_requisition_headers_all.attribute7%TYPE
45: ,attribute8 po_requisition_headers_all.attribute8%TYPE
46: ,attribute9 po_requisition_headers_all.attribute9%TYPE
47: ,attribute10 po_requisition_headers_all.attribute10%TYPE
48: ,attribute11 po_requisition_headers_all.attribute11%TYPE
49: ,attribute12 po_requisition_headers_all.attribute12%TYPE
50: ,attribute13 po_requisition_headers_all.attribute13%TYPE
51: ,attribute14 po_requisition_headers_all.attribute14%TYPE
44: ,attribute7 po_requisition_headers_all.attribute7%TYPE
45: ,attribute8 po_requisition_headers_all.attribute8%TYPE
46: ,attribute9 po_requisition_headers_all.attribute9%TYPE
47: ,attribute10 po_requisition_headers_all.attribute10%TYPE
48: ,attribute11 po_requisition_headers_all.attribute11%TYPE
49: ,attribute12 po_requisition_headers_all.attribute12%TYPE
50: ,attribute13 po_requisition_headers_all.attribute13%TYPE
51: ,attribute14 po_requisition_headers_all.attribute14%TYPE
52: ,attribute15 po_requisition_headers_all.attribute15%TYPE
45: ,attribute8 po_requisition_headers_all.attribute8%TYPE
46: ,attribute9 po_requisition_headers_all.attribute9%TYPE
47: ,attribute10 po_requisition_headers_all.attribute10%TYPE
48: ,attribute11 po_requisition_headers_all.attribute11%TYPE
49: ,attribute12 po_requisition_headers_all.attribute12%TYPE
50: ,attribute13 po_requisition_headers_all.attribute13%TYPE
51: ,attribute14 po_requisition_headers_all.attribute14%TYPE
52: ,attribute15 po_requisition_headers_all.attribute15%TYPE
53: ,government_context po_requisition_headers_all.government_context%TYPE
46: ,attribute9 po_requisition_headers_all.attribute9%TYPE
47: ,attribute10 po_requisition_headers_all.attribute10%TYPE
48: ,attribute11 po_requisition_headers_all.attribute11%TYPE
49: ,attribute12 po_requisition_headers_all.attribute12%TYPE
50: ,attribute13 po_requisition_headers_all.attribute13%TYPE
51: ,attribute14 po_requisition_headers_all.attribute14%TYPE
52: ,attribute15 po_requisition_headers_all.attribute15%TYPE
53: ,government_context po_requisition_headers_all.government_context%TYPE
54: ,closed_code po_requisition_headers_all.closed_code%TYPE
47: ,attribute10 po_requisition_headers_all.attribute10%TYPE
48: ,attribute11 po_requisition_headers_all.attribute11%TYPE
49: ,attribute12 po_requisition_headers_all.attribute12%TYPE
50: ,attribute13 po_requisition_headers_all.attribute13%TYPE
51: ,attribute14 po_requisition_headers_all.attribute14%TYPE
52: ,attribute15 po_requisition_headers_all.attribute15%TYPE
53: ,government_context po_requisition_headers_all.government_context%TYPE
54: ,closed_code po_requisition_headers_all.closed_code%TYPE
55: ,org_id org_organization_definitions.organization_id%TYPE
48: ,attribute11 po_requisition_headers_all.attribute11%TYPE
49: ,attribute12 po_requisition_headers_all.attribute12%TYPE
50: ,attribute13 po_requisition_headers_all.attribute13%TYPE
51: ,attribute14 po_requisition_headers_all.attribute14%TYPE
52: ,attribute15 po_requisition_headers_all.attribute15%TYPE
53: ,government_context po_requisition_headers_all.government_context%TYPE
54: ,closed_code po_requisition_headers_all.closed_code%TYPE
55: ,org_id org_organization_definitions.organization_id%TYPE
56: ,emergency_po_num po_requisition_headers_all.emergency_po_num%TYPE
49: ,attribute12 po_requisition_headers_all.attribute12%TYPE
50: ,attribute13 po_requisition_headers_all.attribute13%TYPE
51: ,attribute14 po_requisition_headers_all.attribute14%TYPE
52: ,attribute15 po_requisition_headers_all.attribute15%TYPE
53: ,government_context po_requisition_headers_all.government_context%TYPE
54: ,closed_code po_requisition_headers_all.closed_code%TYPE
55: ,org_id org_organization_definitions.organization_id%TYPE
56: ,emergency_po_num po_requisition_headers_all.emergency_po_num%TYPE
57: );
50: ,attribute13 po_requisition_headers_all.attribute13%TYPE
51: ,attribute14 po_requisition_headers_all.attribute14%TYPE
52: ,attribute15 po_requisition_headers_all.attribute15%TYPE
53: ,government_context po_requisition_headers_all.government_context%TYPE
54: ,closed_code po_requisition_headers_all.closed_code%TYPE
55: ,org_id org_organization_definitions.organization_id%TYPE
56: ,emergency_po_num po_requisition_headers_all.emergency_po_num%TYPE
57: );
58:
52: ,attribute15 po_requisition_headers_all.attribute15%TYPE
53: ,government_context po_requisition_headers_all.government_context%TYPE
54: ,closed_code po_requisition_headers_all.closed_code%TYPE
55: ,org_id org_organization_definitions.organization_id%TYPE
56: ,emergency_po_num po_requisition_headers_all.emergency_po_num%TYPE
57: );
58:
59: TYPE Line_Rec_type IS RECORD
60: (requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE
57: );
58:
59: TYPE Line_Rec_type IS RECORD
60: (requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE
61: ,requisition_header_id po_requisition_headers_all.requisition_header_id%TYPE
62: ,line_num po_requisition_lines_all.line_num%TYPE
63: ,line_type_id po_requisition_lines_all.line_type_id%TYPE
64: ,category_id mtl_categories.category_id%TYPE
65: ,item_description mtl_system_items.description%TYPE