5: -- Global Variables
6: -- ----------------------------------------------------------------------------
7: TYPE Modifier_LIST_Rec_Type IS RECORD
8: (
9: OFFER_ID NUMBER := Fnd_Api.g_miss_num
10: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
11: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
12: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
13: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
6: -- ----------------------------------------------------------------------------
7: TYPE Modifier_LIST_Rec_Type IS RECORD
8: (
9: OFFER_ID NUMBER := Fnd_Api.g_miss_num
10: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
11: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
12: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
13: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
14: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
7: TYPE Modifier_LIST_Rec_Type IS RECORD
8: (
9: OFFER_ID NUMBER := Fnd_Api.g_miss_num
10: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
11: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
12: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
13: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
14: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
15: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
8: (
9: OFFER_ID NUMBER := Fnd_Api.g_miss_num
10: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
11: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
12: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
13: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
14: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
15: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
16: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
9: OFFER_ID NUMBER := Fnd_Api.g_miss_num
10: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
11: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
12: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
13: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
14: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
15: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
16: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
17: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
10: ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
11: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
12: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
13: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
14: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
15: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
16: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
17: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
18: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
11: ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
12: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
13: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
14: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
15: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
16: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
17: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
18: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
19: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
12: ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
13: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
14: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
15: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
16: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
17: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
18: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
19: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
20: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
13: ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
14: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
15: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
16: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
17: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
18: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
19: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
20: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
14: ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
15: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
16: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
17: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
18: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
19: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
20: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
22: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
15: ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
16: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
17: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
18: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
19: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
20: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
22: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
23: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
16: ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
17: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
18: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
19: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
20: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
22: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
23: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
24: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
17: ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
18: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
19: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
20: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
22: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
23: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
24: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
25: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
18: ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
19: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
20: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
22: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
23: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
24: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
25: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
26: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
19: ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
20: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
22: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
23: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
24: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
25: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
26: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
27: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
20: ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
21: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
22: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
23: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
24: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
25: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
26: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
27: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
28: );
21: ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
22: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
23: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
24: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
25: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
26: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
27: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
28: );
29:
22: ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
23: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
24: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
25: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
26: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
27: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
28: );
29:
30:
23: ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
24: ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
25: ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
26: ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
27: ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
28: );
29:
30:
31: TYPE discount_line_rec_type IS RECORD