22: );
23:
24: TYPE PRICING_HEADER_REC_TYPE IS RECORD
25: (
26: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
23:
24: TYPE PRICING_HEADER_REC_TYPE IS RECORD
25: (
26: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
24: TYPE PRICING_HEADER_REC_TYPE IS RECORD
25: (
26: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
25: (
26: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
26: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ORG_ID NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ORG_ID NUMBER := FND_API.G_MISS_NUM,
37: QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ORG_ID NUMBER := FND_API.G_MISS_NUM,
37: QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ORG_ID NUMBER := FND_API.G_MISS_NUM,
37: QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
39: QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ORG_ID NUMBER := FND_API.G_MISS_NUM,
37: QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
39: QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
40: QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ORG_ID NUMBER := FND_API.G_MISS_NUM,
37: QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
39: QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
40: QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
41: QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ORG_ID NUMBER := FND_API.G_MISS_NUM,
37: QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
39: QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
40: QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
41: QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ORG_ID NUMBER := FND_API.G_MISS_NUM,
37: QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
39: QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
40: QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
41: QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
43: PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
36: ORG_ID NUMBER := FND_API.G_MISS_NUM,
37: QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
39: QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
40: QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
41: QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
43: PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
44: QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
39: QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
40: QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
41: QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
43: PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
44: QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
39: QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
40: QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
41: QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
43: PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
44: QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
39: QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
40: QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
41: QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
43: PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
44: QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
47: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
40: QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
41: QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
43: PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
44: QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
47: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
48: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
41: QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
43: PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
44: QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
47: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
48: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
49: ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
42: QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
43: PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
44: QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
47: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
48: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
49: ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
50: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
43: PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
44: QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
47: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
48: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
49: ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
50: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
51: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
44: QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
47: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
48: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
49: ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
50: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
51: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
52: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
45: ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
47: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
48: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
49: ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
50: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
51: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
52: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
53: ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
46: CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
47: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
48: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
49: ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
50: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
51: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
52: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
53: ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
54: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
47: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
48: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
49: ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
50: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
51: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
52: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
53: ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
54: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
55: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
48: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
49: ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
50: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
51: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
52: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
53: ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
54: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
55: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
56: QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
50: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
51: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
52: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
53: ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
54: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
55: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
56: QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: ORDERED_DATE DATE := FND_API.G_MISS_DATE,
50: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
51: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
52: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
53: ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
54: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
55: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
56: QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: ORDERED_DATE DATE := FND_API.G_MISS_DATE,
58: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
51: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
52: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
53: ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
54: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
55: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
56: QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: ORDERED_DATE DATE := FND_API.G_MISS_DATE,
58: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
59: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
52: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
53: ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
54: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
55: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
56: QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: ORDERED_DATE DATE := FND_API.G_MISS_DATE,
58: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
59: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
60: EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
53: ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
54: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
55: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
56: QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: ORDERED_DATE DATE := FND_API.G_MISS_DATE,
58: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
59: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
60: EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
61: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
54: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
55: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
56: QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: ORDERED_DATE DATE := FND_API.G_MISS_DATE,
58: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
59: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
60: EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
61: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
62: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
55: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
56: QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: ORDERED_DATE DATE := FND_API.G_MISS_DATE,
58: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
59: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
60: EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
61: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
62: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
63: TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
56: QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: ORDERED_DATE DATE := FND_API.G_MISS_DATE,
58: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
59: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
60: EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
61: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
62: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
63: TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
64: TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
57: ORDERED_DATE DATE := FND_API.G_MISS_DATE,
58: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
59: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
60: EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
61: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
62: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
63: TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
64: TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
65: TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
58: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
59: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
60: EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
61: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
62: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
63: TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
64: TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
65: TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
66: TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
59: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
60: EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
61: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
62: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
63: TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
64: TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
65: TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
66: TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
67: TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
60: EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
61: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
62: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
63: TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
64: TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
65: TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
66: TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
67: TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
68: SURCHARGE NUMBER := FND_API.G_MISS_NUM,
61: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
62: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
63: TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
64: TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
65: TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
66: TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
67: TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
68: SURCHARGE NUMBER := FND_API.G_MISS_NUM,
69: TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
62: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
63: TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
64: TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
65: TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
66: TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
67: TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
68: SURCHARGE NUMBER := FND_API.G_MISS_NUM,
69: TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
70: PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
63: TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
64: TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
65: TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
66: TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
67: TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
68: SURCHARGE NUMBER := FND_API.G_MISS_NUM,
69: TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
70: PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
71: CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
64: TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
65: TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
66: TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
67: TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
68: SURCHARGE NUMBER := FND_API.G_MISS_NUM,
69: TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
70: PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
71: CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
72: SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
66: TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
67: TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
68: SURCHARGE NUMBER := FND_API.G_MISS_NUM,
69: TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
70: PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
71: CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
72: SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ORDER_ID NUMBER := FND_API.G_MISS_NUM,
66: TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
67: TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
68: SURCHARGE NUMBER := FND_API.G_MISS_NUM,
69: TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
70: PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
71: CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
72: SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ORDER_ID NUMBER := FND_API.G_MISS_NUM,
74: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
67: TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
68: SURCHARGE NUMBER := FND_API.G_MISS_NUM,
69: TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
70: PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
71: CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
72: SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ORDER_ID NUMBER := FND_API.G_MISS_NUM,
74: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: SURCHARGE NUMBER := FND_API.G_MISS_NUM,
69: TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
70: PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
71: CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
72: SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ORDER_ID NUMBER := FND_API.G_MISS_NUM,
74: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
70: PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
71: CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
72: SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ORDER_ID NUMBER := FND_API.G_MISS_NUM,
74: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
71: CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
72: SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ORDER_ID NUMBER := FND_API.G_MISS_NUM,
74: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
72: SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ORDER_ID NUMBER := FND_API.G_MISS_NUM,
74: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ORDER_ID NUMBER := FND_API.G_MISS_NUM,
74: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ORDER_ID NUMBER := FND_API.G_MISS_NUM,
74: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
84: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
92: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
85: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
92: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
93: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
86: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
92: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
93: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
94: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
87: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
92: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
93: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
94: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
88: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
92: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
93: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
94: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
96: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
92: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
93: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
94: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
96: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
90: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
92: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
93: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
94: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
96: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
98: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
92: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
93: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
94: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
96: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
98: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
93: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
94: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
96: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
98: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
94: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
96: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
98: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
96: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
98: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
95: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
96: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
98: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
96: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
98: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: EXCHANGE_TYPE_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
97: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
98: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: EXCHANGE_TYPE_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
105: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
98: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: EXCHANGE_TYPE_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
105: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
106: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
99: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: EXCHANGE_TYPE_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
105: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
106: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
107: MINISITE_ID NUMBER := FND_API.G_MISS_NUM
100: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: EXCHANGE_TYPE_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
105: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
106: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
107: MINISITE_ID NUMBER := FND_API.G_MISS_NUM
108: );
101: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: EXCHANGE_TYPE_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
105: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
106: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
107: MINISITE_ID NUMBER := FND_API.G_MISS_NUM
108: );
109:
102: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: EXCHANGE_TYPE_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
105: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
106: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
107: MINISITE_ID NUMBER := FND_API.G_MISS_NUM
108: );
109:
110: G_HEADER_REC PRICING_HEADER_REC_TYPE;
103: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: EXCHANGE_TYPE_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
105: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
106: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
107: MINISITE_ID NUMBER := FND_API.G_MISS_NUM
108: );
109:
110: G_HEADER_REC PRICING_HEADER_REC_TYPE;
111:
111:
112:
113: TYPE PRICING_LINE_REC_TYPE IS RECORD
114: (
115: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
116: CREATION_DATE DATE := FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
112:
113: TYPE PRICING_LINE_REC_TYPE IS RECORD
114: (
115: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
116: CREATION_DATE DATE := FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
113: TYPE PRICING_LINE_REC_TYPE IS RECORD
114: (
115: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
116: CREATION_DATE DATE := FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
121: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
114: (
115: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
116: CREATION_DATE DATE := FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
121: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
122: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
115: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
116: CREATION_DATE DATE := FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
121: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
122: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
123: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
116: CREATION_DATE DATE := FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
121: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
122: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
123: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
124: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
121: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
122: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
123: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
124: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
125: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
121: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
122: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
123: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
124: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
125: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM,
119: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
121: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
122: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
123: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
124: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
125: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM,
127: LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
121: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
122: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
123: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
124: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
125: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM,
127: LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
122: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
123: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
124: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
125: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM,
127: LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
122: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
123: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
124: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
125: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM,
127: LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
130: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
123: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
124: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
125: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM,
127: LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
130: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
131: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
124: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
125: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM,
127: LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
130: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
131: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
132: ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
125: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM,
127: LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
130: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
131: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
132: ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
133: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM,
127: LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
130: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
131: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
132: ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
133: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
134: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
127: LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
130: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
131: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
132: ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
133: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
134: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
135: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
128: ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
130: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
131: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
132: ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
133: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
134: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
135: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
136: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
129: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
130: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
131: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
132: ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
133: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
134: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
135: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
136: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
137: QUANTITY NUMBER := FND_API.G_MISS_NUM,
130: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
131: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
132: ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
133: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
134: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
135: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
136: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
137: QUANTITY NUMBER := FND_API.G_MISS_NUM,
138: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
131: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
132: ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
133: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
134: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
135: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
136: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
137: QUANTITY NUMBER := FND_API.G_MISS_NUM,
138: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
139: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
132: ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
133: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
134: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
135: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
136: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
137: QUANTITY NUMBER := FND_API.G_MISS_NUM,
138: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
139: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
140: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
133: INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
134: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
135: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
136: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
137: QUANTITY NUMBER := FND_API.G_MISS_NUM,
138: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
139: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
140: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
141: PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
134: INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
135: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
136: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
137: QUANTITY NUMBER := FND_API.G_MISS_NUM,
138: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
139: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
140: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
141: PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
142: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
135: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
136: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
137: QUANTITY NUMBER := FND_API.G_MISS_NUM,
138: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
139: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
140: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
141: PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
142: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
143: LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
136: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
137: QUANTITY NUMBER := FND_API.G_MISS_NUM,
138: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
139: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
140: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
141: PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
142: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
143: LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
144: LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
137: QUANTITY NUMBER := FND_API.G_MISS_NUM,
138: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
139: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
140: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
141: PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
142: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
143: LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
144: LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
145: LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
138: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
139: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
140: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
141: PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
142: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
143: LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
144: LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
145: LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
146: LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
139: MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
140: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
141: PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
142: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
143: LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
144: LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
145: LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
146: LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
147: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
140: PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
141: PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
142: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
143: LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
144: LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
145: LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
146: LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
147: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
148: ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
141: PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
142: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
143: LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
144: LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
145: LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
146: LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
147: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
148: ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
149: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
142: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
143: LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
144: LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
145: LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
146: LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
147: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
148: ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
149: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
150: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
143: LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
144: LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
145: LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
146: LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
147: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
148: ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
149: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
150: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
151: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
144: LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
145: LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
146: LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
147: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
148: ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
149: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
150: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
151: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
152: SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
145: LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
146: LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
147: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
148: ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
149: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
150: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
151: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
152: SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
146: LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
147: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
148: ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
149: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
150: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
151: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
152: SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
147: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
148: ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
149: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
150: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
151: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
152: SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
149: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
150: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
151: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
152: SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
149: ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
150: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
151: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
152: SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
150: INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
151: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
152: SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
151: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
152: SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
152: SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
153: BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
154: PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
171: CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
164: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
171: CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
172: CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
165: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
171: CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
172: CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
173: COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
171: CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
172: CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
173: COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
174: VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
171: CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
172: CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
173: COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
174: VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
175: COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
171: CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
172: CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
173: COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
174: VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
175: COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
176: SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
171: CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
172: CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
173: COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
174: VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
175: COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
176: SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
177: SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
170: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
171: CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
172: CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
173: COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
174: VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
175: COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
176: SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
177: SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
178: SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
171: CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
172: CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
173: COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
174: VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
175: COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
176: SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
177: SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
178: SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
179: SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
172: CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
173: COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
174: VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
175: COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
176: SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
177: SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
178: SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
179: SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
180: SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
173: COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
174: VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
175: COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
176: SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
177: SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
178: SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
179: SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
180: SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
181: SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
174: VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
175: COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
176: SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
177: SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
178: SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
179: SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
180: SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
181: SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
182: UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
175: COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
176: SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
177: SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
178: SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
179: SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
180: SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
181: SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
182: UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
183: SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
176: SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
177: SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
178: SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
179: SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
180: SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
181: SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
182: UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
183: SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
184: SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
177: SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
178: SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
179: SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
180: SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
181: SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
182: UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
183: SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
184: SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
185: SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
178: SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
179: SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
180: SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
181: SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
182: UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
183: SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
184: SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
185: SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
186: SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
179: SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
180: SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
181: SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
182: UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
183: SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
184: SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
185: SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
186: SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
187: SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
180: SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
181: SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
182: UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
183: SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
184: SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
185: SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
186: SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
187: SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
188: SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
181: SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
182: UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
183: SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
184: SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
185: SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
186: SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
187: SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
188: SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
189: SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
182: UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
183: SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
184: SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
185: SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
186: SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
187: SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
188: SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
189: SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
190: RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
183: SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
184: SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
185: SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
186: SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
187: SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
188: SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
189: SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
190: RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
191: RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
184: SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
185: SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
186: SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
187: SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
188: SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
189: SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
190: RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
191: RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
192: RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
185: SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
186: SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
187: SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
188: SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
189: SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
190: RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
191: RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
192: RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
193: RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
186: SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
187: SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
188: SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
189: SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
190: RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
191: RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
192: RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
193: RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
194: RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
187: SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
188: SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
189: SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
190: RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
191: RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
192: RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
193: RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
194: RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
195: RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
188: SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
189: SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
190: RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
191: RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
192: RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
193: RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
194: RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
195: RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
196: RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
189: SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
190: RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
191: RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
192: RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
193: RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
194: RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
195: RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
196: RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
197: RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
190: RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
191: RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
192: RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
193: RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
194: RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
195: RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
196: RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
197: RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
191: RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
192: RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
193: RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
194: RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
195: RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
196: RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
197: RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199: RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
192: RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
193: RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
194: RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
195: RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
196: RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
197: RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199: RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200: RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
193: RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
194: RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
195: RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
196: RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
197: RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199: RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200: RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201: RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
194: RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
195: RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
196: RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
197: RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199: RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200: RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201: RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202: RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
195: RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
196: RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
197: RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199: RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200: RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201: RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202: RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203: RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
196: RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
197: RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199: RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200: RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201: RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202: RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203: RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204: RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
197: RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199: RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200: RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201: RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202: RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203: RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204: RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199: RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200: RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201: RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202: RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203: RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204: RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206: RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199: RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200: RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201: RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202: RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203: RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204: RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206: RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207: RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200: RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201: RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202: RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203: RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204: RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206: RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207: RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202: RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203: RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204: RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206: RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207: RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
202: RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203: RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204: RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206: RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207: RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
210: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
203: RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204: RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206: RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207: RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
210: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
211: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
204: RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206: RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207: RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
210: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
211: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
212: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
205: RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206: RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207: RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
210: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
211: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
212: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
213: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
206: RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207: RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
210: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
211: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
212: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
213: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
214: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
207: RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
210: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
211: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
212: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
213: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
214: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
215: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
208: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
210: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
211: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
212: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
213: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
214: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
215: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
216: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
209: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
210: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
211: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
212: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
213: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
214: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
215: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
216: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
217: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
210: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
211: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
212: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
213: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
214: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
215: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
216: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
217: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
218: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
211: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
212: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
213: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
214: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
215: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
216: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
217: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
218: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
219: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
212: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
213: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
214: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
215: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
216: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
217: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
218: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
219: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
213: SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
214: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
215: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
216: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
217: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
218: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
219: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
221: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
214: SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
215: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
216: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
217: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
218: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
219: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
221: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
222: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
215: SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
216: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
217: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
218: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
219: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
221: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
222: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
223: SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
216: SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
217: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
218: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
219: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
221: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
222: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
223: SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
224: RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
217: SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
218: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
219: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
221: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
222: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
223: SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
224: RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
225: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
218: FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
219: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
221: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
222: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
223: SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
224: RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
225: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
226: SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
219: FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
221: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
222: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
223: SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
224: RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
225: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
226: SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
227: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
220: FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
221: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
222: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
223: SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
224: RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
225: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
226: SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
227: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
228: INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
221: SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
222: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
223: SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
224: RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
225: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
226: SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
227: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
228: INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
229: SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
222: PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
223: SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
224: RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
225: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
226: SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
227: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
228: INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
229: SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
230: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
223: SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
224: RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
225: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
226: SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
227: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
228: INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
229: SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
230: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
231: AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
224: RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
225: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
226: SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
227: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
228: INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
229: SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
230: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
231: AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
232: MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
225: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
226: SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
227: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
228: INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
229: SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
230: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
231: AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
232: MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
233: CHARGE_PERIODICITY_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
226: SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
227: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
228: INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
229: SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
230: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
231: AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
232: MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
233: CHARGE_PERIODICITY_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
234: PRICING_QUANTITY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
227: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
228: INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
229: SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
230: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
231: AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
232: MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
233: CHARGE_PERIODICITY_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
234: PRICING_QUANTITY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
235: PRICING_QUANTITY NUMBER := FND_API.G_MISS_NUM
228: INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
229: SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
230: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
231: AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
232: MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
233: CHARGE_PERIODICITY_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
234: PRICING_QUANTITY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
235: PRICING_QUANTITY NUMBER := FND_API.G_MISS_NUM
236: );
229: SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
230: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
231: AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
232: MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
233: CHARGE_PERIODICITY_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
234: PRICING_QUANTITY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
235: PRICING_QUANTITY NUMBER := FND_API.G_MISS_NUM
236: );
237:
230: RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
231: AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
232: MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
233: CHARGE_PERIODICITY_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
234: PRICING_QUANTITY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
235: PRICING_QUANTITY NUMBER := FND_API.G_MISS_NUM
236: );
237:
238: G_LINE_REC PRICING_LINE_REC_TYPE;
231: AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
232: MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
233: CHARGE_PERIODICITY_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
234: PRICING_QUANTITY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
235: PRICING_QUANTITY NUMBER := FND_API.G_MISS_NUM
236: );
237:
238: G_LINE_REC PRICING_LINE_REC_TYPE;
239:
310: -- kchervel end
311:
312: PROCEDURE Pricing_Item (
313: P_Api_Version_Number IN NUMBER,
314: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
315: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_control_rec IN PRICING_CONTROL_REC_TYPE,
317: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
318: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
311:
312: PROCEDURE Pricing_Item (
313: P_Api_Version_Number IN NUMBER,
314: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
315: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_control_rec IN PRICING_CONTROL_REC_TYPE,
317: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
318: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
319: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
336: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
337:
338: PROCEDURE Pricing_Order(
339: P_Api_Version_Number IN NUMBER,
340: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
341: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
342: p_control_rec IN PRICING_CONTROL_REC_TYPE,
343: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
344: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
337:
338: PROCEDURE Pricing_Order(
339: P_Api_Version_Number IN NUMBER,
340: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
341: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
342: p_control_rec IN PRICING_CONTROL_REC_TYPE,
343: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
344: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
345: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
365: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
366:
367: PROCEDURE Pricing_Item (
368: P_Api_Version_Number IN NUMBER,
369: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
370: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_control_rec IN PRICING_CONTROL_REC_TYPE,
372: p_qte_line_id IN NUMBER,
373: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
366:
367: PROCEDURE Pricing_Item (
368: P_Api_Version_Number IN NUMBER,
369: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
370: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_control_rec IN PRICING_CONTROL_REC_TYPE,
372: p_qte_line_id IN NUMBER,
373: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
374: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
375: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
376:
377: PROCEDURE Pricing_Order (
378: P_Api_Version_Number IN NUMBER,
379: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
380: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
381: p_control_rec IN PRICING_CONTROL_REC_TYPE,
382: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
383: p_qte_header_id IN NUMBER,
376:
377: PROCEDURE Pricing_Order (
378: P_Api_Version_Number IN NUMBER,
379: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
380: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
381: p_control_rec IN PRICING_CONTROL_REC_TYPE,
382: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
383: p_qte_header_id IN NUMBER,
384: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
386: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
387:
388: Procedure Delete_Promotion (
389: P_Api_Version_Number IN NUMBER,
390: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
391: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
392: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
393: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
394: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
387:
388: Procedure Delete_Promotion (
389: P_Api_Version_Number IN NUMBER,
390: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
391: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
392: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
393: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
394: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
395: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);