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 86: offer_id NUMBER := FND_API.G_MISS_NUM,

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

Line 87: qp_list_header_id NUMBER := FND_API.G_MISS_NUM,

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

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

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

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

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

Line 90: activity_media_id NUMBER := FND_API.G_MISS_NUM,

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

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

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

Line 92: user_status_id NUMBER := FND_API.G_MISS_NUM,

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

Line 93: owner_id NUMBER := FND_API.G_MISS_NUM,

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

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

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

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

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

Line 96: buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,

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

Line 97: last_update_date DATE := FND_API.G_MISS_DATE,

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

Line 98: last_updated_by NUMBER := FND_API.G_MISS_NUM,

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

Line 99: creation_date DATE := FND_API.G_MISS_DATE,

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

Line 100: created_by NUMBER := FND_API.G_MISS_NUM,

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

Line 101: last_update_login NUMBER := FND_API.G_MISS_NUM,

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

Line 102: object_version_number NUMBER := FND_API.G_MISS_NUM,

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

Line 103: perf_date_from DATE := FND_API.G_MISS_DATE,

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

Line 104: perf_date_to DATE := FND_API.G_MISS_DATE,

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

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

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

Line 106: status_date DATE := FND_API.G_MISS_DATE,

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

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

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

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

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

Line 109: offer_amount NUMBER := FND_API.G_MISS_NUM,

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

Line 110: lumpsum_amount NUMBER := FND_API.G_MISS_NUM,

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

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

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

Line 112: custom_setup_id NUMBER := FND_API.G_MISS_NUM,

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

Line 113: security_group_id NUMBER := FND_API.G_MISS_NUM,

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

Line 114: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,

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

Line 115: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,

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

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

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

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

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

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

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

Line 119: qualifier_id NUMBER := FND_API.G_MISS_NUM,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 127: budget_source_id NUMBER := FND_API.G_MISS_NUM,

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

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

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

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

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

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

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

Line 131: last_recal_date DATE := FND_API.G_MISS_DATE,

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

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

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

Line 133: autopay_days NUMBER := FND_API.G_MISS_NUM,

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

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

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

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

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

Line 136: autopay_party_id NUMBER := FND_API.G_MISS_NUM,

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

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

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

Line 138: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,

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

Line 139: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,

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

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

136: autopay_party_id NUMBER := FND_API.G_MISS_NUM,
137: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
138: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
139: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,
140: sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
141: org_id NUMBER := FND_API.G_MISS_NUM
142: );
143:
144: g_miss_offers_rec offers_rec_type;

Line 141: org_id NUMBER := FND_API.G_MISS_NUM

137: tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
138: na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
139: beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,
140: sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
141: org_id NUMBER := FND_API.G_MISS_NUM
142: );
143:
144: g_miss_offers_rec offers_rec_type;
145: TYPE offers_tbl_type IS TABLE OF offers_rec_type INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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