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:

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:
104: TYPE Modifier_Line_Rec_Type IS RECORD

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:
104: TYPE Modifier_Line_Rec_Type IS RECORD
105: (

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:
104: TYPE Modifier_Line_Rec_Type IS RECORD
105: (
106: OFFER_LINE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char

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

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

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

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

Line 108: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

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

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

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

Line 110: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num

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

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

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

Line 112: ,OPERAND NUMBER := Fnd_Api.g_miss_num

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

Line 113: ,START_DATE_ACTIVE DATE := FND_API.g_miss_date

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

Line 114: ,END_DATE_ACTIVE DATE := FND_API.g_miss_date

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

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

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

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

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

Line 117: ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num

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

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

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

Line 119: ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num

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

Line 120: ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num

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

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

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

Line 122: ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

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

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

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

Line 124: ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num

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

Line 125: ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

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

Line 126: ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num

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

Line 127: ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num

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

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

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

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

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

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

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

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

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

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

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

Line 133: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 145: ,QUALIFIER_ID NUMBER := FND_API.g_miss_num

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 163: ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num

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

Line 164: ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num

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

Line 165: ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num

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

Line 166: ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num

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

Line 167: ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num

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

Line 168: ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num

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

Line 169: ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num

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

Line 170: ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num

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

Line 171: ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num

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

Line 172: ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num

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

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

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

Line 174: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM

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

Line 175: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM

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

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

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

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

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

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

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

Line 186: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

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

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

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

Line 188: ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 197: ,MODIFIERS_INDEX NUMBER := Fnd_Api.g_miss_num

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 211: ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num

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

Line 212: ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

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

Line 213: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num

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

Line 214: ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num

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

Line 215: ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date

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

Line 216: ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date

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

Line 217: ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 242: LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num

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

Line 243: ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num

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

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

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

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

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

Line 246: ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num

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

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

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

Line 248: ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num

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

Line 249: ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num

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

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

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

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

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

Line 252: ,autopay_days NUMBER := FND_API.G_miss_num

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

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

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

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

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

Line 255: ,autopay_party_id NUMBER := FND_API.g_miss_num

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

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

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

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

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

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

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