12:
13: g_Enforce_list_price_rec Enforce_list_price_rec_Type;
14:
15: TYPE Order_Type_Rec_Type IS RECORD
16: ( order_type_id NUMBER := FND_API.G_MISS_NUM
17: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
18: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
19: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
20: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
13: g_Enforce_list_price_rec Enforce_list_price_rec_Type;
14:
15: TYPE Order_Type_Rec_Type IS RECORD
16: ( order_type_id NUMBER := FND_API.G_MISS_NUM
17: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
18: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
19: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
20: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
21: , price_list_id NUMBER := FND_API.G_MISS_NUM
14:
15: TYPE Order_Type_Rec_Type IS RECORD
16: ( order_type_id NUMBER := FND_API.G_MISS_NUM
17: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
18: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
19: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
20: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
21: , price_list_id NUMBER := FND_API.G_MISS_NUM
22: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
15: TYPE Order_Type_Rec_Type IS RECORD
16: ( order_type_id NUMBER := FND_API.G_MISS_NUM
17: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
18: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
19: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
20: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
21: , price_list_id NUMBER := FND_API.G_MISS_NUM
22: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
16: ( order_type_id NUMBER := FND_API.G_MISS_NUM
17: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
18: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
19: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
20: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
21: , price_list_id NUMBER := FND_API.G_MISS_NUM
22: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
17: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
18: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
19: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
20: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
21: , price_list_id NUMBER := FND_API.G_MISS_NUM
22: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
18: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
19: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
20: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
21: , price_list_id NUMBER := FND_API.G_MISS_NUM
22: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
19: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
20: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
21: , price_list_id NUMBER := FND_API.G_MISS_NUM
22: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
27: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
20: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
21: , price_list_id NUMBER := FND_API.G_MISS_NUM
22: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
27: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , order_number_source_id NUMBER := FND_API.G_MISS_NUM
21: , price_list_id NUMBER := FND_API.G_MISS_NUM
22: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
27: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , order_number_source_id NUMBER := FND_API.G_MISS_NUM
29: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
27: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , order_number_source_id NUMBER := FND_API.G_MISS_NUM
29: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , require_po_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
23: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
27: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , order_number_source_id NUMBER := FND_API.G_MISS_NUM
29: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , require_po_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
24: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
27: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , order_number_source_id NUMBER := FND_API.G_MISS_NUM
29: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , require_po_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
32: , auto_scheduling_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
27: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , order_number_source_id NUMBER := FND_API.G_MISS_NUM
29: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , require_po_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
32: , auto_scheduling_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
33: -- QUOTING changes
26: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
27: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , order_number_source_id NUMBER := FND_API.G_MISS_NUM
29: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , require_po_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
32: , auto_scheduling_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
33: -- QUOTING changes
34: , quote_num_as_ord_num_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
27: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , order_number_source_id NUMBER := FND_API.G_MISS_NUM
29: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , require_po_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
32: , auto_scheduling_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
33: -- QUOTING changes
34: , quote_num_as_ord_num_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
28: , order_number_source_id NUMBER := FND_API.G_MISS_NUM
29: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , require_po_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
32: , auto_scheduling_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
33: -- QUOTING changes
34: , quote_num_as_ord_num_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
36: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
30: , require_po_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
32: , auto_scheduling_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
33: -- QUOTING changes
34: , quote_num_as_ord_num_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
36: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
37: -- bug 4200055
38: , start_date_active DATE := FND_API.G_MISS_DATE
31: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
32: , auto_scheduling_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
33: -- QUOTING changes
34: , quote_num_as_ord_num_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
36: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
37: -- bug 4200055
38: , start_date_active DATE := FND_API.G_MISS_DATE
39: , end_date_active DATE := FND_API.G_MISS_DATE
32: , auto_scheduling_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
33: -- QUOTING changes
34: , quote_num_as_ord_num_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
36: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
37: -- bug 4200055
38: , start_date_active DATE := FND_API.G_MISS_DATE
39: , end_date_active DATE := FND_API.G_MISS_DATE
40: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
34: , quote_num_as_ord_num_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
36: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
37: -- bug 4200055
38: , start_date_active DATE := FND_API.G_MISS_DATE
39: , end_date_active DATE := FND_API.G_MISS_DATE
40: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
41: );
42:
35: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
36: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
37: -- bug 4200055
38: , start_date_active DATE := FND_API.G_MISS_DATE
39: , end_date_active DATE := FND_API.G_MISS_DATE
40: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
41: );
42:
43: TYPE Tax_Code_Cach IS RECORD(
36: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
37: -- bug 4200055
38: , start_date_active DATE := FND_API.G_MISS_DATE
39: , end_date_active DATE := FND_API.G_MISS_DATE
40: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
41: );
42:
43: TYPE Tax_Code_Cach IS RECORD(
44: ship_to_org_id NUMBER := FND_API.G_MISS_NUM
40: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
41: );
42:
43: TYPE Tax_Code_Cach IS RECORD(
44: ship_to_org_id NUMBER := FND_API.G_MISS_NUM
45: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
46: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
47: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
48: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
41: );
42:
43: TYPE Tax_Code_Cach IS RECORD(
44: ship_to_org_id NUMBER := FND_API.G_MISS_NUM
45: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
46: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
47: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
48: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
49: , tax_date DATE := fnd_api.g_miss_date
42:
43: TYPE Tax_Code_Cach IS RECORD(
44: ship_to_org_id NUMBER := FND_API.G_MISS_NUM
45: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
46: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
47: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
48: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
49: , tax_date DATE := fnd_api.g_miss_date
50: , trx_type_id NUMBER := FND_API.G_MISS_NUM
43: TYPE Tax_Code_Cach IS RECORD(
44: ship_to_org_id NUMBER := FND_API.G_MISS_NUM
45: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
46: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
47: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
48: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
49: , tax_date DATE := fnd_api.g_miss_date
50: , trx_type_id NUMBER := FND_API.G_MISS_NUM
51: , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR
44: ship_to_org_id NUMBER := FND_API.G_MISS_NUM
45: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
46: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
47: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
48: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
49: , tax_date DATE := fnd_api.g_miss_date
50: , trx_type_id NUMBER := FND_API.G_MISS_NUM
51: , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR
52: , tax_exempt_number VARCHAR2(80) := FND_API.G_MISS_CHAR
45: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
46: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
47: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
48: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
49: , tax_date DATE := fnd_api.g_miss_date
50: , trx_type_id NUMBER := FND_API.G_MISS_NUM
51: , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR
52: , tax_exempt_number VARCHAR2(80) := FND_API.G_MISS_CHAR
53: , tax_exempt_reason_code VARCHAR2(80) := FND_API.G_MISS_CHAR
46: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
47: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
48: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
49: , tax_date DATE := fnd_api.g_miss_date
50: , trx_type_id NUMBER := FND_API.G_MISS_NUM
51: , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR
52: , tax_exempt_number VARCHAR2(80) := FND_API.G_MISS_CHAR
53: , tax_exempt_reason_code VARCHAR2(80) := FND_API.G_MISS_CHAR
54: , vat_tax_id NUMBER := FND_API.G_MISS_NUM
47: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
48: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
49: , tax_date DATE := fnd_api.g_miss_date
50: , trx_type_id NUMBER := FND_API.G_MISS_NUM
51: , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR
52: , tax_exempt_number VARCHAR2(80) := FND_API.G_MISS_CHAR
53: , tax_exempt_reason_code VARCHAR2(80) := FND_API.G_MISS_CHAR
54: , vat_tax_id NUMBER := FND_API.G_MISS_NUM
55: , amt_incl_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
48: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
49: , tax_date DATE := fnd_api.g_miss_date
50: , trx_type_id NUMBER := FND_API.G_MISS_NUM
51: , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR
52: , tax_exempt_number VARCHAR2(80) := FND_API.G_MISS_CHAR
53: , tax_exempt_reason_code VARCHAR2(80) := FND_API.G_MISS_CHAR
54: , vat_tax_id NUMBER := FND_API.G_MISS_NUM
55: , amt_incl_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , amt_incl_tax_override VARCHAR2(1) := FND_API.G_MISS_CHAR
49: , tax_date DATE := fnd_api.g_miss_date
50: , trx_type_id NUMBER := FND_API.G_MISS_NUM
51: , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR
52: , tax_exempt_number VARCHAR2(80) := FND_API.G_MISS_CHAR
53: , tax_exempt_reason_code VARCHAR2(80) := FND_API.G_MISS_CHAR
54: , vat_tax_id NUMBER := FND_API.G_MISS_NUM
55: , amt_incl_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , amt_incl_tax_override VARCHAR2(1) := FND_API.G_MISS_CHAR
57: );
50: , trx_type_id NUMBER := FND_API.G_MISS_NUM
51: , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR
52: , tax_exempt_number VARCHAR2(80) := FND_API.G_MISS_CHAR
53: , tax_exempt_reason_code VARCHAR2(80) := FND_API.G_MISS_CHAR
54: , vat_tax_id NUMBER := FND_API.G_MISS_NUM
55: , amt_incl_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , amt_incl_tax_override VARCHAR2(1) := FND_API.G_MISS_CHAR
57: );
58:
51: , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR
52: , tax_exempt_number VARCHAR2(80) := FND_API.G_MISS_CHAR
53: , tax_exempt_reason_code VARCHAR2(80) := FND_API.G_MISS_CHAR
54: , vat_tax_id NUMBER := FND_API.G_MISS_NUM
55: , amt_incl_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , amt_incl_tax_override VARCHAR2(1) := FND_API.G_MISS_CHAR
57: );
58:
59: g_TAX_CODE_CACH Tax_Code_Cach;
52: , tax_exempt_number VARCHAR2(80) := FND_API.G_MISS_CHAR
53: , tax_exempt_reason_code VARCHAR2(80) := FND_API.G_MISS_CHAR
54: , vat_tax_id NUMBER := FND_API.G_MISS_NUM
55: , amt_incl_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , amt_incl_tax_override VARCHAR2(1) := FND_API.G_MISS_CHAR
57: );
58:
59: g_TAX_CODE_CACH Tax_Code_Cach;
60: g_TAX_EXEMPTION_CACH Tax_Code_Cach;
62:
63: -- Line Type record type.
64:
65: TYPE Line_Type_Rec_Type IS RECORD
66: ( Line_Type_id NUMBER := FND_API.G_MISS_NUM
67: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
68: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
69: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
70: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
63: -- Line Type record type.
64:
65: TYPE Line_Type_Rec_Type IS RECORD
66: ( Line_Type_id NUMBER := FND_API.G_MISS_NUM
67: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
68: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
69: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
70: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
71: , price_list_id NUMBER := FND_API.G_MISS_NUM
64:
65: TYPE Line_Type_Rec_Type IS RECORD
66: ( Line_Type_id NUMBER := FND_API.G_MISS_NUM
67: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
68: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
69: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
70: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
71: , price_list_id NUMBER := FND_API.G_MISS_NUM
72: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: TYPE Line_Type_Rec_Type IS RECORD
66: ( Line_Type_id NUMBER := FND_API.G_MISS_NUM
67: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
68: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
69: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
70: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
71: , price_list_id NUMBER := FND_API.G_MISS_NUM
72: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ( Line_Type_id NUMBER := FND_API.G_MISS_NUM
67: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
68: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
69: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
70: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
71: , price_list_id NUMBER := FND_API.G_MISS_NUM
72: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
74: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
67: , name VARCHAR2(80) := FND_API.G_MISS_CHAR
68: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
69: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
70: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
71: , price_list_id NUMBER := FND_API.G_MISS_NUM
72: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
74: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
69: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
70: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
71: , price_list_id NUMBER := FND_API.G_MISS_NUM
72: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
74: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
69: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
70: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
71: , price_list_id NUMBER := FND_API.G_MISS_NUM
72: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
74: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
77: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
71: , price_list_id NUMBER := FND_API.G_MISS_NUM
72: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
74: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
77: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
71: , price_list_id NUMBER := FND_API.G_MISS_NUM
72: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
74: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
77: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
79: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
72: , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
74: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
77: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
79: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
80: , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
73: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
74: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
77: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
79: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
80: , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR
74: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
77: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
79: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
80: , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , ship_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
77: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
79: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
80: , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , ship_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
76: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
77: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
79: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
80: , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , ship_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
84: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
77: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
79: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
80: , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , ship_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
84: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
85: --added for bug 4200055
78: , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
79: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
80: , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , ship_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
84: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
85: --added for bug 4200055
86: , start_date_active DATE := FND_API.G_MISS_DATE
79: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
80: , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , ship_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
84: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
85: --added for bug 4200055
86: , start_date_active DATE := FND_API.G_MISS_DATE
87: , end_date_active DATE := FND_API.G_MISS_DATE
80: , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , ship_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
84: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
85: --added for bug 4200055
86: , start_date_active DATE := FND_API.G_MISS_DATE
87: , end_date_active DATE := FND_API.G_MISS_DATE
88: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , ship_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
84: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
85: --added for bug 4200055
86: , start_date_active DATE := FND_API.G_MISS_DATE
87: , end_date_active DATE := FND_API.G_MISS_DATE
88: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: );
90:
83: , invoice_source_id NUMBER := FND_API.G_MISS_NUM
84: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
85: --added for bug 4200055
86: , start_date_active DATE := FND_API.G_MISS_DATE
87: , end_date_active DATE := FND_API.G_MISS_DATE
88: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: );
90:
91: -- Agreement record type.
84: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
85: --added for bug 4200055
86: , start_date_active DATE := FND_API.G_MISS_DATE
87: , end_date_active DATE := FND_API.G_MISS_DATE
88: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: );
90:
91: -- Agreement record type.
92:
90:
91: -- Agreement record type.
92:
93: TYPE Agreement_Rec_Type IS RECORD
94: ( agreement_id NUMBER := FND_API.G_MISS_NUM
95: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
96: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
97: , price_list_id NUMBER := FND_API.G_MISS_NUM
98: , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR
91: -- Agreement record type.
92:
93: TYPE Agreement_Rec_Type IS RECORD
94: ( agreement_id NUMBER := FND_API.G_MISS_NUM
95: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
96: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
97: , price_list_id NUMBER := FND_API.G_MISS_NUM
98: , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR
99: , payment_term_id NUMBER := FND_API.G_MISS_NUM
92:
93: TYPE Agreement_Rec_Type IS RECORD
94: ( agreement_id NUMBER := FND_API.G_MISS_NUM
95: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
96: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
97: , price_list_id NUMBER := FND_API.G_MISS_NUM
98: , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR
99: , payment_term_id NUMBER := FND_API.G_MISS_NUM
100: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
93: TYPE Agreement_Rec_Type IS RECORD
94: ( agreement_id NUMBER := FND_API.G_MISS_NUM
95: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
96: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
97: , price_list_id NUMBER := FND_API.G_MISS_NUM
98: , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR
99: , payment_term_id NUMBER := FND_API.G_MISS_NUM
100: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
101: , invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM
94: ( agreement_id NUMBER := FND_API.G_MISS_NUM
95: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
96: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
97: , price_list_id NUMBER := FND_API.G_MISS_NUM
98: , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR
99: , payment_term_id NUMBER := FND_API.G_MISS_NUM
100: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
101: , invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM
102: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
95: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
96: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
97: , price_list_id NUMBER := FND_API.G_MISS_NUM
98: , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR
99: , payment_term_id NUMBER := FND_API.G_MISS_NUM
100: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
101: , invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM
102: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
96: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
97: , price_list_id NUMBER := FND_API.G_MISS_NUM
98: , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR
99: , payment_term_id NUMBER := FND_API.G_MISS_NUM
100: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
101: , invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM
102: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
104: );
97: , price_list_id NUMBER := FND_API.G_MISS_NUM
98: , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR
99: , payment_term_id NUMBER := FND_API.G_MISS_NUM
100: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
101: , invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM
102: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
104: );
105:
98: , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR
99: , payment_term_id NUMBER := FND_API.G_MISS_NUM
100: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
101: , invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM
102: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
104: );
105:
106: -- Ship To record type
99: , payment_term_id NUMBER := FND_API.G_MISS_NUM
100: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
101: , invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM
102: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
104: );
105:
106: -- Ship To record type
107:
105:
106: -- Ship To record type
107:
108: TYPE Ship_To_Org_Rec_Type IS RECORD
109: ( org_id NUMBER := FND_API.G_MISS_NUM
110: , price_list_id NUMBER := FND_API.G_MISS_NUM
111: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
112: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
106: -- Ship To record type
107:
108: TYPE Ship_To_Org_Rec_Type IS RECORD
109: ( org_id NUMBER := FND_API.G_MISS_NUM
110: , price_list_id NUMBER := FND_API.G_MISS_NUM
111: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
112: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
114: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
107:
108: TYPE Ship_To_Org_Rec_Type IS RECORD
109: ( org_id NUMBER := FND_API.G_MISS_NUM
110: , price_list_id NUMBER := FND_API.G_MISS_NUM
111: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
112: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
114: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
115: , payment_term_id NUMBER := FND_API.G_MISS_NUM
108: TYPE Ship_To_Org_Rec_Type IS RECORD
109: ( org_id NUMBER := FND_API.G_MISS_NUM
110: , price_list_id NUMBER := FND_API.G_MISS_NUM
111: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
112: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
114: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
115: , payment_term_id NUMBER := FND_API.G_MISS_NUM
116: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
109: ( org_id NUMBER := FND_API.G_MISS_NUM
110: , price_list_id NUMBER := FND_API.G_MISS_NUM
111: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
112: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
114: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
115: , payment_term_id NUMBER := FND_API.G_MISS_NUM
116: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
117: , contact_id NUMBER := FND_API.G_MISS_NUM
110: , price_list_id NUMBER := FND_API.G_MISS_NUM
111: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
112: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
114: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
115: , payment_term_id NUMBER := FND_API.G_MISS_NUM
116: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
117: , contact_id NUMBER := FND_API.G_MISS_NUM
118: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
112: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
114: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
115: , payment_term_id NUMBER := FND_API.G_MISS_NUM
116: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
117: , contact_id NUMBER := FND_API.G_MISS_NUM
118: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
112: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
114: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
115: , payment_term_id NUMBER := FND_API.G_MISS_NUM
116: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
117: , contact_id NUMBER := FND_API.G_MISS_NUM
118: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
120: );
113: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
114: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
115: , payment_term_id NUMBER := FND_API.G_MISS_NUM
116: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
117: , contact_id NUMBER := FND_API.G_MISS_NUM
118: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
120: );
121:
114: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
115: , payment_term_id NUMBER := FND_API.G_MISS_NUM
116: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
117: , contact_id NUMBER := FND_API.G_MISS_NUM
118: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
120: );
121:
122: -- Invoice To record type
115: , payment_term_id NUMBER := FND_API.G_MISS_NUM
116: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
117: , contact_id NUMBER := FND_API.G_MISS_NUM
118: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
120: );
121:
122: -- Invoice To record type
123:
121:
122: -- Invoice To record type
123:
124: TYPE Invoice_To_Org_Rec_Type IS RECORD
125: ( org_id NUMBER := FND_API.G_MISS_NUM
126: , price_list_id NUMBER := FND_API.G_MISS_NUM
127: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
128: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
129: , payment_term_id NUMBER := FND_API.G_MISS_NUM
122: -- Invoice To record type
123:
124: TYPE Invoice_To_Org_Rec_Type IS RECORD
125: ( org_id NUMBER := FND_API.G_MISS_NUM
126: , price_list_id NUMBER := FND_API.G_MISS_NUM
127: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
128: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
129: , payment_term_id NUMBER := FND_API.G_MISS_NUM
130: , contact_id NUMBER := FND_API.G_MISS_NUM
123:
124: TYPE Invoice_To_Org_Rec_Type IS RECORD
125: ( org_id NUMBER := FND_API.G_MISS_NUM
126: , price_list_id NUMBER := FND_API.G_MISS_NUM
127: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
128: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
129: , payment_term_id NUMBER := FND_API.G_MISS_NUM
130: , contact_id NUMBER := FND_API.G_MISS_NUM
131: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
124: TYPE Invoice_To_Org_Rec_Type IS RECORD
125: ( org_id NUMBER := FND_API.G_MISS_NUM
126: , price_list_id NUMBER := FND_API.G_MISS_NUM
127: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
128: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
129: , payment_term_id NUMBER := FND_API.G_MISS_NUM
130: , contact_id NUMBER := FND_API.G_MISS_NUM
131: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
125: ( org_id NUMBER := FND_API.G_MISS_NUM
126: , price_list_id NUMBER := FND_API.G_MISS_NUM
127: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
128: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
129: , payment_term_id NUMBER := FND_API.G_MISS_NUM
130: , contact_id NUMBER := FND_API.G_MISS_NUM
131: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
133: -- addded for bug 4200055
126: , price_list_id NUMBER := FND_API.G_MISS_NUM
127: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
128: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
129: , payment_term_id NUMBER := FND_API.G_MISS_NUM
130: , contact_id NUMBER := FND_API.G_MISS_NUM
131: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
133: -- addded for bug 4200055
134: , status VARCHAR2(1) := FND_API.G_MISS_CHAR
127: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
128: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
129: , payment_term_id NUMBER := FND_API.G_MISS_NUM
130: , contact_id NUMBER := FND_API.G_MISS_NUM
131: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
133: -- addded for bug 4200055
134: , status VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , address_status VARCHAR2(1) := FND_API.G_MISS_CHAR
128: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
129: , payment_term_id NUMBER := FND_API.G_MISS_NUM
130: , contact_id NUMBER := FND_API.G_MISS_NUM
131: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
133: -- addded for bug 4200055
134: , status VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , address_status VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , start_date_active DATE := FND_API.G_MISS_DATE
130: , contact_id NUMBER := FND_API.G_MISS_NUM
131: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
133: -- addded for bug 4200055
134: , status VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , address_status VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , start_date_active DATE := FND_API.G_MISS_DATE
137: , end_date_active DATE := FND_API.G_MISS_DATE
138: );
131: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
133: -- addded for bug 4200055
134: , status VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , address_status VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , start_date_active DATE := FND_API.G_MISS_DATE
137: , end_date_active DATE := FND_API.G_MISS_DATE
138: );
139:
132: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
133: -- addded for bug 4200055
134: , status VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , address_status VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , start_date_active DATE := FND_API.G_MISS_DATE
137: , end_date_active DATE := FND_API.G_MISS_DATE
138: );
139:
140: -- Deliver To record type
133: -- addded for bug 4200055
134: , status VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , address_status VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , start_date_active DATE := FND_API.G_MISS_DATE
137: , end_date_active DATE := FND_API.G_MISS_DATE
138: );
139:
140: -- Deliver To record type
141:
139:
140: -- Deliver To record type
141:
142: TYPE Deliver_To_Org_Rec_Type IS RECORD
143: ( org_id NUMBER := FND_API.G_MISS_NUM
144: , price_list_id NUMBER := FND_API.G_MISS_NUM
145: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
146: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
140: -- Deliver To record type
141:
142: TYPE Deliver_To_Org_Rec_Type IS RECORD
143: ( org_id NUMBER := FND_API.G_MISS_NUM
144: , price_list_id NUMBER := FND_API.G_MISS_NUM
145: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
146: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
148: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
141:
142: TYPE Deliver_To_Org_Rec_Type IS RECORD
143: ( org_id NUMBER := FND_API.G_MISS_NUM
144: , price_list_id NUMBER := FND_API.G_MISS_NUM
145: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
146: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
148: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
149: , payment_term_id NUMBER := FND_API.G_MISS_NUM
142: TYPE Deliver_To_Org_Rec_Type IS RECORD
143: ( org_id NUMBER := FND_API.G_MISS_NUM
144: , price_list_id NUMBER := FND_API.G_MISS_NUM
145: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
146: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
148: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
149: , payment_term_id NUMBER := FND_API.G_MISS_NUM
150: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
143: ( org_id NUMBER := FND_API.G_MISS_NUM
144: , price_list_id NUMBER := FND_API.G_MISS_NUM
145: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
146: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
148: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
149: , payment_term_id NUMBER := FND_API.G_MISS_NUM
150: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
151: , contact_id NUMBER := FND_API.G_MISS_NUM
144: , price_list_id NUMBER := FND_API.G_MISS_NUM
145: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
146: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
148: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
149: , payment_term_id NUMBER := FND_API.G_MISS_NUM
150: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
151: , contact_id NUMBER := FND_API.G_MISS_NUM
152: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
146: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
148: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
149: , payment_term_id NUMBER := FND_API.G_MISS_NUM
150: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
151: , contact_id NUMBER := FND_API.G_MISS_NUM
152: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
153: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
146: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
148: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
149: , payment_term_id NUMBER := FND_API.G_MISS_NUM
150: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
151: , contact_id NUMBER := FND_API.G_MISS_NUM
152: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
153: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
154: );
147: , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
148: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
149: , payment_term_id NUMBER := FND_API.G_MISS_NUM
150: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
151: , contact_id NUMBER := FND_API.G_MISS_NUM
152: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
153: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
154: );
155:
148: , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
149: , payment_term_id NUMBER := FND_API.G_MISS_NUM
150: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
151: , contact_id NUMBER := FND_API.G_MISS_NUM
152: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
153: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
154: );
155:
156: -- Sold To record type
149: , payment_term_id NUMBER := FND_API.G_MISS_NUM
150: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
151: , contact_id NUMBER := FND_API.G_MISS_NUM
152: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
153: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
154: );
155:
156: -- Sold To record type
157:
155:
156: -- Sold To record type
157:
158: TYPE Sold_To_Org_Rec_Type IS RECORD
159: ( org_id NUMBER := FND_API.G_MISS_NUM
160: , price_list_id NUMBER := FND_API.G_MISS_NUM
161: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , payment_term_id NUMBER := FND_API.G_MISS_NUM
156: -- Sold To record type
157:
158: TYPE Sold_To_Org_Rec_Type IS RECORD
159: ( org_id NUMBER := FND_API.G_MISS_NUM
160: , price_list_id NUMBER := FND_API.G_MISS_NUM
161: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , payment_term_id NUMBER := FND_API.G_MISS_NUM
164: , ship_to_org_id NUMBER := FND_API.G_MISS_NUM
157:
158: TYPE Sold_To_Org_Rec_Type IS RECORD
159: ( org_id NUMBER := FND_API.G_MISS_NUM
160: , price_list_id NUMBER := FND_API.G_MISS_NUM
161: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , payment_term_id NUMBER := FND_API.G_MISS_NUM
164: , ship_to_org_id NUMBER := FND_API.G_MISS_NUM
165: , deliver_to_org_id NUMBER := FND_API.G_MISS_NUM
158: TYPE Sold_To_Org_Rec_Type IS RECORD
159: ( org_id NUMBER := FND_API.G_MISS_NUM
160: , price_list_id NUMBER := FND_API.G_MISS_NUM
161: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , payment_term_id NUMBER := FND_API.G_MISS_NUM
164: , ship_to_org_id NUMBER := FND_API.G_MISS_NUM
165: , deliver_to_org_id NUMBER := FND_API.G_MISS_NUM
166: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
159: ( org_id NUMBER := FND_API.G_MISS_NUM
160: , price_list_id NUMBER := FND_API.G_MISS_NUM
161: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , payment_term_id NUMBER := FND_API.G_MISS_NUM
164: , ship_to_org_id NUMBER := FND_API.G_MISS_NUM
165: , deliver_to_org_id NUMBER := FND_API.G_MISS_NUM
166: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
167: , contact_id NUMBER := FND_API.G_MISS_NUM
160: , price_list_id NUMBER := FND_API.G_MISS_NUM
161: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , payment_term_id NUMBER := FND_API.G_MISS_NUM
164: , ship_to_org_id NUMBER := FND_API.G_MISS_NUM
165: , deliver_to_org_id NUMBER := FND_API.G_MISS_NUM
166: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
167: , contact_id NUMBER := FND_API.G_MISS_NUM
168: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
161: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , payment_term_id NUMBER := FND_API.G_MISS_NUM
164: , ship_to_org_id NUMBER := FND_API.G_MISS_NUM
165: , deliver_to_org_id NUMBER := FND_API.G_MISS_NUM
166: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
167: , contact_id NUMBER := FND_API.G_MISS_NUM
168: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
169: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , payment_term_id NUMBER := FND_API.G_MISS_NUM
164: , ship_to_org_id NUMBER := FND_API.G_MISS_NUM
165: , deliver_to_org_id NUMBER := FND_API.G_MISS_NUM
166: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
167: , contact_id NUMBER := FND_API.G_MISS_NUM
168: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
169: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , order_type_id NUMBER := FND_API.G_MISS_NUM
163: , payment_term_id NUMBER := FND_API.G_MISS_NUM
164: , ship_to_org_id NUMBER := FND_API.G_MISS_NUM
165: , deliver_to_org_id NUMBER := FND_API.G_MISS_NUM
166: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
167: , contact_id NUMBER := FND_API.G_MISS_NUM
168: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
169: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , order_type_id NUMBER := FND_API.G_MISS_NUM
171: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
164: , ship_to_org_id NUMBER := FND_API.G_MISS_NUM
165: , deliver_to_org_id NUMBER := FND_API.G_MISS_NUM
166: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
167: , contact_id NUMBER := FND_API.G_MISS_NUM
168: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
169: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , order_type_id NUMBER := FND_API.G_MISS_NUM
171: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
172: );
165: , deliver_to_org_id NUMBER := FND_API.G_MISS_NUM
166: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
167: , contact_id NUMBER := FND_API.G_MISS_NUM
168: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
169: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , order_type_id NUMBER := FND_API.G_MISS_NUM
171: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
172: );
173:
166: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
167: , contact_id NUMBER := FND_API.G_MISS_NUM
168: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
169: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , order_type_id NUMBER := FND_API.G_MISS_NUM
171: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
172: );
173:
174: -- Price List record type
167: , contact_id NUMBER := FND_API.G_MISS_NUM
168: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
169: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , order_type_id NUMBER := FND_API.G_MISS_NUM
171: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
172: );
173:
174: -- Price List record type
175:
173:
174: -- Price List record type
175:
176: TYPE Price_List_Rec_Type IS RECORD
177: ( price_list_id NUMBER := FND_API.G_MISS_NUM
178: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
179: , payment_term_id NUMBER := FND_API.G_MISS_NUM
180: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
181: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
174: -- Price List record type
175:
176: TYPE Price_List_Rec_Type IS RECORD
177: ( price_list_id NUMBER := FND_API.G_MISS_NUM
178: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
179: , payment_term_id NUMBER := FND_API.G_MISS_NUM
180: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
181: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
182: -- added for bug 4200055
175:
176: TYPE Price_List_Rec_Type IS RECORD
177: ( price_list_id NUMBER := FND_API.G_MISS_NUM
178: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
179: , payment_term_id NUMBER := FND_API.G_MISS_NUM
180: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
181: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
182: -- added for bug 4200055
183: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
176: TYPE Price_List_Rec_Type IS RECORD
177: ( price_list_id NUMBER := FND_API.G_MISS_NUM
178: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
179: , payment_term_id NUMBER := FND_API.G_MISS_NUM
180: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
181: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
182: -- added for bug 4200055
183: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
177: ( price_list_id NUMBER := FND_API.G_MISS_NUM
178: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
179: , payment_term_id NUMBER := FND_API.G_MISS_NUM
180: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
181: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
182: -- added for bug 4200055
183: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
185: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , payment_term_id NUMBER := FND_API.G_MISS_NUM
180: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
181: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
182: -- added for bug 4200055
183: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
185: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
186: , start_date_active DATE := FND_API.G_MISS_DATE
187: , end_date_active DATE := FND_API.G_MISS_DATE
180: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
181: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
182: -- added for bug 4200055
183: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
185: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
186: , start_date_active DATE := FND_API.G_MISS_DATE
187: , end_date_active DATE := FND_API.G_MISS_DATE
188: );
181: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
182: -- added for bug 4200055
183: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
185: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
186: , start_date_active DATE := FND_API.G_MISS_DATE
187: , end_date_active DATE := FND_API.G_MISS_DATE
188: );
189:
182: -- added for bug 4200055
183: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
185: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
186: , start_date_active DATE := FND_API.G_MISS_DATE
187: , end_date_active DATE := FND_API.G_MISS_DATE
188: );
189:
190: -- Set_Of_Books record type
183: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
185: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
186: , start_date_active DATE := FND_API.G_MISS_DATE
187: , end_date_active DATE := FND_API.G_MISS_DATE
188: );
189:
190: -- Set_Of_Books record type
191:
189:
190: -- Set_Of_Books record type
191:
192: TYPE Set_Of_Books_Rec_Type IS RECORD
193: ( set_of_books_id NUMBER := FND_API.G_MISS_NUM
194: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
195: );
196:
197: -- Item record type
190: -- Set_Of_Books record type
191:
192: TYPE Set_Of_Books_Rec_Type IS RECORD
193: ( set_of_books_id NUMBER := FND_API.G_MISS_NUM
194: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
195: );
196:
197: -- Item record type
198: -- OPM 02/JUN/00 - Add process control chatacteristics for dual um and grade
197: -- Item record type
198: -- OPM 02/JUN/00 - Add process control chatacteristics for dual um and grade
199:
200: TYPE Item_Rec_Type IS RECORD
201: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
202: , organization_id NUMBER := FND_API.G_MISS_NUM
203: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
204: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
205: , default_shipping_org NUMBER := FND_API.G_MISS_NUM
198: -- OPM 02/JUN/00 - Add process control chatacteristics for dual um and grade
199:
200: TYPE Item_Rec_Type IS RECORD
201: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
202: , organization_id NUMBER := FND_API.G_MISS_NUM
203: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
204: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
205: , default_shipping_org NUMBER := FND_API.G_MISS_NUM
206: , ship_model_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
199:
200: TYPE Item_Rec_Type IS RECORD
201: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
202: , organization_id NUMBER := FND_API.G_MISS_NUM
203: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
204: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
205: , default_shipping_org NUMBER := FND_API.G_MISS_NUM
206: , ship_model_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
207: , build_in_wip_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
200: TYPE Item_Rec_Type IS RECORD
201: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
202: , organization_id NUMBER := FND_API.G_MISS_NUM
203: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
204: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
205: , default_shipping_org NUMBER := FND_API.G_MISS_NUM
206: , ship_model_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
207: , build_in_wip_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
208: , bom_item_type NUMBER := FND_API.G_MISS_NUM
201: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
202: , organization_id NUMBER := FND_API.G_MISS_NUM
203: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
204: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
205: , default_shipping_org NUMBER := FND_API.G_MISS_NUM
206: , ship_model_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
207: , build_in_wip_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
208: , bom_item_type NUMBER := FND_API.G_MISS_NUM
209: , replenish_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
202: , organization_id NUMBER := FND_API.G_MISS_NUM
203: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
204: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
205: , default_shipping_org NUMBER := FND_API.G_MISS_NUM
206: , ship_model_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
207: , build_in_wip_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
208: , bom_item_type NUMBER := FND_API.G_MISS_NUM
209: , replenish_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
210: , primary_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
203: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
204: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
205: , default_shipping_org NUMBER := FND_API.G_MISS_NUM
206: , ship_model_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
207: , build_in_wip_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
208: , bom_item_type NUMBER := FND_API.G_MISS_NUM
209: , replenish_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
210: , primary_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
211: , pick_components_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
204: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
205: , default_shipping_org NUMBER := FND_API.G_MISS_NUM
206: , ship_model_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
207: , build_in_wip_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
208: , bom_item_type NUMBER := FND_API.G_MISS_NUM
209: , replenish_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
210: , primary_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
211: , pick_components_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
212: , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
205: , default_shipping_org NUMBER := FND_API.G_MISS_NUM
206: , ship_model_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
207: , build_in_wip_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
208: , bom_item_type NUMBER := FND_API.G_MISS_NUM
209: , replenish_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
210: , primary_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
211: , pick_components_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
212: , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
213: , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
206: , ship_model_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
207: , build_in_wip_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
208: , bom_item_type NUMBER := FND_API.G_MISS_NUM
209: , replenish_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
210: , primary_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
211: , pick_components_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
212: , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
213: , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
214: --, dualum_ind NUMBER := FND_API.G_MISS_NUM --INVCONV -
207: , build_in_wip_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
208: , bom_item_type NUMBER := FND_API.G_MISS_NUM
209: , replenish_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
210: , primary_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
211: , pick_components_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
212: , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
213: , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
214: --, dualum_ind NUMBER := FND_API.G_MISS_NUM --INVCONV -
215: --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--
208: , bom_item_type NUMBER := FND_API.G_MISS_NUM
209: , replenish_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
210: , primary_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
211: , pick_components_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
212: , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
213: , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
214: --, dualum_ind NUMBER := FND_API.G_MISS_NUM --INVCONV -
215: --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--
216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -
209: , replenish_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
210: , primary_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
211: , pick_components_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
212: , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
213: , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
214: --, dualum_ind NUMBER := FND_API.G_MISS_NUM --INVCONV -
215: --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--
216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -
217: --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-
210: , primary_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
211: , pick_components_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
212: , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
213: , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
214: --, dualum_ind NUMBER := FND_API.G_MISS_NUM --INVCONV -
215: --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--
216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -
217: --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-
218: --, opm_item_id NUMBER := FND_API.G_MISS_NUM --INVCONV-
211: , pick_components_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
212: , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
213: , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
214: --, dualum_ind NUMBER := FND_API.G_MISS_NUM --INVCONV -
215: --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--
216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -
217: --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-
218: --, opm_item_id NUMBER := FND_API.G_MISS_NUM --INVCONV-
219: , process_warehouse_flag VARCHAR2(1) := FND_API.G_MISS_CHAR --OPM
212: , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
213: , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
214: --, dualum_ind NUMBER := FND_API.G_MISS_NUM --INVCONV -
215: --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--
216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -
217: --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-
218: --, opm_item_id NUMBER := FND_API.G_MISS_NUM --INVCONV-
219: , process_warehouse_flag VARCHAR2(1) := FND_API.G_MISS_CHAR --OPM
220: --, ont_pricing_qty_source NUMBER := FND_API.G_MISS_NUM --INVCONV OPM 2046190
213: , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
214: --, dualum_ind NUMBER := FND_API.G_MISS_NUM --INVCONV -
215: --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--
216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -
217: --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-
218: --, opm_item_id NUMBER := FND_API.G_MISS_NUM --INVCONV-
219: , process_warehouse_flag VARCHAR2(1) := FND_API.G_MISS_CHAR --OPM
220: --, ont_pricing_qty_source NUMBER := FND_API.G_MISS_NUM --INVCONV OPM 2046190
221: , ont_pricing_qty_source VARCHAR2(30) := FND_API.G_MISS_CHAR --INVCONV
214: --, dualum_ind NUMBER := FND_API.G_MISS_NUM --INVCONV -
215: --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--
216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -
217: --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-
218: --, opm_item_id NUMBER := FND_API.G_MISS_NUM --INVCONV-
219: , process_warehouse_flag VARCHAR2(1) := FND_API.G_MISS_CHAR --OPM
220: --, ont_pricing_qty_source NUMBER := FND_API.G_MISS_NUM --INVCONV OPM 2046190
221: , ont_pricing_qty_source VARCHAR2(30) := FND_API.G_MISS_CHAR --INVCONV
222: -- Pack J catchweight
215: --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--
216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -
217: --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-
218: --, opm_item_id NUMBER := FND_API.G_MISS_NUM --INVCONV-
219: , process_warehouse_flag VARCHAR2(1) := FND_API.G_MISS_CHAR --OPM
220: --, ont_pricing_qty_source NUMBER := FND_API.G_MISS_NUM --INVCONV OPM 2046190
221: , ont_pricing_qty_source VARCHAR2(30) := FND_API.G_MISS_CHAR --INVCONV
222: -- Pack J catchweight
223: , tracking_quantity_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -
217: --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-
218: --, opm_item_id NUMBER := FND_API.G_MISS_NUM --INVCONV-
219: , process_warehouse_flag VARCHAR2(1) := FND_API.G_MISS_CHAR --OPM
220: --, ont_pricing_qty_source NUMBER := FND_API.G_MISS_NUM --INVCONV OPM 2046190
221: , ont_pricing_qty_source VARCHAR2(30) := FND_API.G_MISS_CHAR --INVCONV
222: -- Pack J catchweight
223: , tracking_quantity_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
224: , wms_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
217: --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-
218: --, opm_item_id NUMBER := FND_API.G_MISS_NUM --INVCONV-
219: , process_warehouse_flag VARCHAR2(1) := FND_API.G_MISS_CHAR --OPM
220: --, ont_pricing_qty_source NUMBER := FND_API.G_MISS_NUM --INVCONV OPM 2046190
221: , ont_pricing_qty_source VARCHAR2(30) := FND_API.G_MISS_CHAR --INVCONV
222: -- Pack J catchweight
223: , tracking_quantity_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
224: , wms_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
225: , secondary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
219: , process_warehouse_flag VARCHAR2(1) := FND_API.G_MISS_CHAR --OPM
220: --, ont_pricing_qty_source NUMBER := FND_API.G_MISS_NUM --INVCONV OPM 2046190
221: , ont_pricing_qty_source VARCHAR2(30) := FND_API.G_MISS_CHAR --INVCONV
222: -- Pack J catchweight
223: , tracking_quantity_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
224: , wms_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
225: , secondary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
226: -- bug 4171642
227: , master_org_id NUMBER := FND_API.G_MISS_NUM
220: --, ont_pricing_qty_source NUMBER := FND_API.G_MISS_NUM --INVCONV OPM 2046190
221: , ont_pricing_qty_source VARCHAR2(30) := FND_API.G_MISS_CHAR --INVCONV
222: -- Pack J catchweight
223: , tracking_quantity_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
224: , wms_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
225: , secondary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
226: -- bug 4171642
227: , master_org_id NUMBER := FND_API.G_MISS_NUM
228: , customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
221: , ont_pricing_qty_source VARCHAR2(30) := FND_API.G_MISS_CHAR --INVCONV
222: -- Pack J catchweight
223: , tracking_quantity_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
224: , wms_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
225: , secondary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
226: -- bug 4171642
227: , master_org_id NUMBER := FND_API.G_MISS_NUM
228: , customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
229: , internal_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
223: , tracking_quantity_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
224: , wms_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
225: , secondary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
226: -- bug 4171642
227: , master_org_id NUMBER := FND_API.G_MISS_NUM
228: , customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
229: , internal_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
230: , returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
231: , restrict_subinventories_code NUMBER := FND_API.G_MISS_NUM
224: , wms_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
225: , secondary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
226: -- bug 4171642
227: , master_org_id NUMBER := FND_API.G_MISS_NUM
228: , customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
229: , internal_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
230: , returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
231: , restrict_subinventories_code NUMBER := FND_API.G_MISS_NUM
232: , indivisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
225: , secondary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
226: -- bug 4171642
227: , master_org_id NUMBER := FND_API.G_MISS_NUM
228: , customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
229: , internal_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
230: , returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
231: , restrict_subinventories_code NUMBER := FND_API.G_MISS_NUM
232: , indivisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
233: -- bug 4171642
226: -- bug 4171642
227: , master_org_id NUMBER := FND_API.G_MISS_NUM
228: , customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
229: , internal_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
230: , returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
231: , restrict_subinventories_code NUMBER := FND_API.G_MISS_NUM
232: , indivisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
233: -- bug 4171642
234:
227: , master_org_id NUMBER := FND_API.G_MISS_NUM
228: , customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
229: , internal_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
230: , returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
231: , restrict_subinventories_code NUMBER := FND_API.G_MISS_NUM
232: , indivisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
233: -- bug 4171642
234:
235: -- INVCONV start
228: , customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
229: , internal_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
230: , returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
231: , restrict_subinventories_code NUMBER := FND_API.G_MISS_NUM
232: , indivisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
233: -- bug 4171642
234:
235: -- INVCONV start
236: , secondary_default_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
232: , indivisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
233: -- bug 4171642
234:
235: -- INVCONV start
236: , secondary_default_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
237: , lot_divisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
238: , grade_control_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
239: , lot_control_code NUMBER := FND_API.G_MISS_NUM
240: -- INVCONV end
233: -- bug 4171642
234:
235: -- INVCONV start
236: , secondary_default_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
237: , lot_divisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
238: , grade_control_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
239: , lot_control_code NUMBER := FND_API.G_MISS_NUM
240: -- INVCONV end
241: -- sol_ord_er #16014165
234:
235: -- INVCONV start
236: , secondary_default_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
237: , lot_divisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
238: , grade_control_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
239: , lot_control_code NUMBER := FND_API.G_MISS_NUM
240: -- INVCONV end
241: -- sol_ord_er #16014165
242: , contract_item_type_code varchar2(100) := FND_API.G_MISS_CHAR
235: -- INVCONV start
236: , secondary_default_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
237: , lot_divisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
238: , grade_control_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
239: , lot_control_code NUMBER := FND_API.G_MISS_NUM
240: -- INVCONV end
241: -- sol_ord_er #16014165
242: , contract_item_type_code varchar2(100) := FND_API.G_MISS_CHAR
243:
238: , grade_control_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
239: , lot_control_code NUMBER := FND_API.G_MISS_NUM
240: -- INVCONV end
241: -- sol_ord_er #16014165
242: , contract_item_type_code varchar2(100) := FND_API.G_MISS_CHAR
243:
244: );
245:
246:
246:
247: -- Item-Org record type
248:
249: TYPE Item_Cost_Rec_Type IS RECORD
250: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
251: , organization_id NUMBER := FND_API.G_MISS_NUM
252: , material_cost NUMBER := FND_API.G_MISS_NUM
253: , material_overhead_cost NUMBER := FND_API.G_MISS_NUM
254: , resource_cost NUMBER := FND_API.G_MISS_NUM
247: -- Item-Org record type
248:
249: TYPE Item_Cost_Rec_Type IS RECORD
250: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
251: , organization_id NUMBER := FND_API.G_MISS_NUM
252: , material_cost NUMBER := FND_API.G_MISS_NUM
253: , material_overhead_cost NUMBER := FND_API.G_MISS_NUM
254: , resource_cost NUMBER := FND_API.G_MISS_NUM
255: , outside_processing_cost NUMBER := FND_API.G_MISS_NUM
248:
249: TYPE Item_Cost_Rec_Type IS RECORD
250: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
251: , organization_id NUMBER := FND_API.G_MISS_NUM
252: , material_cost NUMBER := FND_API.G_MISS_NUM
253: , material_overhead_cost NUMBER := FND_API.G_MISS_NUM
254: , resource_cost NUMBER := FND_API.G_MISS_NUM
255: , outside_processing_cost NUMBER := FND_API.G_MISS_NUM
256: , overhead_cost NUMBER := FND_API.G_MISS_NUM
249: TYPE Item_Cost_Rec_Type IS RECORD
250: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
251: , organization_id NUMBER := FND_API.G_MISS_NUM
252: , material_cost NUMBER := FND_API.G_MISS_NUM
253: , material_overhead_cost NUMBER := FND_API.G_MISS_NUM
254: , resource_cost NUMBER := FND_API.G_MISS_NUM
255: , outside_processing_cost NUMBER := FND_API.G_MISS_NUM
256: , overhead_cost NUMBER := FND_API.G_MISS_NUM
257: );
250: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
251: , organization_id NUMBER := FND_API.G_MISS_NUM
252: , material_cost NUMBER := FND_API.G_MISS_NUM
253: , material_overhead_cost NUMBER := FND_API.G_MISS_NUM
254: , resource_cost NUMBER := FND_API.G_MISS_NUM
255: , outside_processing_cost NUMBER := FND_API.G_MISS_NUM
256: , overhead_cost NUMBER := FND_API.G_MISS_NUM
257: );
258:
251: , organization_id NUMBER := FND_API.G_MISS_NUM
252: , material_cost NUMBER := FND_API.G_MISS_NUM
253: , material_overhead_cost NUMBER := FND_API.G_MISS_NUM
254: , resource_cost NUMBER := FND_API.G_MISS_NUM
255: , outside_processing_cost NUMBER := FND_API.G_MISS_NUM
256: , overhead_cost NUMBER := FND_API.G_MISS_NUM
257: );
258:
259:
252: , material_cost NUMBER := FND_API.G_MISS_NUM
253: , material_overhead_cost NUMBER := FND_API.G_MISS_NUM
254: , resource_cost NUMBER := FND_API.G_MISS_NUM
255: , outside_processing_cost NUMBER := FND_API.G_MISS_NUM
256: , overhead_cost NUMBER := FND_API.G_MISS_NUM
257: );
258:
259:
260: TYPE Discount_Rec_Type IS RECORD
258:
259:
260: TYPE Discount_Rec_Type IS RECORD
261: (
262: adjustment_name VARCHAR2(200) := fnd_api.g_miss_char,
263: discount_id NUMBER := fnd_api.g_miss_num,
264: discount_line_id NUMBER := fnd_api.g_miss_num,
265: percent NUMBER := fnd_api.g_miss_num,
266: amount NUMBER := fnd_api.g_miss_num,
259:
260: TYPE Discount_Rec_Type IS RECORD
261: (
262: adjustment_name VARCHAR2(200) := fnd_api.g_miss_char,
263: discount_id NUMBER := fnd_api.g_miss_num,
264: discount_line_id NUMBER := fnd_api.g_miss_num,
265: percent NUMBER := fnd_api.g_miss_num,
266: amount NUMBER := fnd_api.g_miss_num,
267: price_adjustment_id NUMBER := fnd_api.g_miss_num
260: TYPE Discount_Rec_Type IS RECORD
261: (
262: adjustment_name VARCHAR2(200) := fnd_api.g_miss_char,
263: discount_id NUMBER := fnd_api.g_miss_num,
264: discount_line_id NUMBER := fnd_api.g_miss_num,
265: percent NUMBER := fnd_api.g_miss_num,
266: amount NUMBER := fnd_api.g_miss_num,
267: price_adjustment_id NUMBER := fnd_api.g_miss_num
268: );
261: (
262: adjustment_name VARCHAR2(200) := fnd_api.g_miss_char,
263: discount_id NUMBER := fnd_api.g_miss_num,
264: discount_line_id NUMBER := fnd_api.g_miss_num,
265: percent NUMBER := fnd_api.g_miss_num,
266: amount NUMBER := fnd_api.g_miss_num,
267: price_adjustment_id NUMBER := fnd_api.g_miss_num
268: );
269:
262: adjustment_name VARCHAR2(200) := fnd_api.g_miss_char,
263: discount_id NUMBER := fnd_api.g_miss_num,
264: discount_line_id NUMBER := fnd_api.g_miss_num,
265: percent NUMBER := fnd_api.g_miss_num,
266: amount NUMBER := fnd_api.g_miss_num,
267: price_adjustment_id NUMBER := fnd_api.g_miss_num
268: );
269:
270:
263: discount_id NUMBER := fnd_api.g_miss_num,
264: discount_line_id NUMBER := fnd_api.g_miss_num,
265: percent NUMBER := fnd_api.g_miss_num,
266: amount NUMBER := fnd_api.g_miss_num,
267: price_adjustment_id NUMBER := fnd_api.g_miss_num
268: );
269:
270:
271: TYPE Set_Rec_Type IS RECORD
269:
270:
271: TYPE Set_Rec_Type IS RECORD
272: (
273: SET_ID NUMBER := fnd_api.g_miss_num
274: , SET_NAME VARCHAR2(30) := fnd_api.g_miss_char
275: , SET_TYPE VARCHAR2(30) := fnd_api.g_miss_char
276: , Header_Id NUMBER := fnd_api.g_miss_num
277: , Ship_from_org_id NUMBER := fnd_api.g_miss_num
270:
271: TYPE Set_Rec_Type IS RECORD
272: (
273: SET_ID NUMBER := fnd_api.g_miss_num
274: , SET_NAME VARCHAR2(30) := fnd_api.g_miss_char
275: , SET_TYPE VARCHAR2(30) := fnd_api.g_miss_char
276: , Header_Id NUMBER := fnd_api.g_miss_num
277: , Ship_from_org_id NUMBER := fnd_api.g_miss_num
278: , Ship_to_org_id NUMBER := fnd_api.g_miss_num
271: TYPE Set_Rec_Type IS RECORD
272: (
273: SET_ID NUMBER := fnd_api.g_miss_num
274: , SET_NAME VARCHAR2(30) := fnd_api.g_miss_char
275: , SET_TYPE VARCHAR2(30) := fnd_api.g_miss_char
276: , Header_Id NUMBER := fnd_api.g_miss_num
277: , Ship_from_org_id NUMBER := fnd_api.g_miss_num
278: , Ship_to_org_id NUMBER := fnd_api.g_miss_num
279: , Schedule_Ship_Date DATE := fnd_api.g_miss_date
272: (
273: SET_ID NUMBER := fnd_api.g_miss_num
274: , SET_NAME VARCHAR2(30) := fnd_api.g_miss_char
275: , SET_TYPE VARCHAR2(30) := fnd_api.g_miss_char
276: , Header_Id NUMBER := fnd_api.g_miss_num
277: , Ship_from_org_id NUMBER := fnd_api.g_miss_num
278: , Ship_to_org_id NUMBER := fnd_api.g_miss_num
279: , Schedule_Ship_Date DATE := fnd_api.g_miss_date
280: , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
273: SET_ID NUMBER := fnd_api.g_miss_num
274: , SET_NAME VARCHAR2(30) := fnd_api.g_miss_char
275: , SET_TYPE VARCHAR2(30) := fnd_api.g_miss_char
276: , Header_Id NUMBER := fnd_api.g_miss_num
277: , Ship_from_org_id NUMBER := fnd_api.g_miss_num
278: , Ship_to_org_id NUMBER := fnd_api.g_miss_num
279: , Schedule_Ship_Date DATE := fnd_api.g_miss_date
280: , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
281: , shipment_priority_code varchar2(30) := fnd_api.g_miss_char
274: , SET_NAME VARCHAR2(30) := fnd_api.g_miss_char
275: , SET_TYPE VARCHAR2(30) := fnd_api.g_miss_char
276: , Header_Id NUMBER := fnd_api.g_miss_num
277: , Ship_from_org_id NUMBER := fnd_api.g_miss_num
278: , Ship_to_org_id NUMBER := fnd_api.g_miss_num
279: , Schedule_Ship_Date DATE := fnd_api.g_miss_date
280: , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
281: , shipment_priority_code varchar2(30) := fnd_api.g_miss_char
282: , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char
275: , SET_TYPE VARCHAR2(30) := fnd_api.g_miss_char
276: , Header_Id NUMBER := fnd_api.g_miss_num
277: , Ship_from_org_id NUMBER := fnd_api.g_miss_num
278: , Ship_to_org_id NUMBER := fnd_api.g_miss_num
279: , Schedule_Ship_Date DATE := fnd_api.g_miss_date
280: , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
281: , shipment_priority_code varchar2(30) := fnd_api.g_miss_char
282: , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char
283: , Shipping_Method_Code VARCHAR2(30) := fnd_api.g_miss_char
276: , Header_Id NUMBER := fnd_api.g_miss_num
277: , Ship_from_org_id NUMBER := fnd_api.g_miss_num
278: , Ship_to_org_id NUMBER := fnd_api.g_miss_num
279: , Schedule_Ship_Date DATE := fnd_api.g_miss_date
280: , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
281: , shipment_priority_code varchar2(30) := fnd_api.g_miss_char
282: , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char
283: , Shipping_Method_Code VARCHAR2(30) := fnd_api.g_miss_char
284: , Set_Status VARCHAR2(1) := fnd_api.g_miss_char
277: , Ship_from_org_id NUMBER := fnd_api.g_miss_num
278: , Ship_to_org_id NUMBER := fnd_api.g_miss_num
279: , Schedule_Ship_Date DATE := fnd_api.g_miss_date
280: , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
281: , shipment_priority_code varchar2(30) := fnd_api.g_miss_char
282: , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char
283: , Shipping_Method_Code VARCHAR2(30) := fnd_api.g_miss_char
284: , Set_Status VARCHAR2(1) := fnd_api.g_miss_char
285: );
278: , Ship_to_org_id NUMBER := fnd_api.g_miss_num
279: , Schedule_Ship_Date DATE := fnd_api.g_miss_date
280: , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
281: , shipment_priority_code varchar2(30) := fnd_api.g_miss_char
282: , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char
283: , Shipping_Method_Code VARCHAR2(30) := fnd_api.g_miss_char
284: , Set_Status VARCHAR2(1) := fnd_api.g_miss_char
285: );
286:
279: , Schedule_Ship_Date DATE := fnd_api.g_miss_date
280: , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
281: , shipment_priority_code varchar2(30) := fnd_api.g_miss_char
282: , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char
283: , Shipping_Method_Code VARCHAR2(30) := fnd_api.g_miss_char
284: , Set_Status VARCHAR2(1) := fnd_api.g_miss_char
285: );
286:
287: TYPE Modifiers_Rec_Type IS RECORD
280: , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
281: , shipment_priority_code varchar2(30) := fnd_api.g_miss_char
282: , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char
283: , Shipping_Method_Code VARCHAR2(30) := fnd_api.g_miss_char
284: , Set_Status VARCHAR2(1) := fnd_api.g_miss_char
285: );
286:
287: TYPE Modifiers_Rec_Type IS RECORD
288: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
284: , Set_Status VARCHAR2(1) := fnd_api.g_miss_char
285: );
286:
287: TYPE Modifiers_Rec_Type IS RECORD
288: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
289: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
290: , base_qty NUMBER := FND_API.G_MISS_NUM
291: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
292: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
285: );
286:
287: TYPE Modifiers_Rec_Type IS RECORD
288: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
289: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
290: , base_qty NUMBER := FND_API.G_MISS_NUM
291: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
292: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
293: , list_header_id NUMBER := FND_API.G_MISS_NUM
286:
287: TYPE Modifiers_Rec_Type IS RECORD
288: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
289: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
290: , base_qty NUMBER := FND_API.G_MISS_NUM
291: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
292: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
293: , list_header_id NUMBER := FND_API.G_MISS_NUM
294: , list_line_id NUMBER := FND_API.G_MISS_NUM
287: TYPE Modifiers_Rec_Type IS RECORD
288: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
289: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
290: , base_qty NUMBER := FND_API.G_MISS_NUM
291: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
292: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
293: , list_header_id NUMBER := FND_API.G_MISS_NUM
294: , list_line_id NUMBER := FND_API.G_MISS_NUM
295: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
288: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
289: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
290: , base_qty NUMBER := FND_API.G_MISS_NUM
291: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
292: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
293: , list_header_id NUMBER := FND_API.G_MISS_NUM
294: , list_line_id NUMBER := FND_API.G_MISS_NUM
295: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
296: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
289: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
290: , base_qty NUMBER := FND_API.G_MISS_NUM
291: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
292: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
293: , list_header_id NUMBER := FND_API.G_MISS_NUM
294: , list_line_id NUMBER := FND_API.G_MISS_NUM
295: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
296: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
297: , operand NUMBER := FND_API.G_MISS_NUM
290: , base_qty NUMBER := FND_API.G_MISS_NUM
291: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
292: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
293: , list_header_id NUMBER := FND_API.G_MISS_NUM
294: , list_line_id NUMBER := FND_API.G_MISS_NUM
295: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
296: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
297: , operand NUMBER := FND_API.G_MISS_NUM
298: , organization_id NUMBER := FND_API.G_MISS_NUM
291: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
292: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
293: , list_header_id NUMBER := FND_API.G_MISS_NUM
294: , list_line_id NUMBER := FND_API.G_MISS_NUM
295: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
296: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
297: , operand NUMBER := FND_API.G_MISS_NUM
298: , organization_id NUMBER := FND_API.G_MISS_NUM
299: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
292: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
293: , list_header_id NUMBER := FND_API.G_MISS_NUM
294: , list_line_id NUMBER := FND_API.G_MISS_NUM
295: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
296: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
297: , operand NUMBER := FND_API.G_MISS_NUM
298: , organization_id NUMBER := FND_API.G_MISS_NUM
299: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
300: , percent_price NUMBER := FND_API.G_MISS_NUM
293: , list_header_id NUMBER := FND_API.G_MISS_NUM
294: , list_line_id NUMBER := FND_API.G_MISS_NUM
295: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
296: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
297: , operand NUMBER := FND_API.G_MISS_NUM
298: , organization_id NUMBER := FND_API.G_MISS_NUM
299: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
300: , percent_price NUMBER := FND_API.G_MISS_NUM
301: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
294: , list_line_id NUMBER := FND_API.G_MISS_NUM
295: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
296: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
297: , operand NUMBER := FND_API.G_MISS_NUM
298: , organization_id NUMBER := FND_API.G_MISS_NUM
299: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
300: , percent_price NUMBER := FND_API.G_MISS_NUM
301: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
302: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
295: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
296: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
297: , operand NUMBER := FND_API.G_MISS_NUM
298: , organization_id NUMBER := FND_API.G_MISS_NUM
299: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
300: , percent_price NUMBER := FND_API.G_MISS_NUM
301: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
302: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
303: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
296: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
297: , operand NUMBER := FND_API.G_MISS_NUM
298: , organization_id NUMBER := FND_API.G_MISS_NUM
299: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
300: , percent_price NUMBER := FND_API.G_MISS_NUM
301: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
302: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
303: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
297: , operand NUMBER := FND_API.G_MISS_NUM
298: , organization_id NUMBER := FND_API.G_MISS_NUM
299: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
300: , percent_price NUMBER := FND_API.G_MISS_NUM
301: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
302: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
303: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
305: , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
298: , organization_id NUMBER := FND_API.G_MISS_NUM
299: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
300: , percent_price NUMBER := FND_API.G_MISS_NUM
301: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
302: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
303: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
305: , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , related_item_id NUMBER := FND_API.G_MISS_NUM
299: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
300: , percent_price NUMBER := FND_API.G_MISS_NUM
301: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
302: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
303: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
305: , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , related_item_id NUMBER := FND_API.G_MISS_NUM
307: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
300: , percent_price NUMBER := FND_API.G_MISS_NUM
301: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
302: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
303: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
305: , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , related_item_id NUMBER := FND_API.G_MISS_NUM
307: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
308: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
301: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
302: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
303: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
305: , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , related_item_id NUMBER := FND_API.G_MISS_NUM
307: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
308: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
309: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
302: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
303: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
305: , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , related_item_id NUMBER := FND_API.G_MISS_NUM
307: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
308: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
309: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
310: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
305: , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , related_item_id NUMBER := FND_API.G_MISS_NUM
307: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
308: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
309: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
310: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
311: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
305: , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , related_item_id NUMBER := FND_API.G_MISS_NUM
307: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
308: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
309: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
310: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
311: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
312: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
305: , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , related_item_id NUMBER := FND_API.G_MISS_NUM
307: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
308: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
309: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
310: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
311: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
312: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
313: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , related_item_id NUMBER := FND_API.G_MISS_NUM
307: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
308: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
309: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
310: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
311: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
312: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
313: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
314: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
307: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
308: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
309: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
310: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
311: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
312: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
313: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
314: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
315: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
308: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
309: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
310: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
311: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
312: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
313: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
314: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
315: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
316: , product_precedence NUMBER := FND_API.G_MISS_NUM
309: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
310: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
311: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
312: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
313: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
314: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
315: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
316: , product_precedence NUMBER := FND_API.G_MISS_NUM
317: , expiration_date DATE := FND_API.G_MISS_DATE
310: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
311: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
312: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
313: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
314: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
315: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
316: , product_precedence NUMBER := FND_API.G_MISS_NUM
317: , expiration_date DATE := FND_API.G_MISS_DATE
318: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
311: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
312: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
313: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
314: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
315: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
316: , product_precedence NUMBER := FND_API.G_MISS_NUM
317: , expiration_date DATE := FND_API.G_MISS_DATE
318: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
319: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
312: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
313: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
314: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
315: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
316: , product_precedence NUMBER := FND_API.G_MISS_NUM
317: , expiration_date DATE := FND_API.G_MISS_DATE
318: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
319: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
320: , benefit_qty NUMBER := FND_API.G_MISS_NUM
313: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
314: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
315: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
316: , product_precedence NUMBER := FND_API.G_MISS_NUM
317: , expiration_date DATE := FND_API.G_MISS_DATE
318: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
319: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
320: , benefit_qty NUMBER := FND_API.G_MISS_NUM
321: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
314: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
315: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
316: , product_precedence NUMBER := FND_API.G_MISS_NUM
317: , expiration_date DATE := FND_API.G_MISS_DATE
318: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
319: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
320: , benefit_qty NUMBER := FND_API.G_MISS_NUM
321: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
322: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
315: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
316: , product_precedence NUMBER := FND_API.G_MISS_NUM
317: , expiration_date DATE := FND_API.G_MISS_DATE
318: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
319: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
320: , benefit_qty NUMBER := FND_API.G_MISS_NUM
321: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
322: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
323: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
316: , product_precedence NUMBER := FND_API.G_MISS_NUM
317: , expiration_date DATE := FND_API.G_MISS_DATE
318: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
319: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
320: , benefit_qty NUMBER := FND_API.G_MISS_NUM
321: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
322: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
323: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
317: , expiration_date DATE := FND_API.G_MISS_DATE
318: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
319: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
320: , benefit_qty NUMBER := FND_API.G_MISS_NUM
321: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
322: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
323: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: );
318: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
319: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
320: , benefit_qty NUMBER := FND_API.G_MISS_NUM
321: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
322: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
323: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: );
326:
319: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
320: , benefit_qty NUMBER := FND_API.G_MISS_NUM
321: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
322: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
323: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: );
326:
327: Type Cust_Trx_Rec_Type is Record
320: , benefit_qty NUMBER := FND_API.G_MISS_NUM
321: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
322: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
323: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: );
326:
327: Type Cust_Trx_Rec_Type is Record
328: (
325: );
326:
327: Type Cust_Trx_Rec_Type is Record
328: (
329: cust_trx_type_id Number := FND_API.G_MISS_NUM
330: , tax_calculation_flag Varchar2(1) := FND_API.G_MISS_CHAR
331: , org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
332: );
333:
326:
327: Type Cust_Trx_Rec_Type is Record
328: (
329: cust_trx_type_id Number := FND_API.G_MISS_NUM
330: , tax_calculation_flag Varchar2(1) := FND_API.G_MISS_CHAR
331: , org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
332: );
333:
334: Type Tax_Calc_Rec_Type is Record
327: Type Cust_Trx_Rec_Type is Record
328: (
329: cust_trx_type_id Number := FND_API.G_MISS_NUM
330: , tax_calculation_flag Varchar2(1) := FND_API.G_MISS_CHAR
331: , org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
332: );
333:
334: Type Tax_Calc_Rec_Type is Record
335: (
342: INDEX BY BINARY_INTEGER;
343:
344: -- begin bug 4200055
345: TYPE Payment_Term_Rec_Type IS RECORD (
346: TERM_ID Number := FND_API.G_MISS_NUM
347: ,NAME Varchar2(15) := FND_API.G_MISS_CHAR
348: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
349: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
350: );
343:
344: -- begin bug 4200055
345: TYPE Payment_Term_Rec_Type IS RECORD (
346: TERM_ID Number := FND_API.G_MISS_NUM
347: ,NAME Varchar2(15) := FND_API.G_MISS_CHAR
348: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
349: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
350: );
351:
344: -- begin bug 4200055
345: TYPE Payment_Term_Rec_Type IS RECORD (
346: TERM_ID Number := FND_API.G_MISS_NUM
347: ,NAME Varchar2(15) := FND_API.G_MISS_CHAR
348: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
349: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
350: );
351:
352: g_payment_term_rec Payment_Term_rec_type ;
345: TYPE Payment_Term_Rec_Type IS RECORD (
346: TERM_ID Number := FND_API.G_MISS_NUM
347: ,NAME Varchar2(15) := FND_API.G_MISS_CHAR
348: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
349: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
350: );
351:
352: g_payment_term_rec Payment_Term_rec_type ;
353: G_MISS_PAYMENT_TERM_REC Payment_Term_Rec_Type ;
357: RETURN Payment_Term_Rec_Type;
358:
359:
360: TYPE Salesrep_Rec_Type IS RECORD (
361: SALESREP_ID Number := FND_API.G_MISS_NUM
362: ,NAME Varchar2(240):= FND_API.G_MISS_CHAR
363: ,STATUS Varchar2(30) := FND_API.G_MISS_CHAR
364: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
365: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
358:
359:
360: TYPE Salesrep_Rec_Type IS RECORD (
361: SALESREP_ID Number := FND_API.G_MISS_NUM
362: ,NAME Varchar2(240):= FND_API.G_MISS_CHAR
363: ,STATUS Varchar2(30) := FND_API.G_MISS_CHAR
364: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
365: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
366: );
359:
360: TYPE Salesrep_Rec_Type IS RECORD (
361: SALESREP_ID Number := FND_API.G_MISS_NUM
362: ,NAME Varchar2(240):= FND_API.G_MISS_CHAR
363: ,STATUS Varchar2(30) := FND_API.G_MISS_CHAR
364: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
365: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
366: );
367:
360: TYPE Salesrep_Rec_Type IS RECORD (
361: SALESREP_ID Number := FND_API.G_MISS_NUM
362: ,NAME Varchar2(240):= FND_API.G_MISS_CHAR
363: ,STATUS Varchar2(30) := FND_API.G_MISS_CHAR
364: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
365: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
366: );
367:
368: g_salesrep_rec Salesrep_rec_type ;
361: SALESREP_ID Number := FND_API.G_MISS_NUM
362: ,NAME Varchar2(240):= FND_API.G_MISS_CHAR
363: ,STATUS Varchar2(30) := FND_API.G_MISS_CHAR
364: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
365: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
366: );
367:
368: g_salesrep_rec Salesrep_rec_type ;
369: G_MISS_SALESREP_REC Salesrep_Rec_Type ;
388: G_MISS_ITEM_REC Item_Rec_Type ;
389: G_MISS_ITEM_COST_REC Item_Cost_Rec_Type ;
390: G_MISS_DISCOUNT_REC Discount_Rec_Type ;
391: G_MISS_CUST_TRX_TYPE_REC Cust_Trx_Rec_Type ;
392: G_CUST_TRX_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM;
393:
394:
395: -- aksingh making this record visible for all apis
396: g_header_rec OE_Order_PUB.Header_Rec_Type;
497: -- both as a function and as a procedure
498: ------------------------------------------------------------
499: PROCEDURE Load_Item
500: ( p_key1 IN NUMBER
501: , p_key2 IN NUMBER := FND_API.G_MISS_NUM
502: , p_key3 IN NUMBER DEFAULT NULL
503: );
504:
505: FUNCTION Load_Item
503: );
504:
505: FUNCTION Load_Item
506: ( p_key1 IN NUMBER
507: , p_key2 IN NUMBER := FND_API.G_MISS_NUM
508: , p_key3 IN NUMBER DEFAULT NULL)
509: RETURN Item_Rec_Type;
510:
511: FUNCTION Load_Item_Cost