APPS.OZF_OFFER_PVT dependencies on FND_API

Line 18: OFFER_ID NUMBER := Fnd_Api.g_miss_num

14: INDEX BY BINARY_INTEGER;
15:
16: TYPE Modifier_LIST_Rec_Type IS RECORD
17: (
18: OFFER_ID NUMBER := Fnd_Api.g_miss_num
19: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
20: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
22: ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num

Line 19: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num

15:
16: TYPE Modifier_LIST_Rec_Type IS RECORD
17: (
18: OFFER_ID NUMBER := Fnd_Api.g_miss_num
19: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
20: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
22: ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num
23: ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char

Line 20: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

16: TYPE Modifier_LIST_Rec_Type IS RECORD
17: (
18: OFFER_ID NUMBER := Fnd_Api.g_miss_num
19: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
20: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
22: ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num
23: ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char
24: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num

Line 21: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char

17: (
18: OFFER_ID NUMBER := Fnd_Api.g_miss_num
19: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
20: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
22: ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num
23: ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char
24: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
25: ,OWNER_ID NUMBER := Fnd_Api.g_miss_num

Line 22: ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num

18: OFFER_ID NUMBER := Fnd_Api.g_miss_num
19: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
20: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
22: ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num
23: ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char
24: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
25: ,OWNER_ID NUMBER := Fnd_Api.g_miss_num
26: ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char

Line 23: ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char

19: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
20: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
22: ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num
23: ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char
24: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
25: ,OWNER_ID NUMBER := Fnd_Api.g_miss_num
26: ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char
27: ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char

Line 24: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num

20: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
22: ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num
23: ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char
24: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
25: ,OWNER_ID NUMBER := Fnd_Api.g_miss_num
26: ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char
27: ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char
28: ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num

Line 25: ,OWNER_ID NUMBER := Fnd_Api.g_miss_num

21: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
22: ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num
23: ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char
24: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
25: ,OWNER_ID NUMBER := Fnd_Api.g_miss_num
26: ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char
27: ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char
28: ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num
29: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num

Line 26: ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char

22: ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num
23: ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char
24: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
25: ,OWNER_ID NUMBER := Fnd_Api.g_miss_num
26: ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char
27: ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char
28: ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num
29: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
30: ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date

Line 27: ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char

23: ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char
24: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
25: ,OWNER_ID NUMBER := Fnd_Api.g_miss_num
26: ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char
27: ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char
28: ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num
29: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
30: ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date
31: ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date

Line 28: ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num

24: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
25: ,OWNER_ID NUMBER := Fnd_Api.g_miss_num
26: ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char
27: ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char
28: ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num
29: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
30: ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date
31: ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date
32: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 29: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num

25: ,OWNER_ID NUMBER := Fnd_Api.g_miss_num
26: ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char
27: ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char
28: ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num
29: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
30: ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date
31: ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date
32: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
33: ,STATUS_DATE DATE := Fnd_Api.g_miss_date

Line 30: ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date

26: ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char
27: ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char
28: ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num
29: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
30: ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date
31: ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date
32: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
33: ,STATUS_DATE DATE := Fnd_Api.g_miss_date
34: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 31: ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date

27: ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char
28: ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num
29: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
30: ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date
31: ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date
32: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
33: ,STATUS_DATE DATE := Fnd_Api.g_miss_date
34: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
35: ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 32: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

28: ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num
29: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
30: ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date
31: ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date
32: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
33: ,STATUS_DATE DATE := Fnd_Api.g_miss_date
34: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
35: ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
36: ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num

Line 33: ,STATUS_DATE DATE := Fnd_Api.g_miss_date

29: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
30: ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date
31: ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date
32: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
33: ,STATUS_DATE DATE := Fnd_Api.g_miss_date
34: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
35: ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
36: ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num
37: ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 34: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

30: ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date
31: ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date
32: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
33: ,STATUS_DATE DATE := Fnd_Api.g_miss_date
34: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
35: ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
36: ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num
37: ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
38: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num

Line 35: ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

31: ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date
32: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
33: ,STATUS_DATE DATE := Fnd_Api.g_miss_date
34: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
35: ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
36: ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num
37: ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
38: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
39: ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num

Line 36: ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num

32: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
33: ,STATUS_DATE DATE := Fnd_Api.g_miss_date
34: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
35: ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
36: ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num
37: ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
38: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
39: ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num
40: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num

Line 37: ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

33: ,STATUS_DATE DATE := Fnd_Api.g_miss_date
34: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
35: ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
36: ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num
37: ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
38: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
39: ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num
40: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
41: ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num

Line 38: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num

34: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
35: ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
36: ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num
37: ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
38: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
39: ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num
40: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
41: ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num
42: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char

Line 39: ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num

35: ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
36: ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num
37: ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
38: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
39: ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num
40: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
41: ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num
42: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
43: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char

Line 40: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num

36: ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num
37: ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
38: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
39: ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num
40: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
41: ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num
42: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
43: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
44: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

Line 41: ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num

37: ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
38: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
39: ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num
40: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
41: ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num
42: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
43: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
44: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
45: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 42: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char

38: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
39: ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num
40: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
41: ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num
42: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
43: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
44: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
45: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
46: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 43: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char

39: ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num
40: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
41: ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num
42: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
43: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
44: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
45: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
46: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
47: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 44: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

40: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
41: ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num
42: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
43: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
44: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
45: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
46: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
47: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
48: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 45: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char

41: ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num
42: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
43: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
44: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
45: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
46: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
47: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
48: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
49: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 46: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char

42: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
43: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
44: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
45: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
46: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
47: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
48: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
49: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
50: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 47: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char

43: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
44: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
45: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
46: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
47: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
48: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
49: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
50: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
51: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 48: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char

44: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
45: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
46: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
47: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
48: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
49: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
50: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
51: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
52: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 49: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char

45: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
46: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
47: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
48: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
49: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
50: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
51: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
52: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
53: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 50: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char

46: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
47: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
48: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
49: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
50: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
51: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
52: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
53: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
54: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 51: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char

47: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
48: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
49: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
50: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
51: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
52: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
53: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
54: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
55: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 52: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char

48: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
49: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
50: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
51: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
52: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
53: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
54: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
55: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
56: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 53: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char

49: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
50: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
51: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
52: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
53: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
54: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
55: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
56: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
57: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 54: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char

50: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
51: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
52: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
53: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
54: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
55: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
56: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
57: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
58: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 55: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char

51: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
52: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
53: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
54: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
55: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
56: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
57: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
58: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
59: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 56: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char

52: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
53: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
54: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
55: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
56: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
57: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
58: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
59: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
60: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 57: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char

53: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
54: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
55: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
56: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
57: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
58: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
59: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
60: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
61: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date

Line 58: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char

54: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
55: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
56: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
57: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
58: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
59: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
60: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
61: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
62: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date

Line 59: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char

55: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
56: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
57: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
58: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
59: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
60: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
61: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
62: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
63: ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 60: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

56: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
57: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
58: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
59: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
60: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
61: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
62: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
63: ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
64: ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

Line 61: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date

57: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
58: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
59: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
60: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
61: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
62: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
63: ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
64: ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
65: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char

Line 62: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date

58: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
59: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
60: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
61: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
62: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
63: ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
64: ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
65: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
66: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char

Line 63: ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

59: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
60: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
61: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
62: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
63: ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
64: ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
65: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
66: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
67: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char

Line 64: ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

60: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
61: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
62: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
63: ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
64: ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
65: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
66: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
67: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
68: ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

Line 65: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char

61: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
62: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
63: ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
64: ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
65: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
66: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
67: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
68: ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
69: ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date

Line 66: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char

62: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
63: ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
64: ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
65: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
66: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
67: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
68: ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
69: ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
70: ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date

Line 67: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char

63: ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
64: ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
65: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
66: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
67: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
68: ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
69: ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
70: ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
71: ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 68: ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

64: ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
65: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
66: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
67: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
68: ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
69: ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
70: ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
71: ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
72: ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date

Line 69: ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date

65: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
66: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
67: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
68: ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
69: ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
70: ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
71: ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
72: ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
73: ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date

Line 70: ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date

66: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
67: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
68: ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
69: ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
70: ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
71: ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
72: ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
73: ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
74: ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 71: ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

67: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
68: ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
69: ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
70: ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
71: ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
72: ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
73: ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
74: ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
75: ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

Line 72: ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date

68: ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
69: ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
70: ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
71: ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
72: ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
73: ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
74: ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
75: ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
76: ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num

Line 73: ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date

69: ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
70: ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
71: ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
72: ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
73: ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
74: ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
75: ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
76: ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num
77: ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num

Line 74: ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

70: ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
71: ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
72: ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
73: ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
74: ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
75: ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
76: ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num
77: ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num
78: ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 75: ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

71: ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
72: ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
73: ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
74: ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
75: ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
76: ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num
77: ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num
78: ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
79: ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num

Line 76: ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num

72: ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
73: ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
74: ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
75: ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
76: ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num
77: ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num
78: ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
79: ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num
80: ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char

Line 77: ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num

73: ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
74: ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
75: ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
76: ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num
77: ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num
78: ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
79: ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num
80: ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char
81: ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 78: ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

74: ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
75: ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
76: ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num
77: ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num
78: ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
79: ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num
80: ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char
81: ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
82: ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num

Line 79: ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num

75: ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
76: ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num
77: ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num
78: ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
79: ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num
80: ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char
81: ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
82: ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
83: ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char

Line 80: ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char

76: ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num
77: ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num
78: ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
79: ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num
80: ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char
81: ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
82: ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
83: ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char
84: ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num

Line 81: ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

77: ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num
78: ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
79: ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num
80: ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char
81: ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
82: ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
83: ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char
84: ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num
85: ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num

Line 82: ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num

78: ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
79: ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num
80: ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char
81: ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
82: ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
83: ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char
84: ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num
85: ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num
86: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char

Line 83: ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char

79: ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num
80: ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char
81: ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
82: ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
83: ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char
84: ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num
85: ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num
86: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
87: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char

Line 84: ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num

80: ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char
81: ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
82: ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
83: ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char
84: ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num
85: ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num
86: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
87: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
88: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char

Line 85: ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num

81: ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
82: ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
83: ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char
84: ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num
85: ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num
86: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
87: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
88: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
89: ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char

Line 86: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char

82: ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
83: ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char
84: ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num
85: ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num
86: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
87: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
88: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
89: ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char
90: ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char

Line 87: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char

83: ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char
84: ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num
85: ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num
86: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
87: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
88: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
89: ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char
90: ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char
91: ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char

Line 88: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char

84: ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num
85: ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num
86: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
87: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
88: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
89: ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char
90: ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char
91: ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char
92: ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char

Line 89: ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char

85: ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num
86: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
87: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
88: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
89: ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char
90: ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char
91: ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char
92: ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
93: ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char

Line 90: ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char

86: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
87: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
88: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
89: ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char
90: ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char
91: ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char
92: ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
93: ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char
94: ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char

Line 91: ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char

87: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
88: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
89: ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char
90: ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char
91: ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char
92: ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
93: ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char
94: ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char
95: ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char

Line 92: ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char

88: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
89: ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char
90: ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char
91: ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char
92: ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
93: ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char
94: ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char
95: ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char
96: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char

Line 93: ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char

89: ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char
90: ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char
91: ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char
92: ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
93: ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char
94: ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char
95: ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char
96: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
97: ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num

Line 94: ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char

90: ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char
91: ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char
92: ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
93: ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char
94: ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char
95: ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char
96: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
97: ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num
98: ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char

Line 95: ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char

91: ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char
92: ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
93: ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char
94: ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char
95: ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char
96: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
97: ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num
98: ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char
99: ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char

Line 96: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char

92: ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
93: ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char
94: ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char
95: ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char
96: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
97: ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num
98: ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char
99: ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
100: ,ORIG_ORG_ID NUMBER := FND_API.g_miss_num

Line 97: ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num

93: ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char
94: ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char
95: ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char
96: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
97: ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num
98: ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char
99: ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
100: ,ORIG_ORG_ID NUMBER := FND_API.g_miss_num
101: ,na_qualifier_type VARCHAR2(30) := FND_API.g_miss_char

Line 98: ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char

94: ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char
95: ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char
96: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
97: ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num
98: ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char
99: ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
100: ,ORIG_ORG_ID NUMBER := FND_API.g_miss_num
101: ,na_qualifier_type VARCHAR2(30) := FND_API.g_miss_char
102: ,na_qualifier_id NUMBER := FND_API.g_miss_num

Line 99: ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char

95: ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char
96: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
97: ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num
98: ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char
99: ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
100: ,ORIG_ORG_ID NUMBER := FND_API.g_miss_num
101: ,na_qualifier_type VARCHAR2(30) := FND_API.g_miss_char
102: ,na_qualifier_id NUMBER := FND_API.g_miss_num
103: ,PERCENT_DISCOUNT NUMBER := FND_API.g_miss_num); /*nirprasa added for ER 11806714*/

Line 100: ,ORIG_ORG_ID NUMBER := FND_API.g_miss_num

96: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
97: ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num
98: ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char
99: ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
100: ,ORIG_ORG_ID NUMBER := FND_API.g_miss_num
101: ,na_qualifier_type VARCHAR2(30) := FND_API.g_miss_char
102: ,na_qualifier_id NUMBER := FND_API.g_miss_num
103: ,PERCENT_DISCOUNT NUMBER := FND_API.g_miss_num); /*nirprasa added for ER 11806714*/
104:

Line 101: ,na_qualifier_type VARCHAR2(30) := FND_API.g_miss_char

97: ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num
98: ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char
99: ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
100: ,ORIG_ORG_ID NUMBER := FND_API.g_miss_num
101: ,na_qualifier_type VARCHAR2(30) := FND_API.g_miss_char
102: ,na_qualifier_id NUMBER := FND_API.g_miss_num
103: ,PERCENT_DISCOUNT NUMBER := FND_API.g_miss_num); /*nirprasa added for ER 11806714*/
104:
105: TYPE Modifier_Line_Rec_Type IS RECORD

Line 102: ,na_qualifier_id NUMBER := FND_API.g_miss_num

98: ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char
99: ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
100: ,ORIG_ORG_ID NUMBER := FND_API.g_miss_num
101: ,na_qualifier_type VARCHAR2(30) := FND_API.g_miss_char
102: ,na_qualifier_id NUMBER := FND_API.g_miss_num
103: ,PERCENT_DISCOUNT NUMBER := FND_API.g_miss_num); /*nirprasa added for ER 11806714*/
104:
105: TYPE Modifier_Line_Rec_Type IS RECORD
106: (

Line 103: ,PERCENT_DISCOUNT NUMBER := FND_API.g_miss_num); /*nirprasa added for ER 11806714*/

99: ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
100: ,ORIG_ORG_ID NUMBER := FND_API.g_miss_num
101: ,na_qualifier_type VARCHAR2(30) := FND_API.g_miss_char
102: ,na_qualifier_id NUMBER := FND_API.g_miss_num
103: ,PERCENT_DISCOUNT NUMBER := FND_API.g_miss_num); /*nirprasa added for ER 11806714*/
104:
105: TYPE Modifier_Line_Rec_Type IS RECORD
106: (
107: OFFER_LINE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 107: OFFER_LINE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

103: ,PERCENT_DISCOUNT NUMBER := FND_API.g_miss_num); /*nirprasa added for ER 11806714*/
104:
105: TYPE Modifier_Line_Rec_Type IS RECORD
106: (
107: OFFER_LINE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
108: ,OPERATION VARCHAR2(30) := FND_API.g_miss_char
109: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
110: ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char
111: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num

Line 108: ,OPERATION VARCHAR2(30) := FND_API.g_miss_char

104:
105: TYPE Modifier_Line_Rec_Type IS RECORD
106: (
107: OFFER_LINE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
108: ,OPERATION VARCHAR2(30) := FND_API.g_miss_char
109: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
110: ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char
111: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
112: ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 109: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

105: TYPE Modifier_Line_Rec_Type IS RECORD
106: (
107: OFFER_LINE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
108: ,OPERATION VARCHAR2(30) := FND_API.g_miss_char
109: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
110: ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char
111: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
112: ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
113: ,OPERAND NUMBER := Fnd_Api.g_miss_num

Line 110: ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char

106: (
107: OFFER_LINE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
108: ,OPERATION VARCHAR2(30) := FND_API.g_miss_char
109: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
110: ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char
111: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
112: ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
113: ,OPERAND NUMBER := Fnd_Api.g_miss_num
114: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date

Line 111: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num

107: OFFER_LINE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
108: ,OPERATION VARCHAR2(30) := FND_API.g_miss_char
109: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
110: ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char
111: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
112: ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
113: ,OPERAND NUMBER := Fnd_Api.g_miss_num
114: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date
115: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date

Line 112: ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

108: ,OPERATION VARCHAR2(30) := FND_API.g_miss_char
109: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
110: ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char
111: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
112: ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
113: ,OPERAND NUMBER := Fnd_Api.g_miss_num
114: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date
115: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date
116: ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char

Line 113: ,OPERAND NUMBER := Fnd_Api.g_miss_num

109: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
110: ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char
111: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
112: ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
113: ,OPERAND NUMBER := Fnd_Api.g_miss_num
114: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date
115: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date
116: ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
117: ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

Line 114: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date

110: ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char
111: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
112: ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
113: ,OPERAND NUMBER := Fnd_Api.g_miss_num
114: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date
115: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date
116: ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
117: ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
118: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num

Line 115: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date

111: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
112: ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
113: ,OPERAND NUMBER := Fnd_Api.g_miss_num
114: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date
115: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date
116: ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
117: ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
118: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num
119: ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char

Line 116: ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char

112: ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
113: ,OPERAND NUMBER := Fnd_Api.g_miss_num
114: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date
115: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date
116: ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
117: ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
118: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num
119: ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
120: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num

Line 117: ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

113: ,OPERAND NUMBER := Fnd_Api.g_miss_num
114: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date
115: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date
116: ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
117: ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
118: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num
119: ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
120: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num
121: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num

Line 118: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num

114: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date
115: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date
116: ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
117: ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
118: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num
119: ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
120: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num
121: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
122: ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char

Line 119: ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char

115: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date
116: ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
117: ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
118: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num
119: ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
120: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num
121: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
122: ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
123: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

Line 120: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num

116: ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
117: ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
118: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num
119: ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
120: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num
121: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
122: ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
123: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
124: ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char

Line 121: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num

117: ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
118: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num
119: ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
120: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num
121: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
122: ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
123: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
124: ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
125: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num

Line 122: ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char

118: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num
119: ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
120: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num
121: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
122: ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
123: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
124: ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
125: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num
126: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

Line 123: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

119: ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
120: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num
121: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
122: ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
123: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
124: ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
125: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num
126: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
127: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num

Line 124: ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char

120: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num
121: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
122: ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
123: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
124: ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
125: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num
126: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
127: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num
128: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num

Line 125: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num

121: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
122: ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
123: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
124: ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
125: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num
126: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
127: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num
128: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num
129: ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char

Line 126: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

122: ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
123: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
124: ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
125: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num
126: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
127: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num
128: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num
129: ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
130: ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

Line 127: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num

123: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
124: ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
125: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num
126: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
127: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num
128: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num
129: ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
130: ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
131: ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char

Line 128: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num

124: ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
125: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num
126: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
127: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num
128: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num
129: ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
130: ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
131: ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
132: ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char

Line 129: ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char

125: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num
126: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
127: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num
128: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num
129: ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
130: ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
131: ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
132: ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
133: ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 130: ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

126: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
127: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num
128: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num
129: ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
130: ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
131: ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
132: ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
133: ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
134: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num

Line 131: ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char

127: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num
128: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num
129: ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
130: ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
131: ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
132: ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
133: ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
134: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
135: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

Line 132: ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char

128: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num
129: ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
130: ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
131: ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
132: ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
133: ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
134: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
135: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
136: ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char

Line 133: ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

129: ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
130: ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
131: ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
132: ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
133: ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
134: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
135: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
136: ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
137: ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char

Line 134: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num

130: ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
131: ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
132: ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
133: ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
134: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
135: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
136: ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
137: ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
138: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char

Line 135: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

131: ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
132: ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
133: ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
134: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
135: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
136: ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
137: ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
138: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
139: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

Line 136: ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char

132: ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
133: ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
134: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
135: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
136: ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
137: ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
138: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
139: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
140: ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char

Line 137: ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char

133: ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
134: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
135: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
136: ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
137: ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
138: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
139: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
140: ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
141: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char

Line 138: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char

134: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
135: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
136: ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
137: ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
138: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
139: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
140: ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
141: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
142: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char

Line 139: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

135: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
136: ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
137: ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
138: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
139: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
140: ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
141: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
142: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
143: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

Line 140: ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char

136: ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
137: ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
138: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
139: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
140: ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
141: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
142: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
143: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
144: ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char

Line 141: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char

137: ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
138: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
139: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
140: ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
141: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
142: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
143: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
144: ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
145: ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char

Line 142: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char

138: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
139: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
140: ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
141: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
142: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
143: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
144: ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
145: ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
146: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num

Line 143: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

139: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
140: ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
141: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
142: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
143: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
144: ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
145: ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
146: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num
147: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char

Line 144: ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char

140: ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
141: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
142: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
143: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
144: ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
145: ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
146: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num
147: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
148: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

Line 145: ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char

141: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
142: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
143: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
144: ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
145: ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
146: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num
147: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
148: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
149: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 146: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num

142: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
143: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
144: ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
145: ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
146: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num
147: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
148: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
149: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
150: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 147: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char

143: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
144: ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
145: ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
146: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num
147: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
148: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
149: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
150: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
151: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 148: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

144: ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
145: ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
146: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num
147: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
148: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
149: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
150: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
151: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
152: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 149: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char

145: ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
146: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num
147: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
148: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
149: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
150: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
151: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
152: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
153: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 150: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char

146: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num
147: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
148: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
149: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
150: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
151: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
152: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
153: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
154: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 151: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char

147: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
148: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
149: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
150: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
151: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
152: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
153: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
154: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
155: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 152: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char

148: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
149: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
150: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
151: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
152: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
153: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
154: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
155: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
156: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 153: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char

149: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
150: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
151: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
152: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
153: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
154: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
155: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
156: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
157: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 154: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char

150: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
151: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
152: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
153: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
154: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
155: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
156: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
157: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
158: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 155: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char

151: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
152: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
153: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
154: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
155: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
156: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
157: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
158: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
159: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 156: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char

152: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
153: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
154: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
155: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
156: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
157: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
158: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
159: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
160: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 157: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char

153: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
154: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
155: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
156: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
157: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
158: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
159: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
160: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
161: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 158: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char

154: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
155: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
156: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
157: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
158: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
159: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
160: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
161: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
162: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 159: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char

155: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
156: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
157: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
158: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
159: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
160: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
161: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
162: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
163: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 160: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char

156: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
157: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
158: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
159: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
160: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
161: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
162: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
163: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
164: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num

Line 161: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char

157: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
158: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
159: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
160: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
161: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
162: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
163: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
164: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num
165: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num

Line 162: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char

158: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
159: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
160: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
161: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
162: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
163: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
164: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num
165: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num
166: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num

Line 163: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char

159: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
160: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
161: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
162: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
163: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
164: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num
165: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num
166: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
167: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num

Line 164: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num

160: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
161: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
162: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
163: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
164: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num
165: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num
166: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
167: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
168: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num

Line 165: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num

161: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
162: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
163: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
164: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num
165: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num
166: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
167: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
168: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num
169: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num

Line 166: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num

162: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
163: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
164: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num
165: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num
166: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
167: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
168: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num
169: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
170: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num

Line 167: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num

163: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
164: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num
165: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num
166: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
167: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
168: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num
169: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
170: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
171: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num

Line 168: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num

164: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num
165: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num
166: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
167: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
168: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num
169: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
170: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
171: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
172: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num

Line 169: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num

165: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num
166: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
167: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
168: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num
169: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
170: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
171: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
172: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num
173: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num

Line 170: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num

166: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
167: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
168: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num
169: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
170: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
171: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
172: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num
173: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
174: ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char

Line 171: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num

167: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
168: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num
169: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
170: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
171: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
172: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num
173: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
174: ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char
175: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM

Line 172: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num

168: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num
169: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
170: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
171: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
172: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num
173: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
174: ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char
175: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
176: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM

Line 173: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num

169: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
170: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
171: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
172: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num
173: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
174: ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char
175: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
176: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
177: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 174: ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char

170: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
171: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
172: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num
173: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
174: ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char
175: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
176: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
177: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
178: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 175: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM

171: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
172: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num
173: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
174: ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char
175: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
176: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
177: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
178: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
179: ,limit_exceed_action_code VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 176: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM

172: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num
173: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
174: ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char
175: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
176: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
177: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
178: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
179: ,limit_exceed_action_code VARCHAR2(240) := FND_API.G_MISS_CHAR
180: );

Line 177: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR

173: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
174: ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char
175: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
176: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
177: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
178: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
179: ,limit_exceed_action_code VARCHAR2(240) := FND_API.G_MISS_CHAR
180: );
181:

Line 178: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR

174: ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char
175: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
176: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
177: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
178: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
179: ,limit_exceed_action_code VARCHAR2(240) := FND_API.G_MISS_CHAR
180: );
181:
182: TYPE modifier_line_tbl_type IS TABLE OF MODIFIER_LINE_REC_TYPE

Line 179: ,limit_exceed_action_code VARCHAR2(240) := FND_API.G_MISS_CHAR

175: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
176: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
177: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
178: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
179: ,limit_exceed_action_code VARCHAR2(240) := FND_API.G_MISS_CHAR
180: );
181:
182: TYPE modifier_line_tbl_type IS TABLE OF MODIFIER_LINE_REC_TYPE
183: INDEX BY BINARY_INTEGER;

Line 187: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

183: INDEX BY BINARY_INTEGER;
184:
185: TYPE Pricing_ATTR_Rec_Type IS RECORD
186: (
187: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
188: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
189: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
190: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
191: ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 188: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

184:
185: TYPE Pricing_ATTR_Rec_Type IS RECORD
186: (
187: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
188: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
189: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
190: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
191: ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
192: ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char

Line 189: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num

185: TYPE Pricing_ATTR_Rec_Type IS RECORD
186: (
187: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
188: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
189: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
190: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
191: ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
192: ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
193: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char

Line 190: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

186: (
187: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
188: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
189: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
190: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
191: ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
192: ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
193: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
194: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

Line 191: ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char

187: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
188: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
189: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
190: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
191: ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
192: ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
193: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
194: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
195: ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 192: ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char

188: ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
189: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
190: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
191: ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
192: ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
193: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
194: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
195: ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
196: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char

Line 193: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char

189: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
190: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
191: ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
192: ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
193: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
194: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
195: ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
196: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char

Line 194: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

190: ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
191: ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
192: ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
193: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
194: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
195: ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
196: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
198: ,MODIFIERS_INDEX NUMBER := Fnd_Api.g_miss_num

Line 195: ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char

191: ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
192: ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
193: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
194: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
195: ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
196: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
198: ,MODIFIERS_INDEX NUMBER := Fnd_Api.g_miss_num
199: ,OPERATION VARCHAR2(20) := Fnd_Api.g_miss_char

Line 196: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char

192: ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
193: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
194: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
195: ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
196: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
198: ,MODIFIERS_INDEX NUMBER := Fnd_Api.g_miss_num
199: ,OPERATION VARCHAR2(20) := Fnd_Api.g_miss_char
200: );

Line 197: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char

193: ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
194: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
195: ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
196: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
198: ,MODIFIERS_INDEX NUMBER := Fnd_Api.g_miss_num
199: ,OPERATION VARCHAR2(20) := Fnd_Api.g_miss_char
200: );
201:

Line 198: ,MODIFIERS_INDEX NUMBER := Fnd_Api.g_miss_num

194: ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
195: ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
196: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
198: ,MODIFIERS_INDEX NUMBER := Fnd_Api.g_miss_num
199: ,OPERATION VARCHAR2(20) := Fnd_Api.g_miss_char
200: );
201:
202: TYPE pricing_attR_tbl_type IS TABLE OF Pricing_ATTR_Rec_Type

Line 199: ,OPERATION VARCHAR2(20) := Fnd_Api.g_miss_char

195: ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
196: ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
198: ,MODIFIERS_INDEX NUMBER := Fnd_Api.g_miss_num
199: ,OPERATION VARCHAR2(20) := Fnd_Api.g_miss_char
200: );
201:
202: TYPE pricing_attR_tbl_type IS TABLE OF Pricing_ATTR_Rec_Type
203: INDEX BY BINARY_INTEGER;

Line 207: QUALIFIER_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

203: INDEX BY BINARY_INTEGER;
204:
205: TYPE qualifiers_Rec_Type IS RECORD
206: (
207: QUALIFIER_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
208: ,QUALIFIER_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
209: ,QUALIFIER_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
210: ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
211: ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 208: ,QUALIFIER_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char

204:
205: TYPE qualifiers_Rec_Type IS RECORD
206: (
207: QUALIFIER_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
208: ,QUALIFIER_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
209: ,QUALIFIER_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
210: ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
211: ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
212: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num

Line 209: ,QUALIFIER_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char

205: TYPE qualifiers_Rec_Type IS RECORD
206: (
207: QUALIFIER_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
208: ,QUALIFIER_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
209: ,QUALIFIER_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
210: ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
211: ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
212: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num
213: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

Line 210: ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char

206: (
207: QUALIFIER_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
208: ,QUALIFIER_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
209: ,QUALIFIER_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
210: ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
211: ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
212: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num
213: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
214: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num

Line 211: ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

207: QUALIFIER_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
208: ,QUALIFIER_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
209: ,QUALIFIER_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
210: ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
211: ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
212: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num
213: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
214: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
215: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num

Line 212: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num

208: ,QUALIFIER_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
209: ,QUALIFIER_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
210: ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
211: ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
212: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num
213: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
214: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
215: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
216: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date

Line 213: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

209: ,QUALIFIER_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
210: ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
211: ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
212: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num
213: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
214: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
215: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
216: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
217: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date

Line 214: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num

210: ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
211: ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
212: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num
213: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
214: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
215: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
216: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
217: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
218: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num

Line 215: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num

211: ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
212: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num
213: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
214: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
215: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
216: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
217: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
218: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num
219: ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char

Line 216: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date

212: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num
213: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
214: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
215: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
216: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
217: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
218: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num
219: ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char
220: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

Line 217: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date

213: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
214: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
215: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
216: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
217: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
218: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num
219: ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char
220: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
221: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 218: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num

214: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
215: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
216: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
217: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
218: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num
219: ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char
220: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
221: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 219: ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char

215: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
216: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
217: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
218: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num
219: ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char
220: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
221: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 220: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char

216: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
217: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
218: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num
219: ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char
220: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
221: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 221: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char

217: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
218: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num
219: ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char
220: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
221: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 222: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char

218: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num
219: ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char
220: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
221: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 223: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char

219: ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char
220: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
221: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 224: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char

220: ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
221: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 225: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char

221: ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 226: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char

222: ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
230: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 227: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char

223: ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
230: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
231: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 228: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char

224: ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
230: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
231: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
232: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 229: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char

225: ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
230: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
231: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
232: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
233: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 230: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char

226: ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
230: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
231: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
232: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
233: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
234: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 231: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char

227: ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
230: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
231: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
232: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
233: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
234: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char

Line 232: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char

228: ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
230: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
231: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
232: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
233: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
234: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
236: );

Line 233: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char

229: ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
230: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
231: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
232: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
233: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
234: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
236: );
237:

Line 234: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char

230: ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
231: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
232: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
233: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
234: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
236: );
237:
238: TYPE qualifiers_tbl_type IS TABLE OF qualifiers_rec_type

Line 235: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char

231: ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
232: ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
233: ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
234: ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
236: );
237:
238: TYPE qualifiers_tbl_type IS TABLE OF qualifiers_rec_type
239: INDEX BY BINARY_INTEGER;

Line 243: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

239: INDEX BY BINARY_INTEGER;
240:
241: TYPE Advanced_Option_Rec_Type IS RECORD
242: (
243: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
244: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
245: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
246: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
247: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num

Line 244: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num

240:
241: TYPE Advanced_Option_Rec_Type IS RECORD
242: (
243: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
244: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
245: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
246: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
247: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num
248: ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

Line 245: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

241: TYPE Advanced_Option_Rec_Type IS RECORD
242: (
243: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
244: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
245: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
246: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
247: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num
248: ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
249: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num

Line 246: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

242: (
243: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
244: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
245: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
246: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
247: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num
248: ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
249: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num
250: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num

Line 247: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num

243: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
244: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
245: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
246: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
247: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num
248: ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
249: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num
250: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num
251: ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

Line 248: ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char

244: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
245: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
246: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
247: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num
248: ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
249: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num
250: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num
251: ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
252: ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char

Line 249: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num

245: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
246: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
247: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num
248: ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
249: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num
250: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num
251: ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
252: ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char
253: ,autopay_days NUMBER := FND_API.G_miss_num

Line 250: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num

246: ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
247: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num
248: ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
249: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num
250: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num
251: ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
252: ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char
253: ,autopay_days NUMBER := FND_API.G_miss_num
254: ,autopay_method VARCHAR2(30) := FND_API.g_miss_char

Line 251: ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char

247: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num
248: ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
249: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num
250: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num
251: ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
252: ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char
253: ,autopay_days NUMBER := FND_API.G_miss_num
254: ,autopay_method VARCHAR2(30) := FND_API.g_miss_char
255: ,autopay_party_attr VARCHAR2(30) := FND_API.g_miss_char

Line 252: ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char

248: ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
249: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num
250: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num
251: ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
252: ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char
253: ,autopay_days NUMBER := FND_API.G_miss_num
254: ,autopay_method VARCHAR2(30) := FND_API.g_miss_char
255: ,autopay_party_attr VARCHAR2(30) := FND_API.g_miss_char
256: ,autopay_party_id NUMBER := FND_API.g_miss_num

Line 253: ,autopay_days NUMBER := FND_API.G_miss_num

249: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num
250: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num
251: ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
252: ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char
253: ,autopay_days NUMBER := FND_API.G_miss_num
254: ,autopay_method VARCHAR2(30) := FND_API.g_miss_char
255: ,autopay_party_attr VARCHAR2(30) := FND_API.g_miss_char
256: ,autopay_party_id NUMBER := FND_API.g_miss_num
257: );

Line 254: ,autopay_method VARCHAR2(30) := FND_API.g_miss_char

250: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num
251: ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
252: ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char
253: ,autopay_days NUMBER := FND_API.G_miss_num
254: ,autopay_method VARCHAR2(30) := FND_API.g_miss_char
255: ,autopay_party_attr VARCHAR2(30) := FND_API.g_miss_char
256: ,autopay_party_id NUMBER := FND_API.g_miss_num
257: );
258:

Line 255: ,autopay_party_attr VARCHAR2(30) := FND_API.g_miss_char

251: ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
252: ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char
253: ,autopay_days NUMBER := FND_API.G_miss_num
254: ,autopay_method VARCHAR2(30) := FND_API.g_miss_char
255: ,autopay_party_attr VARCHAR2(30) := FND_API.g_miss_char
256: ,autopay_party_id NUMBER := FND_API.g_miss_num
257: );
258:
259:

Line 256: ,autopay_party_id NUMBER := FND_API.g_miss_num

252: ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char
253: ,autopay_days NUMBER := FND_API.G_miss_num
254: ,autopay_method VARCHAR2(30) := FND_API.g_miss_char
255: ,autopay_party_attr VARCHAR2(30) := FND_API.g_miss_char
256: ,autopay_party_id NUMBER := FND_API.g_miss_num
257: );
258:
259:
260: ---------------------------------------------------------------------

Line 439: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL

435: (
436: p_api_version_number IN NUMBER
437: , p_init_msg_list IN VARCHAR2
438: , p_commit IN VARCHAR2
439: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
440: , x_return_status OUT NOCOPY VARCHAR2
441: , x_msg_count OUT NOCOPY NUMBER
442: , x_msg_data OUT NOCOPY VARCHAR2
443: , p_offer_rec IN Modifier_LIST_Rec_Type

Line 498: ,p_init_msg_list IN VARCHAR2 :=FND_API.g_true

494: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
495: );
496: PROCEDURE process_sd_modifiers(
497: p_sdr_header_id IN NUMBER
498: ,p_init_msg_list IN VARCHAR2 :=FND_API.g_true
499: ,p_api_version IN NUMBER
500: ,p_commit IN VARCHAR2 :=FND_API.g_false
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_count OUT NOCOPY NUMBER

Line 500: ,p_commit IN VARCHAR2 :=FND_API.g_false

496: PROCEDURE process_sd_modifiers(
497: p_sdr_header_id IN NUMBER
498: ,p_init_msg_list IN VARCHAR2 :=FND_API.g_true
499: ,p_api_version IN NUMBER
500: ,p_commit IN VARCHAR2 :=FND_API.g_false
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_count OUT NOCOPY NUMBER
503: ,x_msg_data OUT NOCOPY VARCHAR2
504: ,x_qp_list_header_id IN OUT NOCOPY NUMBER