APPS.OE_ORDER_CACHE dependencies on FND_API

Line 16: ( order_type_id NUMBER := FND_API.G_MISS_NUM

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

Line 17: , name VARCHAR2(80) := FND_API.G_MISS_CHAR

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

Line 18: , cust_trx_type_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

Line 19: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM

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

Line 20: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM

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

Line 21: , price_list_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
25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 22: , shipment_priority_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

Line 23: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 24: , fob_point_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

Line 25: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 26: , ship_from_org_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
30: , require_po_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 27: , agreement_type_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
31: , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 28: , order_number_source_id NUMBER := FND_API.G_MISS_NUM

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

Line 29: , agreement_required_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

Line 30: , require_po_flag VARCHAR2(1) := 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
34: , quote_num_as_ord_num_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 31: , enforce_line_prices_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

Line 32: , auto_scheduling_flag VARCHAR2(1) := 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
36: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM

Line 34: , quote_num_as_ord_num_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
37: -- bug 4200055
38: , start_date_active DATE := FND_API.G_MISS_DATE

Line 35: , invoice_source_id NUMBER := FND_API.G_MISS_NUM

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

Line 36: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM

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

Line 38: , start_date_active DATE := FND_API.G_MISS_DATE

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:

Line 39: , end_date_active DATE := FND_API.G_MISS_DATE

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(

Line 40: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 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

Line 45: , invoice_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

Line 46: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

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

Line 47: , ship_from_org_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

Line 48: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM

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

Line 49: , tax_date DATE := fnd_api.g_miss_date

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

Line 50: , trx_type_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
54: , vat_tax_id NUMBER := FND_API.G_MISS_NUM

Line 51: , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR

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

Line 52: , tax_exempt_number VARCHAR2(80) := 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

Line 53: , tax_exempt_reason_code VARCHAR2(80) := 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: );

Line 54: , vat_tax_id NUMBER := FND_API.G_MISS_NUM

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:

Line 55: , amt_incl_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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;

Line 56: , amt_incl_tax_override VARCHAR2(1) := 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;
60: g_TAX_EXEMPTION_CACH Tax_Code_Cach;

Line 66: ( Line_Type_id NUMBER := FND_API.G_MISS_NUM

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

Line 67: , name VARCHAR2(80) := FND_API.G_MISS_CHAR

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

Line 68: , cust_trx_type_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

Line 69: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM

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

Line 70: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM

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

Line 71: , price_list_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
75: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 72: , shipment_priority_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

Line 73: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 74: , fob_point_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

Line 75: , freight_terms_code VARCHAR2(30) := 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

Line 76: , ship_from_org_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
80: , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 77: , agreement_type_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
81: , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 78: , agreement_required_flag VARCHAR2(1) := 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

Line 79: , enforce_line_prices_flag VARCHAR2(1) := 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

Line 80: , calculate_tax_flag VARCHAR2(1) := 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
84: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM

Line 81: , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 82: , ship_source_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
86: , start_date_active DATE := FND_API.G_MISS_DATE

Line 83: , invoice_source_id NUMBER := FND_API.G_MISS_NUM

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

Line 84: , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM

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

Line 86: , start_date_active DATE := FND_API.G_MISS_DATE

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:

Line 87: , end_date_active DATE := FND_API.G_MISS_DATE

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.

Line 88: , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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:

Line 94: ( agreement_id NUMBER := FND_API.G_MISS_NUM

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

Line 95: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM

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

Line 96: , accounting_rule_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

Line 97: , price_list_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

Line 98: , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR

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

Line 99: , payment_term_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
103: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM

Line 100: , invoice_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: );

Line 101: , invoice_to_contact_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: );
105:

Line 102: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 103: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM

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:

Line 109: ( org_id NUMBER := FND_API.G_MISS_NUM

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

Line 110: , price_list_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

Line 111: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 112: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 113: , sold_from_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

Line 114: , ship_from_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
118: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 115: , payment_term_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
119: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 116: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM

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: );

Line 117: , contact_id NUMBER := FND_API.G_MISS_NUM

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:

Line 118: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 119: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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:

Line 125: ( org_id NUMBER := FND_API.G_MISS_NUM

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

Line 126: , price_list_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

Line 127: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 128: , freight_terms_code VARCHAR2(30) := 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

Line 129: , payment_term_id NUMBER := FND_API.G_MISS_NUM

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

Line 130: , contact_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
134: , status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 131: , ship_partial_allowed 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

Line 132: , shipping_method_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
136: , start_date_active DATE := FND_API.G_MISS_DATE

Line 134: , status VARCHAR2(1) := FND_API.G_MISS_CHAR

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: );

Line 135: , address_status VARCHAR2(1) := FND_API.G_MISS_CHAR

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:

Line 136: , start_date_active DATE := FND_API.G_MISS_DATE

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

Line 137: , end_date_active DATE := FND_API.G_MISS_DATE

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:

Line 143: ( org_id NUMBER := FND_API.G_MISS_NUM

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

Line 144: , price_list_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

Line 145: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 146: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 147: , sold_from_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

Line 148: , ship_from_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
152: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 149: , payment_term_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
153: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 150: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM

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: );

Line 151: , contact_id NUMBER := FND_API.G_MISS_NUM

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:

Line 152: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 153: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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:

Line 159: ( org_id NUMBER := FND_API.G_MISS_NUM

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

Line 160: , price_list_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

Line 161: , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 162: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 163: , payment_term_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

Line 164: , ship_to_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
168: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 165: , deliver_to_org_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
169: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 166: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM

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

Line 167: , contact_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

Line 168: , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR

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: );

Line 169: , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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:

Line 170: , order_type_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:
174: -- Price List record type

Line 171: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes

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:

Line 177: ( price_list_id NUMBER := FND_API.G_MISS_NUM

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

Line 178: , freight_terms_code VARCHAR2(30) := 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

Line 179: , payment_term_id NUMBER := FND_API.G_MISS_NUM

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

Line 180: , ship_method_code VARCHAR2(30) := 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

Line 181: , currency_code VARCHAR2(15) := 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

Line 183: , name VARCHAR2(240) := 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

Line 184: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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: );

Line 185: , active_flag VARCHAR2(1) := 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: );
189:

Line 186: , start_date_active DATE := FND_API.G_MISS_DATE

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

Line 187: , end_date_active DATE := FND_API.G_MISS_DATE

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:

Line 193: ( set_of_books_id NUMBER := FND_API.G_MISS_NUM

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

Line 194: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR

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

Line 201: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM

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

Line 202: , organization_id 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

Line 203: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM

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

Line 204: , accounting_rule_id NUMBER := FND_API.G_MISS_NUM

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

Line 205: , default_shipping_org 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

Line 206: , ship_model_complete_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

Line 207: , build_in_wip_flag VARCHAR2(1) := 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

Line 208: , bom_item_type 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
212: , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 209: , replenish_to_order_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

Line 210: , primary_uom_code VARCHAR2(30) := 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 -

Line 211: , pick_components_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 -
215: --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--

Line 212: , shippable_item_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--
216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -

Line 213: , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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-

Line 214: --, dualum_ind NUMBER := FND_API.G_MISS_NUM --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-

Line 215: --, grade_ctl 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

Line 216: --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -

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

Line 217: --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-

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

Line 218: --, opm_item_id NUMBER := FND_API.G_MISS_NUM --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

Line 219: , process_warehouse_flag VARCHAR2(1) := FND_API.G_MISS_CHAR --OPM

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

Line 220: --, ont_pricing_qty_source NUMBER := FND_API.G_MISS_NUM --INVCONV OPM 2046190

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

Line 221: , ont_pricing_qty_source VARCHAR2(30) := 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
225: , secondary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 223: , tracking_quantity_ind VARCHAR2(30) := 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

Line 224: , wms_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 225: , secondary_uom_code VARCHAR2(3) := 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

Line 227: , master_org_id NUMBER := FND_API.G_MISS_NUM

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

Line 228: , customer_order_enabled_flag VARCHAR2(1) := 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
232: , indivisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 229: , internal_order_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
233: -- bug 4171642

Line 230: , returnable_flag VARCHAR2(1) := 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
234:

Line 231: , restrict_subinventories_code NUMBER := FND_API.G_MISS_NUM

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

Line 232: , indivisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 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

Line 237: , lot_divisible_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
241: -- sol_ord_er #16014165

Line 238: , grade_control_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 239: , lot_control_code NUMBER := FND_API.G_MISS_NUM

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:

Line 242: , contract_item_type_code varchar2(100) := 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:
244: );
245:
246:

Line 250: ( inventory_item_id NUMBER := FND_API.G_MISS_NUM

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

Line 251: , organization_id 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

Line 252: , material_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

Line 253: , material_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: );

Line 254: , resource_cost NUMBER := FND_API.G_MISS_NUM

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:

Line 255: , outside_processing_cost 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:
259:

Line 256: , overhead_cost 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:
260: TYPE Discount_Rec_Type IS RECORD

Line 262: adjustment_name VARCHAR2(200) := fnd_api.g_miss_char,

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,

Line 263: discount_id 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

Line 264: discount_line_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: );

Line 265: percent NUMBER := fnd_api.g_miss_num,

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:

Line 266: amount NUMBER := fnd_api.g_miss_num,

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:

Line 267: price_adjustment_id NUMBER := fnd_api.g_miss_num

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

Line 273: SET_ID NUMBER := fnd_api.g_miss_num

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

Line 274: , SET_NAME VARCHAR2(30) := fnd_api.g_miss_char

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

Line 275: , SET_TYPE VARCHAR2(30) := fnd_api.g_miss_char

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

Line 276: , Header_Id NUMBER := fnd_api.g_miss_num

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

Line 277: , Ship_from_org_id NUMBER := fnd_api.g_miss_num

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

Line 278: , Ship_to_org_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
282: , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char

Line 279: , Schedule_Ship_Date DATE := fnd_api.g_miss_date

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

Line 280: , Schedule_Arrival_Date DATE := fnd_api.g_miss_date

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

Line 281: , shipment_priority_code varchar2(30) := 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: );

Line 282: , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char

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:

Line 283: , Shipping_Method_Code VARCHAR2(30) := fnd_api.g_miss_char

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

Line 284: , Set_Status VARCHAR2(1) := fnd_api.g_miss_char

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

Line 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

Line 289: , automatic_flag 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
293: , list_header_id NUMBER := FND_API.G_MISS_NUM

Line 290: , base_qty 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

Line 291: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

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

Line 292: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

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

Line 293: , list_header_id NUMBER := FND_API.G_MISS_NUM

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

Line 294: , list_line_id 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

Line 295: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 296: , modifier_level_code VARCHAR2(30) := 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

Line 297: , operand 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

Line 298: , organization_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
302: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM

Line 299: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 300: , percent_price NUMBER := FND_API.G_MISS_NUM

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

Line 301: , price_break_type_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
305: , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 302: , price_by_formula_id 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
306: , related_item_id NUMBER := FND_API.G_MISS_NUM

Line 303: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 304: , print_on_invoice_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
308: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 305: , rebate_transaction_type_code 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

Line 306: , related_item_id NUMBER := FND_API.G_MISS_NUM

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

Line 307: , relationship_type_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
311: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 308: , substitution_attribute VARCHAR2(30) := 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

Line 309: , substitution_context VARCHAR2(30) := 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
313: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 310: , substitution_value VARCHAR2(240) := 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

Line 311: , accrual_flag VARCHAR2(1) := 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

Line 312: , pricing_group_sequence 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

Line 313: , incompatibility_grp_code 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
317: , expiration_date DATE := FND_API.G_MISS_DATE

Line 314: , list_line_no 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
318: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 315: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM

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

Line 316: , product_precedence NUMBER := FND_API.G_MISS_NUM

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

Line 317: , expiration_date DATE := FND_API.G_MISS_DATE

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

Line 318: , charge_type_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

Line 319: , charge_subtype_code 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
323: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 320: , benefit_qty 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
324: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 321: , benefit_uom_code VARCHAR2(30) := 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: );

Line 322: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM

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:

Line 323: , proration_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:
327: Type Cust_Trx_Rec_Type is Record

Line 324: , include_on_returns_flag VARCHAR2(1) := 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
328: (

Line 329: cust_trx_type_id Number := FND_API.G_MISS_NUM

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:

Line 330: , tax_calculation_flag Varchar2(1) := FND_API.G_MISS_CHAR

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

Line 331: , org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes

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: (

Line 346: TERM_ID Number := FND_API.G_MISS_NUM

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: );

Line 347: ,NAME Varchar2(15) := FND_API.G_MISS_CHAR

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:

Line 348: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE

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 ;

Line 349: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE

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 ;

Line 361: SALESREP_ID Number := FND_API.G_MISS_NUM

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

Line 362: ,NAME Varchar2(240):= FND_API.G_MISS_CHAR

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: );

Line 363: ,STATUS Varchar2(30) := FND_API.G_MISS_CHAR

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:

Line 364: ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE

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 ;

Line 365: ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE

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 ;

Line 392: G_CUST_TRX_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM;

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;

Line 501: , p_key2 IN NUMBER := FND_API.G_MISS_NUM

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

Line 507: , p_key2 IN NUMBER := FND_API.G_MISS_NUM

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