eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on FND_API

Line 87: offer_id NUMBER := FND_API.G_MISS_NUM,

83:
84: --===================================================================
85: TYPE offers_rec_type IS RECORD
86: (
87: offer_id NUMBER := FND_API.G_MISS_NUM,
88: qp_list_header_id NUMBER := FND_API.G_MISS_NUM,
89: offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: offer_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
91: activity_media_id NUMBER := FND_API.G_MISS_NUM,

Line 88: qp_list_header_id NUMBER := FND_API.G_MISS_NUM,

84: --===================================================================
85: TYPE offers_rec_type IS RECORD
86: (
87: offer_id NUMBER := FND_API.G_MISS_NUM,
88: qp_list_header_id NUMBER := FND_API.G_MISS_NUM,
89: offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: offer_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
91: activity_media_id NUMBER := FND_API.G_MISS_NUM,
92: reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 89: offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

85: TYPE offers_rec_type IS RECORD
86: (
87: offer_id NUMBER := FND_API.G_MISS_NUM,
88: qp_list_header_id NUMBER := FND_API.G_MISS_NUM,
89: offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: offer_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
91: activity_media_id NUMBER := FND_API.G_MISS_NUM,
92: reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,
93: user_status_id NUMBER := FND_API.G_MISS_NUM,

Line 90: offer_code VARCHAR2(100) := FND_API.G_MISS_CHAR,

86: (
87: offer_id NUMBER := FND_API.G_MISS_NUM,
88: qp_list_header_id NUMBER := FND_API.G_MISS_NUM,
89: offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: offer_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
91: activity_media_id NUMBER := FND_API.G_MISS_NUM,
92: reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,
93: user_status_id NUMBER := FND_API.G_MISS_NUM,
94: owner_id NUMBER := FND_API.G_MISS_NUM,

Line 91: activity_media_id NUMBER := FND_API.G_MISS_NUM,

87: offer_id NUMBER := FND_API.G_MISS_NUM,
88: qp_list_header_id NUMBER := FND_API.G_MISS_NUM,
89: offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: offer_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
91: activity_media_id NUMBER := FND_API.G_MISS_NUM,
92: reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,
93: user_status_id NUMBER := FND_API.G_MISS_NUM,
94: owner_id NUMBER := FND_API.G_MISS_NUM,
95: wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,

Line 92: reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,

88: qp_list_header_id NUMBER := FND_API.G_MISS_NUM,
89: offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: offer_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
91: activity_media_id NUMBER := FND_API.G_MISS_NUM,
92: reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,
93: user_status_id NUMBER := FND_API.G_MISS_NUM,
94: owner_id NUMBER := FND_API.G_MISS_NUM,
95: wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,
96: customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 93: user_status_id NUMBER := FND_API.G_MISS_NUM,

89: offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: offer_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
91: activity_media_id NUMBER := FND_API.G_MISS_NUM,
92: reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,
93: user_status_id NUMBER := FND_API.G_MISS_NUM,
94: owner_id NUMBER := FND_API.G_MISS_NUM,
95: wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,
96: customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,

Line 94: owner_id NUMBER := FND_API.G_MISS_NUM,

90: offer_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
91: activity_media_id NUMBER := FND_API.G_MISS_NUM,
92: reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,
93: user_status_id NUMBER := FND_API.G_MISS_NUM,
94: owner_id NUMBER := FND_API.G_MISS_NUM,
95: wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,
96: customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,
98: last_update_date DATE := FND_API.G_MISS_DATE,

Line 95: wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,

91: activity_media_id NUMBER := FND_API.G_MISS_NUM,
92: reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,
93: user_status_id NUMBER := FND_API.G_MISS_NUM,
94: owner_id NUMBER := FND_API.G_MISS_NUM,
95: wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,
96: customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,
98: last_update_date DATE := FND_API.G_MISS_DATE,
99: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 96: customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,

92: reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,
93: user_status_id NUMBER := FND_API.G_MISS_NUM,
94: owner_id NUMBER := FND_API.G_MISS_NUM,
95: wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,
96: customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,
98: last_update_date DATE := FND_API.G_MISS_DATE,
99: last_updated_by NUMBER := FND_API.G_MISS_NUM,
100: creation_date DATE := FND_API.G_MISS_DATE,

Line 97: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,

93: user_status_id NUMBER := FND_API.G_MISS_NUM,
94: owner_id NUMBER := FND_API.G_MISS_NUM,
95: wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,
96: customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,
98: last_update_date DATE := FND_API.G_MISS_DATE,
99: last_updated_by NUMBER := FND_API.G_MISS_NUM,
100: creation_date DATE := FND_API.G_MISS_DATE,
101: created_by NUMBER := FND_API.G_MISS_NUM,

Line 98: last_update_date DATE := FND_API.G_MISS_DATE,

94: owner_id NUMBER := FND_API.G_MISS_NUM,
95: wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,
96: customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,
98: last_update_date DATE := FND_API.G_MISS_DATE,
99: last_updated_by NUMBER := FND_API.G_MISS_NUM,
100: creation_date DATE := FND_API.G_MISS_DATE,
101: created_by NUMBER := FND_API.G_MISS_NUM,
102: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 99: last_updated_by NUMBER := FND_API.G_MISS_NUM,

95: wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,
96: customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,
98: last_update_date DATE := FND_API.G_MISS_DATE,
99: last_updated_by NUMBER := FND_API.G_MISS_NUM,
100: creation_date DATE := FND_API.G_MISS_DATE,
101: created_by NUMBER := FND_API.G_MISS_NUM,
102: last_update_login NUMBER := FND_API.G_MISS_NUM,
103: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 100: creation_date DATE := FND_API.G_MISS_DATE,

96: customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,
98: last_update_date DATE := FND_API.G_MISS_DATE,
99: last_updated_by NUMBER := FND_API.G_MISS_NUM,
100: creation_date DATE := FND_API.G_MISS_DATE,
101: created_by NUMBER := FND_API.G_MISS_NUM,
102: last_update_login NUMBER := FND_API.G_MISS_NUM,
103: object_version_number NUMBER := FND_API.G_MISS_NUM,
104: perf_date_from DATE := FND_API.G_MISS_DATE,

Line 101: created_by NUMBER := FND_API.G_MISS_NUM,

97: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,
98: last_update_date DATE := FND_API.G_MISS_DATE,
99: last_updated_by NUMBER := FND_API.G_MISS_NUM,
100: creation_date DATE := FND_API.G_MISS_DATE,
101: created_by NUMBER := FND_API.G_MISS_NUM,
102: last_update_login NUMBER := FND_API.G_MISS_NUM,
103: object_version_number NUMBER := FND_API.G_MISS_NUM,
104: perf_date_from DATE := FND_API.G_MISS_DATE,
105: perf_date_to DATE := FND_API.G_MISS_DATE,

Line 102: last_update_login NUMBER := FND_API.G_MISS_NUM,

98: last_update_date DATE := FND_API.G_MISS_DATE,
99: last_updated_by NUMBER := FND_API.G_MISS_NUM,
100: creation_date DATE := FND_API.G_MISS_DATE,
101: created_by NUMBER := FND_API.G_MISS_NUM,
102: last_update_login NUMBER := FND_API.G_MISS_NUM,
103: object_version_number NUMBER := FND_API.G_MISS_NUM,
104: perf_date_from DATE := FND_API.G_MISS_DATE,
105: perf_date_to DATE := FND_API.G_MISS_DATE,
106: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 103: object_version_number NUMBER := FND_API.G_MISS_NUM,

99: last_updated_by NUMBER := FND_API.G_MISS_NUM,
100: creation_date DATE := FND_API.G_MISS_DATE,
101: created_by NUMBER := FND_API.G_MISS_NUM,
102: last_update_login NUMBER := FND_API.G_MISS_NUM,
103: object_version_number NUMBER := FND_API.G_MISS_NUM,
104: perf_date_from DATE := FND_API.G_MISS_DATE,
105: perf_date_to DATE := FND_API.G_MISS_DATE,
106: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: status_date DATE := FND_API.G_MISS_DATE,

Line 104: perf_date_from DATE := FND_API.G_MISS_DATE,

100: creation_date DATE := FND_API.G_MISS_DATE,
101: created_by NUMBER := FND_API.G_MISS_NUM,
102: last_update_login NUMBER := FND_API.G_MISS_NUM,
103: object_version_number NUMBER := FND_API.G_MISS_NUM,
104: perf_date_from DATE := FND_API.G_MISS_DATE,
105: perf_date_to DATE := FND_API.G_MISS_DATE,
106: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: status_date DATE := FND_API.G_MISS_DATE,
108: modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 105: perf_date_to DATE := FND_API.G_MISS_DATE,

101: created_by NUMBER := FND_API.G_MISS_NUM,
102: last_update_login NUMBER := FND_API.G_MISS_NUM,
103: object_version_number NUMBER := FND_API.G_MISS_NUM,
104: perf_date_from DATE := FND_API.G_MISS_DATE,
105: perf_date_to DATE := FND_API.G_MISS_DATE,
106: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: status_date DATE := FND_API.G_MISS_DATE,
108: modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 106: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

102: last_update_login NUMBER := FND_API.G_MISS_NUM,
103: object_version_number NUMBER := FND_API.G_MISS_NUM,
104: perf_date_from DATE := FND_API.G_MISS_DATE,
105: perf_date_to DATE := FND_API.G_MISS_DATE,
106: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: status_date DATE := FND_API.G_MISS_DATE,
108: modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: offer_amount NUMBER := FND_API.G_MISS_NUM,

Line 107: status_date DATE := FND_API.G_MISS_DATE,

103: object_version_number NUMBER := FND_API.G_MISS_NUM,
104: perf_date_from DATE := FND_API.G_MISS_DATE,
105: perf_date_to DATE := FND_API.G_MISS_DATE,
106: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: status_date DATE := FND_API.G_MISS_DATE,
108: modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: offer_amount NUMBER := FND_API.G_MISS_NUM,
111: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,

Line 108: modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

104: perf_date_from DATE := FND_API.G_MISS_DATE,
105: perf_date_to DATE := FND_API.G_MISS_DATE,
106: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: status_date DATE := FND_API.G_MISS_DATE,
108: modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: offer_amount NUMBER := FND_API.G_MISS_NUM,
111: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,
112: lumpsum_payment_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 109: order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

105: perf_date_to DATE := FND_API.G_MISS_DATE,
106: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: status_date DATE := FND_API.G_MISS_DATE,
108: modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: offer_amount NUMBER := FND_API.G_MISS_NUM,
111: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,
112: lumpsum_payment_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: custom_setup_id NUMBER := FND_API.G_MISS_NUM,

Line 110: offer_amount NUMBER := FND_API.G_MISS_NUM,

106: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: status_date DATE := FND_API.G_MISS_DATE,
108: modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: offer_amount NUMBER := FND_API.G_MISS_NUM,
111: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,
112: lumpsum_payment_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
114: security_group_id NUMBER := FND_API.G_MISS_NUM,

Line 111: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,

107: status_date DATE := FND_API.G_MISS_DATE,
108: modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: offer_amount NUMBER := FND_API.G_MISS_NUM,
111: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,
112: lumpsum_payment_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
114: security_group_id NUMBER := FND_API.G_MISS_NUM,
115: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,

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

108: modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: offer_amount NUMBER := FND_API.G_MISS_NUM,
111: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,
112: lumpsum_payment_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
114: security_group_id NUMBER := FND_API.G_MISS_NUM,
115: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
116: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,

Line 113: custom_setup_id NUMBER := FND_API.G_MISS_NUM,

109: order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: offer_amount NUMBER := FND_API.G_MISS_NUM,
111: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,
112: lumpsum_payment_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
114: security_group_id NUMBER := FND_API.G_MISS_NUM,
115: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
116: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
117: transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 114: security_group_id NUMBER := FND_API.G_MISS_NUM,

110: offer_amount NUMBER := FND_API.G_MISS_NUM,
111: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,
112: lumpsum_payment_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
114: security_group_id NUMBER := FND_API.G_MISS_NUM,
115: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
116: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
117: transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,
118: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 115: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,

111: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,
112: lumpsum_payment_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
114: security_group_id NUMBER := FND_API.G_MISS_NUM,
115: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
116: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
117: transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,
118: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: distribution_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 116: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,

112: lumpsum_payment_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
114: security_group_id NUMBER := FND_API.G_MISS_NUM,
115: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
116: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
117: transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,
118: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: distribution_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: qualifier_id NUMBER := FND_API.G_MISS_NUM,

Line 117: transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,

113: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
114: security_group_id NUMBER := FND_API.G_MISS_NUM,
115: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
116: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
117: transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,
118: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: distribution_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: qualifier_id NUMBER := FND_API.G_MISS_NUM,
121: qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 118: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

114: security_group_id NUMBER := FND_API.G_MISS_NUM,
115: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
116: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
117: transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,
118: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: distribution_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: qualifier_id NUMBER := FND_API.G_MISS_NUM,
121: qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

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

115: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
116: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
117: transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,
118: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: distribution_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: qualifier_id NUMBER := FND_API.G_MISS_NUM,
121: qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 120: qualifier_id NUMBER := FND_API.G_MISS_NUM,

116: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
117: transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,
118: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: distribution_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: qualifier_id NUMBER := FND_API.G_MISS_NUM,
121: qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,
124: break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 121: qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

117: transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,
118: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: distribution_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: qualifier_id NUMBER := FND_API.G_MISS_NUM,
121: qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,
124: break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
125: retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 122: account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

118: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: distribution_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: qualifier_id NUMBER := FND_API.G_MISS_NUM,
121: qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,
124: break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
125: retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 123: budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,

119: distribution_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: qualifier_id NUMBER := FND_API.G_MISS_NUM,
121: qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,
124: break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
125: retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: budget_source_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 124: break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

120: qualifier_id NUMBER := FND_API.G_MISS_NUM,
121: qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,
124: break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
125: retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: budget_source_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: budget_source_id NUMBER := FND_API.G_MISS_NUM,

Line 125: retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,

121: qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,
124: break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
125: retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: budget_source_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: budget_source_id NUMBER := FND_API.G_MISS_NUM,
129: confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 126: volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

122: account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,
124: break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
125: retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: budget_source_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: budget_source_id NUMBER := FND_API.G_MISS_NUM,
129: confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,

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

123: budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,
124: break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
125: retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: budget_source_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: budget_source_id NUMBER := FND_API.G_MISS_NUM,
129: confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,
131: buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 128: budget_source_id NUMBER := FND_API.G_MISS_NUM,

124: break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
125: retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: budget_source_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: budget_source_id NUMBER := FND_API.G_MISS_NUM,
129: confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,
131: buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: last_recal_date DATE := FND_API.G_MISS_DATE,

Line 129: confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

125: retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: budget_source_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: budget_source_id NUMBER := FND_API.G_MISS_NUM,
129: confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,
131: buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: last_recal_date DATE := FND_API.G_MISS_DATE,
133: autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 130: source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,

126: volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: budget_source_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: budget_source_id NUMBER := FND_API.G_MISS_NUM,
129: confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,
131: buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: last_recal_date DATE := FND_API.G_MISS_DATE,
133: autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
134: autopay_days NUMBER := FND_API.G_MISS_NUM,

Line 131: buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

127: budget_source_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: budget_source_id NUMBER := FND_API.G_MISS_NUM,
129: confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,
131: buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: last_recal_date DATE := FND_API.G_MISS_DATE,
133: autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
134: autopay_days NUMBER := FND_API.G_MISS_NUM,
135: autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 132: last_recal_date DATE := FND_API.G_MISS_DATE,

128: budget_source_id NUMBER := FND_API.G_MISS_NUM,
129: confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,
131: buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: last_recal_date DATE := FND_API.G_MISS_DATE,
133: autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
134: autopay_days NUMBER := FND_API.G_MISS_NUM,
135: autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
136: autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 133: autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

129: confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,
131: buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: last_recal_date DATE := FND_API.G_MISS_DATE,
133: autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
134: autopay_days NUMBER := FND_API.G_MISS_NUM,
135: autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
136: autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,
137: autopay_party_id NUMBER := FND_API.G_MISS_NUM,

Line 134: autopay_days NUMBER := FND_API.G_MISS_NUM,

130: source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,
131: buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: last_recal_date DATE := FND_API.G_MISS_DATE,
133: autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
134: autopay_days NUMBER := FND_API.G_MISS_NUM,
135: autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
136: autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,
137: autopay_party_id NUMBER := FND_API.G_MISS_NUM,
138: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 135: autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,

131: buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: last_recal_date DATE := FND_API.G_MISS_DATE,
133: autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
134: autopay_days NUMBER := FND_API.G_MISS_NUM,
135: autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
136: autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,
137: autopay_party_id NUMBER := FND_API.G_MISS_NUM,
138: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,

Line 136: autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,

132: last_recal_date DATE := FND_API.G_MISS_DATE,
133: autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
134: autopay_days NUMBER := FND_API.G_MISS_NUM,
135: autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
136: autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,
137: autopay_party_id NUMBER := FND_API.G_MISS_NUM,
138: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
140: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,

Line 137: autopay_party_id NUMBER := FND_API.G_MISS_NUM,

133: autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
134: autopay_days NUMBER := FND_API.G_MISS_NUM,
135: autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
136: autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,
137: autopay_party_id NUMBER := FND_API.G_MISS_NUM,
138: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
140: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,
141: sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 138: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,

134: autopay_days NUMBER := FND_API.G_MISS_NUM,
135: autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
136: autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,
137: autopay_party_id NUMBER := FND_API.G_MISS_NUM,
138: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
140: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,
141: sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: org_id NUMBER := FND_API.G_MISS_NUM,

Line 139: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,

135: autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
136: autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,
137: autopay_party_id NUMBER := FND_API.G_MISS_NUM,
138: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
140: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,
141: sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: org_id NUMBER := FND_API.G_MISS_NUM,
143: percent_discount NUMBER := FND_API.G_MISS_NUM /*nirprasa, added for ER11806714*/

Line 140: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,

136: autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,
137: autopay_party_id NUMBER := FND_API.G_MISS_NUM,
138: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
140: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,
141: sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: org_id NUMBER := FND_API.G_MISS_NUM,
143: percent_discount NUMBER := FND_API.G_MISS_NUM /*nirprasa, added for ER11806714*/
144: );

Line 141: sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,

137: autopay_party_id NUMBER := FND_API.G_MISS_NUM,
138: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
140: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,
141: sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: org_id NUMBER := FND_API.G_MISS_NUM,
143: percent_discount NUMBER := FND_API.G_MISS_NUM /*nirprasa, added for ER11806714*/
144: );
145:

Line 142: org_id NUMBER := FND_API.G_MISS_NUM,

138: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
140: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,
141: sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: org_id NUMBER := FND_API.G_MISS_NUM,
143: percent_discount NUMBER := FND_API.G_MISS_NUM /*nirprasa, added for ER11806714*/
144: );
145:
146: g_miss_offers_rec offers_rec_type;

Line 143: percent_discount NUMBER := FND_API.G_MISS_NUM /nirprasa, added for ER11806714/

139: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
140: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,
141: sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: org_id NUMBER := FND_API.G_MISS_NUM,
143: percent_discount NUMBER := FND_API.G_MISS_NUM /*nirprasa, added for ER11806714*/
144: );
145:
146: g_miss_offers_rec offers_rec_type;
147: TYPE offers_tbl_type IS TABLE OF offers_rec_type INDEX BY BINARY_INTEGER;

Line 163: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

159: -- Parameters
160: --
161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_offers_rec IN offers_rec_type Required
167: --

Line 164: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

160: --
161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_offers_rec IN offers_rec_type Required
167: --
168: -- OUT

Line 165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_offers_rec IN offers_rec_type Required
167: --
168: -- OUT
169: -- x_return_status OUT VARCHAR2

Line 182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

178: --
179:
180: PROCEDURE Create_Offers(
181: p_api_version_number IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183: p_commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185:
186: x_return_status OUT NOCOPY VARCHAR2,

Line 183: p_commit IN VARCHAR2 := FND_API.G_FALSE,

179:
180: PROCEDURE Create_Offers(
181: p_api_version_number IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183: p_commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185:
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,

Line 184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

180: PROCEDURE Create_Offers(
181: p_api_version_number IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183: p_commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185:
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,

Line 207: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

203: -- Parameters
204: --
205: -- IN
206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210: -- p_offers_rec IN offers_rec_type Required
211: --

Line 208: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

204: --
205: -- IN
206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210: -- p_offers_rec IN offers_rec_type Required
211: --
212: -- OUT

Line 209: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

205: -- IN
206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210: -- p_offers_rec IN offers_rec_type Required
211: --
212: -- OUT
213: -- x_return_status OUT VARCHAR2

Line 226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

222: --
223:
224: PROCEDURE Update_Offers(
225: p_api_version_number IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229:
230: x_return_status OUT NOCOPY VARCHAR2,

Line 227: p_commit IN VARCHAR2 := FND_API.G_FALSE,

223:
224: PROCEDURE Update_Offers(
225: p_api_version_number IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229:
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,

Line 228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

224: PROCEDURE Update_Offers(
225: p_api_version_number IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229:
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,

Line 251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

247: -- Parameters
248: --
249: -- IN
250: -- p_api_version_number IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254: -- p_OFFER_ID IN NUMBER
255: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

248: --
249: -- IN
250: -- p_api_version_number IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254: -- p_OFFER_ID IN NUMBER
255: -- p_object_version_number IN NUMBER Optional Default = NULL
256: --

Line 253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

249: -- IN
250: -- p_api_version_number IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254: -- p_OFFER_ID IN NUMBER
255: -- p_object_version_number IN NUMBER Optional Default = NULL
256: --
257: -- OUT

Line 271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

267: --
268:
269: PROCEDURE Delete_Offers(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,

Line 272: p_commit IN VARCHAR2 := FND_API.G_FALSE,

268:
269: PROCEDURE Delete_Offers(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,

Line 273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

269: PROCEDURE Delete_Offers(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_offer_id IN NUMBER,

Line 294: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

290: -- Parameters
291: --
292: -- IN
293: -- p_api_version_number IN NUMBER Required
294: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
295: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297: -- p_offers_rec IN offers_rec_type Required
298: --

Line 295: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

291: --
292: -- IN
293: -- p_api_version_number IN NUMBER Required
294: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
295: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297: -- p_offers_rec IN offers_rec_type Required
298: --
299: -- OUT

Line 296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

292: -- IN
293: -- p_api_version_number IN NUMBER Required
294: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
295: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297: -- p_offers_rec IN offers_rec_type Required
298: --
299: -- OUT
300: -- x_return_status OUT VARCHAR2

Line 313: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

309: --
310:
311: PROCEDURE Lock_Offers(
312: p_api_version_number IN NUMBER,
313: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
314:
315: x_return_status OUT NOCOPY VARCHAR2,
316: x_msg_count OUT NOCOPY NUMBER,
317: x_msg_data OUT NOCOPY VARCHAR2,

Line 337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

333: -- End of Comments
334:
335: PROCEDURE Validate_offers(
336: p_api_version_number IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
339: p_offers_rec IN offers_rec_type,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,

Line 338: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

334:
335: PROCEDURE Validate_offers(
336: p_api_version_number IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
339: p_offers_rec IN offers_rec_type,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2

Line 375: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

371: -- End of Comments
372:
373: PROCEDURE Validate_offers_rec(
374: p_api_version_number IN NUMBER,
375: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,
378: x_msg_data OUT NOCOPY VARCHAR2,
379: p_offers_rec IN offers_rec_type