13: * callers must pass it in their calls. This parameter is used by the API to
14: * compare the version numbers of incoming calls to its current version number,
15: * and to return an unexpected error if they are incompatible. Pass 2.0 unless
16: * otherwise indicated in the API parameter list.
16: * otherwise indicated in the API parameter list.
19: * the message list on their behalf.
20: *
41: * Standard OUT parameters: The following list describes standard OUT parameters
42: * which are common to all public APIs provided by Oracle Sales products.
43: *
43: *
45: *
75: -- Opportunity Header Type
76: --
77:
78: TYPE header_rec_type IS RECORD
79: ( last_update_date Date := FND_API.G_MISS_DATE,
80: last_updated_by Number := FND_API.G_MISS_NUM,
81: creation_Date Date := FND_API.G_MISS_DATE,
82: created_by Number := FND_API.G_MISS_NUM,
83: last_update_login Number := FND_API.G_MISS_NUM,
76: --
77:
78: TYPE header_rec_type IS RECORD
79: ( last_update_date Date := FND_API.G_MISS_DATE,
80: last_updated_by Number := FND_API.G_MISS_NUM,
81: creation_Date Date := FND_API.G_MISS_DATE,
82: created_by Number := FND_API.G_MISS_NUM,
83: last_update_login Number := FND_API.G_MISS_NUM,
84: request_id NUMBER := FND_API.G_MISS_NUM,
77:
78: TYPE header_rec_type IS RECORD
79: ( last_update_date Date := FND_API.G_MISS_DATE,
80: last_updated_by Number := FND_API.G_MISS_NUM,
81: creation_Date Date := FND_API.G_MISS_DATE,
82: created_by Number := FND_API.G_MISS_NUM,
83: last_update_login Number := FND_API.G_MISS_NUM,
84: request_id NUMBER := FND_API.G_MISS_NUM,
85: program_application_id NUMBER := FND_API.G_MISS_NUM,
78: TYPE header_rec_type IS RECORD
79: ( last_update_date Date := FND_API.G_MISS_DATE,
80: last_updated_by Number := FND_API.G_MISS_NUM,
81: creation_Date Date := FND_API.G_MISS_DATE,
82: created_by Number := FND_API.G_MISS_NUM,
83: last_update_login Number := FND_API.G_MISS_NUM,
84: request_id NUMBER := FND_API.G_MISS_NUM,
85: program_application_id NUMBER := FND_API.G_MISS_NUM,
86: program_id NUMBER := FND_API.G_MISS_NUM,
79: ( last_update_date Date := FND_API.G_MISS_DATE,
80: last_updated_by Number := FND_API.G_MISS_NUM,
81: creation_Date Date := FND_API.G_MISS_DATE,
82: created_by Number := FND_API.G_MISS_NUM,
83: last_update_login Number := FND_API.G_MISS_NUM,
84: request_id NUMBER := FND_API.G_MISS_NUM,
85: program_application_id NUMBER := FND_API.G_MISS_NUM,
86: program_id NUMBER := FND_API.G_MISS_NUM,
87: program_update_date DATE := FND_API.G_MISS_DATE,
80: last_updated_by Number := FND_API.G_MISS_NUM,
81: creation_Date Date := FND_API.G_MISS_DATE,
82: created_by Number := FND_API.G_MISS_NUM,
83: last_update_login Number := FND_API.G_MISS_NUM,
84: request_id NUMBER := FND_API.G_MISS_NUM,
85: program_application_id NUMBER := FND_API.G_MISS_NUM,
86: program_id NUMBER := FND_API.G_MISS_NUM,
87: program_update_date DATE := FND_API.G_MISS_DATE,
88: lead_id NUMBER := FND_API.G_MISS_NUM,
81: creation_Date Date := FND_API.G_MISS_DATE,
82: created_by Number := FND_API.G_MISS_NUM,
83: last_update_login Number := FND_API.G_MISS_NUM,
84: request_id NUMBER := FND_API.G_MISS_NUM,
85: program_application_id NUMBER := FND_API.G_MISS_NUM,
86: program_id NUMBER := FND_API.G_MISS_NUM,
87: program_update_date DATE := FND_API.G_MISS_DATE,
88: lead_id NUMBER := FND_API.G_MISS_NUM,
89: lead_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: created_by Number := FND_API.G_MISS_NUM,
83: last_update_login Number := FND_API.G_MISS_NUM,
84: request_id NUMBER := FND_API.G_MISS_NUM,
85: program_application_id NUMBER := FND_API.G_MISS_NUM,
86: program_id NUMBER := FND_API.G_MISS_NUM,
87: program_update_date DATE := FND_API.G_MISS_DATE,
88: lead_id NUMBER := FND_API.G_MISS_NUM,
89: lead_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: last_update_login Number := FND_API.G_MISS_NUM,
84: request_id NUMBER := FND_API.G_MISS_NUM,
85: program_application_id NUMBER := FND_API.G_MISS_NUM,
86: program_id NUMBER := FND_API.G_MISS_NUM,
87: program_update_date DATE := FND_API.G_MISS_DATE,
88: lead_id NUMBER := FND_API.G_MISS_NUM,
89: lead_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: lead_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: request_id NUMBER := FND_API.G_MISS_NUM,
85: program_application_id NUMBER := FND_API.G_MISS_NUM,
86: program_id NUMBER := FND_API.G_MISS_NUM,
87: program_update_date DATE := FND_API.G_MISS_DATE,
88: lead_id NUMBER := FND_API.G_MISS_NUM,
89: lead_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: lead_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: lead_source VARCHAR2(80) := FND_API.G_MISS_CHAR,
85: program_application_id NUMBER := FND_API.G_MISS_NUM,
86: program_id NUMBER := FND_API.G_MISS_NUM,
87: program_update_date DATE := FND_API.G_MISS_DATE,
88: lead_id NUMBER := FND_API.G_MISS_NUM,
89: lead_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: lead_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: lead_source VARCHAR2(80) := FND_API.G_MISS_CHAR,
93: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: program_id NUMBER := FND_API.G_MISS_NUM,
87: program_update_date DATE := FND_API.G_MISS_DATE,
88: lead_id NUMBER := FND_API.G_MISS_NUM,
89: lead_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: lead_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: lead_source VARCHAR2(80) := FND_API.G_MISS_CHAR,
93: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: source_promotion_id NUMBER := FND_API.G_MISS_NUM,
87: program_update_date DATE := FND_API.G_MISS_DATE,
88: lead_id NUMBER := FND_API.G_MISS_NUM,
89: lead_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: lead_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: lead_source VARCHAR2(80) := FND_API.G_MISS_CHAR,
93: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: source_promotion_id NUMBER := FND_API.G_MISS_NUM,
95: source_promotion_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: lead_id NUMBER := FND_API.G_MISS_NUM,
89: lead_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: lead_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: lead_source VARCHAR2(80) := FND_API.G_MISS_CHAR,
93: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: source_promotion_id NUMBER := FND_API.G_MISS_NUM,
95: source_promotion_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: customer_id NUMBER := FND_API.G_MISS_NUM,
89: lead_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: lead_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: lead_source VARCHAR2(80) := FND_API.G_MISS_CHAR,
93: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: source_promotion_id NUMBER := FND_API.G_MISS_NUM,
95: source_promotion_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: customer_id NUMBER := FND_API.G_MISS_NUM,
97: customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
90: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: lead_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: lead_source VARCHAR2(80) := FND_API.G_MISS_CHAR,
93: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: source_promotion_id NUMBER := FND_API.G_MISS_NUM,
95: source_promotion_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: customer_id NUMBER := FND_API.G_MISS_NUM,
97: customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: customer_name_phonetic VARCHAR2(360) := FND_API.G_MISS_CHAR,
91: lead_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: lead_source VARCHAR2(80) := FND_API.G_MISS_CHAR,
93: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: source_promotion_id NUMBER := FND_API.G_MISS_NUM,
95: source_promotion_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: customer_id NUMBER := FND_API.G_MISS_NUM,
97: customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: customer_name_phonetic VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: address_id NUMBER := FND_API.G_MISS_NUM,
92: lead_source VARCHAR2(80) := FND_API.G_MISS_CHAR,
93: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: source_promotion_id NUMBER := FND_API.G_MISS_NUM,
95: source_promotion_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: customer_id NUMBER := FND_API.G_MISS_NUM,
97: customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: customer_name_phonetic VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: address_id NUMBER := FND_API.G_MISS_NUM,
100: address VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: source_promotion_id NUMBER := FND_API.G_MISS_NUM,
95: source_promotion_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: customer_id NUMBER := FND_API.G_MISS_NUM,
97: customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: customer_name_phonetic VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: address_id NUMBER := FND_API.G_MISS_NUM,
100: address VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: source_promotion_id NUMBER := FND_API.G_MISS_NUM,
95: source_promotion_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: customer_id NUMBER := FND_API.G_MISS_NUM,
97: customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: customer_name_phonetic VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: address_id NUMBER := FND_API.G_MISS_NUM,
100: address VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: source_promotion_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: customer_id NUMBER := FND_API.G_MISS_NUM,
97: customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: customer_name_phonetic VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: address_id NUMBER := FND_API.G_MISS_NUM,
100: address VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: customer_id NUMBER := FND_API.G_MISS_NUM,
97: customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: customer_name_phonetic VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: address_id NUMBER := FND_API.G_MISS_NUM,
100: address VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
97: customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: customer_name_phonetic VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: address_id NUMBER := FND_API.G_MISS_NUM,
100: address VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
105: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
98: customer_name_phonetic VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: address_id NUMBER := FND_API.G_MISS_NUM,
100: address VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
105: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
99: address_id NUMBER := FND_API.G_MISS_NUM,
100: address VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
105: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
107: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
100: address VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
105: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
107: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
108: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
101: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
105: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
107: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
108: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
109: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
102: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
105: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
107: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
108: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
109: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
110: win_probability NUMBER := FND_API.G_MISS_NUM,
103: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
105: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
107: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
108: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
109: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
110: win_probability NUMBER := FND_API.G_MISS_NUM,
111: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
105: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
107: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
108: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
109: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
110: win_probability NUMBER := FND_API.G_MISS_NUM,
111: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: status VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
107: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
108: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
109: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
110: win_probability NUMBER := FND_API.G_MISS_NUM,
111: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: status VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: total_amount NUMBER := FND_API.G_MISS_NUM,
106: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
107: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
108: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
109: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
110: win_probability NUMBER := FND_API.G_MISS_NUM,
111: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: status VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: total_amount NUMBER := FND_API.G_MISS_NUM,
114: converted_total_amount NUMBER := FND_API.G_MISS_NUM,
107: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
108: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
109: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
110: win_probability NUMBER := FND_API.G_MISS_NUM,
111: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: status VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: total_amount NUMBER := FND_API.G_MISS_NUM,
114: converted_total_amount NUMBER := FND_API.G_MISS_NUM,
115: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
109: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
110: win_probability NUMBER := FND_API.G_MISS_NUM,
111: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: status VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: total_amount NUMBER := FND_API.G_MISS_NUM,
114: converted_total_amount NUMBER := FND_API.G_MISS_NUM,
115: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
109: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
110: win_probability NUMBER := FND_API.G_MISS_NUM,
111: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: status VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: total_amount NUMBER := FND_API.G_MISS_NUM,
114: converted_total_amount NUMBER := FND_API.G_MISS_NUM,
115: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
117: decision_date DATE := FND_API.G_MISS_DATE,
110: win_probability NUMBER := FND_API.G_MISS_NUM,
111: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: status VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: total_amount NUMBER := FND_API.G_MISS_NUM,
114: converted_total_amount NUMBER := FND_API.G_MISS_NUM,
115: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
117: decision_date DATE := FND_API.G_MISS_DATE,
118: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
111: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: status VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: total_amount NUMBER := FND_API.G_MISS_NUM,
114: converted_total_amount NUMBER := FND_API.G_MISS_NUM,
115: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
117: decision_date DATE := FND_API.G_MISS_DATE,
118: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
112: status VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: total_amount NUMBER := FND_API.G_MISS_NUM,
114: converted_total_amount NUMBER := FND_API.G_MISS_NUM,
115: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
117: decision_date DATE := FND_API.G_MISS_DATE,
118: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
120: close_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: total_amount NUMBER := FND_API.G_MISS_NUM,
114: converted_total_amount NUMBER := FND_API.G_MISS_NUM,
115: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
117: decision_date DATE := FND_API.G_MISS_DATE,
118: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
120: close_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: close_reason VARCHAR2(80) := FND_API.G_MISS_CHAR,
114: converted_total_amount NUMBER := FND_API.G_MISS_NUM,
115: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
117: decision_date DATE := FND_API.G_MISS_DATE,
118: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
120: close_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: close_reason VARCHAR2(80) := FND_API.G_MISS_CHAR,
122: close_competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
117: decision_date DATE := FND_API.G_MISS_DATE,
118: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
120: close_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: close_reason VARCHAR2(80) := FND_API.G_MISS_CHAR,
122: close_competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: close_competitor_id NUMBER := FND_API.G_MISS_NUM,
116: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
117: decision_date DATE := FND_API.G_MISS_DATE,
118: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
120: close_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: close_reason VARCHAR2(80) := FND_API.G_MISS_CHAR,
122: close_competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: close_competitor_id NUMBER := FND_API.G_MISS_NUM,
124: close_competitor VARCHAR2(360) := FND_API.G_MISS_CHAR,
117: decision_date DATE := FND_API.G_MISS_DATE,
118: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
120: close_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: close_reason VARCHAR2(80) := FND_API.G_MISS_CHAR,
122: close_competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: close_competitor_id NUMBER := FND_API.G_MISS_NUM,
124: close_competitor VARCHAR2(360) := FND_API.G_MISS_CHAR,
125: close_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119: to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
120: close_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: close_reason VARCHAR2(80) := FND_API.G_MISS_CHAR,
122: close_competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: close_competitor_id NUMBER := FND_API.G_MISS_NUM,
124: close_competitor VARCHAR2(360) := FND_API.G_MISS_CHAR,
125: close_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: end_user_customer_id NUMBER := FND_API.G_MISS_NUM,
119: to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
120: close_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: close_reason VARCHAR2(80) := FND_API.G_MISS_CHAR,
122: close_competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: close_competitor_id NUMBER := FND_API.G_MISS_NUM,
124: close_competitor VARCHAR2(360) := FND_API.G_MISS_CHAR,
125: close_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: end_user_customer_id NUMBER := FND_API.G_MISS_NUM,
127: end_user_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
120: close_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: close_reason VARCHAR2(80) := FND_API.G_MISS_CHAR,
122: close_competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: close_competitor_id NUMBER := FND_API.G_MISS_NUM,
124: close_competitor VARCHAR2(360) := FND_API.G_MISS_CHAR,
125: close_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: end_user_customer_id NUMBER := FND_API.G_MISS_NUM,
127: end_user_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
128: end_user_address_id NUMBER := FND_API.G_MISS_NUM,
121: close_reason VARCHAR2(80) := FND_API.G_MISS_CHAR,
122: close_competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: close_competitor_id NUMBER := FND_API.G_MISS_NUM,
124: close_competitor VARCHAR2(360) := FND_API.G_MISS_CHAR,
125: close_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: end_user_customer_id NUMBER := FND_API.G_MISS_NUM,
127: end_user_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
128: end_user_address_id NUMBER := FND_API.G_MISS_NUM,
129: owner_salesforce_id NUMBER := FND_API.G_MISS_NUM,
122: close_competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: close_competitor_id NUMBER := FND_API.G_MISS_NUM,
124: close_competitor VARCHAR2(360) := FND_API.G_MISS_CHAR,
125: close_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: end_user_customer_id NUMBER := FND_API.G_MISS_NUM,
127: end_user_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
128: end_user_address_id NUMBER := FND_API.G_MISS_NUM,
129: owner_salesforce_id NUMBER := FND_API.G_MISS_NUM,
130: owner_sales_group_id NUMBER := FND_API.G_MISS_NUM,
123: close_competitor_id NUMBER := FND_API.G_MISS_NUM,
124: close_competitor VARCHAR2(360) := FND_API.G_MISS_CHAR,
125: close_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: end_user_customer_id NUMBER := FND_API.G_MISS_NUM,
127: end_user_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
128: end_user_address_id NUMBER := FND_API.G_MISS_NUM,
129: owner_salesforce_id NUMBER := FND_API.G_MISS_NUM,
130: owner_sales_group_id NUMBER := FND_API.G_MISS_NUM,
131: -- owner_assign_date DATE := FND_API.G_MISS_DATE,
124: close_competitor VARCHAR2(360) := FND_API.G_MISS_CHAR,
125: close_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: end_user_customer_id NUMBER := FND_API.G_MISS_NUM,
127: end_user_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
128: end_user_address_id NUMBER := FND_API.G_MISS_NUM,
129: owner_salesforce_id NUMBER := FND_API.G_MISS_NUM,
130: owner_sales_group_id NUMBER := FND_API.G_MISS_NUM,
131: -- owner_assign_date DATE := FND_API.G_MISS_DATE,
132: parent_project VARCHAR2(80) := FND_API.G_MISS_CHAR,
125: close_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: end_user_customer_id NUMBER := FND_API.G_MISS_NUM,
127: end_user_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
128: end_user_address_id NUMBER := FND_API.G_MISS_NUM,
129: owner_salesforce_id NUMBER := FND_API.G_MISS_NUM,
130: owner_sales_group_id NUMBER := FND_API.G_MISS_NUM,
131: -- owner_assign_date DATE := FND_API.G_MISS_DATE,
132: parent_project VARCHAR2(80) := FND_API.G_MISS_CHAR,
133: parent_project_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: end_user_customer_id NUMBER := FND_API.G_MISS_NUM,
127: end_user_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
128: end_user_address_id NUMBER := FND_API.G_MISS_NUM,
129: owner_salesforce_id NUMBER := FND_API.G_MISS_NUM,
130: owner_sales_group_id NUMBER := FND_API.G_MISS_NUM,
131: -- owner_assign_date DATE := FND_API.G_MISS_DATE,
132: parent_project VARCHAR2(80) := FND_API.G_MISS_CHAR,
133: parent_project_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: updateable_flag VARCHAR2(1) := 'N',
127: end_user_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
128: end_user_address_id NUMBER := FND_API.G_MISS_NUM,
129: owner_salesforce_id NUMBER := FND_API.G_MISS_NUM,
130: owner_sales_group_id NUMBER := FND_API.G_MISS_NUM,
131: -- owner_assign_date DATE := FND_API.G_MISS_DATE,
132: parent_project VARCHAR2(80) := FND_API.G_MISS_CHAR,
133: parent_project_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: updateable_flag VARCHAR2(1) := 'N',
135: price_list_id Number := FND_API.G_MISS_NUM,
128: end_user_address_id NUMBER := FND_API.G_MISS_NUM,
129: owner_salesforce_id NUMBER := FND_API.G_MISS_NUM,
130: owner_sales_group_id NUMBER := FND_API.G_MISS_NUM,
131: -- owner_assign_date DATE := FND_API.G_MISS_DATE,
132: parent_project VARCHAR2(80) := FND_API.G_MISS_CHAR,
133: parent_project_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: updateable_flag VARCHAR2(1) := 'N',
135: price_list_id Number := FND_API.G_MISS_NUM,
136: initiating_contact_id Number := FND_API.G_MISS_NUM,
129: owner_salesforce_id NUMBER := FND_API.G_MISS_NUM,
130: owner_sales_group_id NUMBER := FND_API.G_MISS_NUM,
131: -- owner_assign_date DATE := FND_API.G_MISS_DATE,
132: parent_project VARCHAR2(80) := FND_API.G_MISS_CHAR,
133: parent_project_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: updateable_flag VARCHAR2(1) := 'N',
135: price_list_id Number := FND_API.G_MISS_NUM,
136: initiating_contact_id Number := FND_API.G_MISS_NUM,
137: rank Varchar2(30) := FND_API.G_MISS_CHAR,
131: -- owner_assign_date DATE := FND_API.G_MISS_DATE,
132: parent_project VARCHAR2(80) := FND_API.G_MISS_CHAR,
133: parent_project_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: updateable_flag VARCHAR2(1) := 'N',
135: price_list_id Number := FND_API.G_MISS_NUM,
136: initiating_contact_id Number := FND_API.G_MISS_NUM,
137: rank Varchar2(30) := FND_API.G_MISS_CHAR,
138: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
139: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
132: parent_project VARCHAR2(80) := FND_API.G_MISS_CHAR,
133: parent_project_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: updateable_flag VARCHAR2(1) := 'N',
135: price_list_id Number := FND_API.G_MISS_NUM,
136: initiating_contact_id Number := FND_API.G_MISS_NUM,
137: rank Varchar2(30) := FND_API.G_MISS_CHAR,
138: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
139: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
140: Deleted_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
133: parent_project_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: updateable_flag VARCHAR2(1) := 'N',
135: price_list_id Number := FND_API.G_MISS_NUM,
136: initiating_contact_id Number := FND_API.G_MISS_NUM,
137: rank Varchar2(30) := FND_API.G_MISS_CHAR,
138: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
139: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
140: Deleted_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
141: Auto_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: updateable_flag VARCHAR2(1) := 'N',
135: price_list_id Number := FND_API.G_MISS_NUM,
136: initiating_contact_id Number := FND_API.G_MISS_NUM,
137: rank Varchar2(30) := FND_API.G_MISS_CHAR,
138: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
139: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
140: Deleted_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
141: Auto_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: PRM_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
135: price_list_id Number := FND_API.G_MISS_NUM,
136: initiating_contact_id Number := FND_API.G_MISS_NUM,
137: rank Varchar2(30) := FND_API.G_MISS_CHAR,
138: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
139: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
140: Deleted_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
141: Auto_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: PRM_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
143: Customer_budget NUMBER := FND_API.G_MISS_NUM,
136: initiating_contact_id Number := FND_API.G_MISS_NUM,
137: rank Varchar2(30) := FND_API.G_MISS_CHAR,
138: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
139: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
140: Deleted_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
141: Auto_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: PRM_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
143: Customer_budget NUMBER := FND_API.G_MISS_NUM,
144: Methodology_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
137: rank Varchar2(30) := FND_API.G_MISS_CHAR,
138: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
139: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
140: Deleted_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
141: Auto_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: PRM_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
143: Customer_budget NUMBER := FND_API.G_MISS_NUM,
144: Methodology_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: Sales_Methodology_Id NUMBER := FND_API.G_MISS_NUM,
138: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
139: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
140: Deleted_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
141: Auto_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: PRM_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
143: Customer_budget NUMBER := FND_API.G_MISS_NUM,
144: Methodology_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: Sales_Methodology_Id NUMBER := FND_API.G_MISS_NUM,
146: Original_Lead_Id NUMBER := FND_API.G_MISS_NUM,
139: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
140: Deleted_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
141: Auto_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: PRM_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
143: Customer_budget NUMBER := FND_API.G_MISS_NUM,
144: Methodology_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: Sales_Methodology_Id NUMBER := FND_API.G_MISS_NUM,
146: Original_Lead_Id NUMBER := FND_API.G_MISS_NUM,
147: Decision_Timeframe_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
140: Deleted_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
141: Auto_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: PRM_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
143: Customer_budget NUMBER := FND_API.G_MISS_NUM,
144: Methodology_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: Sales_Methodology_Id NUMBER := FND_API.G_MISS_NUM,
146: Original_Lead_Id NUMBER := FND_API.G_MISS_NUM,
147: Decision_Timeframe_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: Incumbent_partner_Resource_Id NUMBER := FND_API.G_MISS_NUM,
141: Auto_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: PRM_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
143: Customer_budget NUMBER := FND_API.G_MISS_NUM,
144: Methodology_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: Sales_Methodology_Id NUMBER := FND_API.G_MISS_NUM,
146: Original_Lead_Id NUMBER := FND_API.G_MISS_NUM,
147: Decision_Timeframe_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: Incumbent_partner_Resource_Id NUMBER := FND_API.G_MISS_NUM,
149: Incumbent_partner_Party_Id NUMBER := FND_API.G_MISS_NUM,
142: PRM_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
143: Customer_budget NUMBER := FND_API.G_MISS_NUM,
144: Methodology_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: Sales_Methodology_Id NUMBER := FND_API.G_MISS_NUM,
146: Original_Lead_Id NUMBER := FND_API.G_MISS_NUM,
147: Decision_Timeframe_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: Incumbent_partner_Resource_Id NUMBER := FND_API.G_MISS_NUM,
149: Incumbent_partner_Party_Id NUMBER := FND_API.G_MISS_NUM,
150: Offer_Id NUMBER := FND_API.G_MISS_NUM,
143: Customer_budget NUMBER := FND_API.G_MISS_NUM,
144: Methodology_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: Sales_Methodology_Id NUMBER := FND_API.G_MISS_NUM,
146: Original_Lead_Id NUMBER := FND_API.G_MISS_NUM,
147: Decision_Timeframe_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: Incumbent_partner_Resource_Id NUMBER := FND_API.G_MISS_NUM,
149: Incumbent_partner_Party_Id NUMBER := FND_API.G_MISS_NUM,
150: Offer_Id NUMBER := FND_API.G_MISS_NUM,
151: Vehicle_Response_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: Methodology_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: Sales_Methodology_Id NUMBER := FND_API.G_MISS_NUM,
146: Original_Lead_Id NUMBER := FND_API.G_MISS_NUM,
147: Decision_Timeframe_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: Incumbent_partner_Resource_Id NUMBER := FND_API.G_MISS_NUM,
149: Incumbent_partner_Party_Id NUMBER := FND_API.G_MISS_NUM,
150: Offer_Id NUMBER := FND_API.G_MISS_NUM,
151: Vehicle_Response_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: Budget_Status_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: Sales_Methodology_Id NUMBER := FND_API.G_MISS_NUM,
146: Original_Lead_Id NUMBER := FND_API.G_MISS_NUM,
147: Decision_Timeframe_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: Incumbent_partner_Resource_Id NUMBER := FND_API.G_MISS_NUM,
149: Incumbent_partner_Party_Id NUMBER := FND_API.G_MISS_NUM,
150: Offer_Id NUMBER := FND_API.G_MISS_NUM,
151: Vehicle_Response_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: Budget_Status_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: FOLLOWUP_DATE DATE := FND_API.G_MISS_DATE,
146: Original_Lead_Id NUMBER := FND_API.G_MISS_NUM,
147: Decision_Timeframe_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: Incumbent_partner_Resource_Id NUMBER := FND_API.G_MISS_NUM,
149: Incumbent_partner_Party_Id NUMBER := FND_API.G_MISS_NUM,
150: Offer_Id NUMBER := FND_API.G_MISS_NUM,
151: Vehicle_Response_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: Budget_Status_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: FOLLOWUP_DATE DATE := FND_API.G_MISS_DATE,
154: NO_OPP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
147: Decision_Timeframe_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: Incumbent_partner_Resource_Id NUMBER := FND_API.G_MISS_NUM,
149: Incumbent_partner_Party_Id NUMBER := FND_API.G_MISS_NUM,
150: Offer_Id NUMBER := FND_API.G_MISS_NUM,
151: Vehicle_Response_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: Budget_Status_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: FOLLOWUP_DATE DATE := FND_API.G_MISS_DATE,
154: NO_OPP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: DELETE_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
148: Incumbent_partner_Resource_Id NUMBER := FND_API.G_MISS_NUM,
149: Incumbent_partner_Party_Id NUMBER := FND_API.G_MISS_NUM,
150: Offer_Id NUMBER := FND_API.G_MISS_NUM,
151: Vehicle_Response_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: Budget_Status_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: FOLLOWUP_DATE DATE := FND_API.G_MISS_DATE,
154: NO_OPP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: DELETE_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
156: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
149: Incumbent_partner_Party_Id NUMBER := FND_API.G_MISS_NUM,
150: Offer_Id NUMBER := FND_API.G_MISS_NUM,
151: Vehicle_Response_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: Budget_Status_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: FOLLOWUP_DATE DATE := FND_API.G_MISS_DATE,
154: NO_OPP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: DELETE_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
156: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
157: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
150: Offer_Id NUMBER := FND_API.G_MISS_NUM,
151: Vehicle_Response_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: Budget_Status_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: FOLLOWUP_DATE DATE := FND_API.G_MISS_DATE,
154: NO_OPP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: DELETE_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
156: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
157: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
158: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: Vehicle_Response_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: Budget_Status_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: FOLLOWUP_DATE DATE := FND_API.G_MISS_DATE,
154: NO_OPP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: DELETE_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
156: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
157: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
158: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: PRM_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: Budget_Status_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: FOLLOWUP_DATE DATE := FND_API.G_MISS_DATE,
154: NO_OPP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: DELETE_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
156: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
157: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
158: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: PRM_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: ORG_ID NUMBER := FND_API.G_MISS_NUM,
153: FOLLOWUP_DATE DATE := FND_API.G_MISS_DATE,
154: NO_OPP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: DELETE_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
156: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
157: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
158: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: PRM_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: ORG_ID NUMBER := FND_API.G_MISS_NUM,
161: freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: NO_OPP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: DELETE_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
156: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
157: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
158: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: PRM_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: ORG_ID NUMBER := FND_API.G_MISS_NUM,
161: freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: attribute_category VARCHAR2(30),
155: DELETE_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
156: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
157: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
158: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: PRM_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: ORG_ID NUMBER := FND_API.G_MISS_NUM,
161: freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: attribute_category VARCHAR2(30),
163: attribute1 VARCHAR2(150),
156: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
157: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
158: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: PRM_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: ORG_ID NUMBER := FND_API.G_MISS_NUM,
161: freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: attribute_category VARCHAR2(30),
163: attribute1 VARCHAR2(150),
164: attribute2 VARCHAR2(150),
157: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
158: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: PRM_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: ORG_ID NUMBER := FND_API.G_MISS_NUM,
161: freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: attribute_category VARCHAR2(30),
163: attribute1 VARCHAR2(150),
164: attribute2 VARCHAR2(150),
165: attribute3 VARCHAR2(150),
174: attribute12 VARCHAR2(150),
175: attribute13 VARCHAR2(150),
176: attribute14 VARCHAR2(150),
177: attribute15 VARCHAR2(150),
178: PRM_REFERRAL_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
179: TOTAL_REVENUE_OPP_FORECAST_AMT NUMBER := FND_API.G_MISS_NUM -- Added for ASNB
180: );
181:
182: G_MISS_HEADER_REC header_rec_type;
175: attribute13 VARCHAR2(150),
176: attribute14 VARCHAR2(150),
177: attribute15 VARCHAR2(150),
178: PRM_REFERRAL_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
179: TOTAL_REVENUE_OPP_FORECAST_AMT NUMBER := FND_API.G_MISS_NUM -- Added for ASNB
180: );
181:
182: G_MISS_HEADER_REC header_rec_type;
183: TYPE header_tbl_type IS TABLE OF header_rec_type
190: -- Opportunity Line Record Type
191: --
192:
193: TYPE line_rec_type IS RECORD
194: ( last_update_date Date := FND_API.G_MISS_DATE,
195: last_updated_by Number := FND_API.G_MISS_NUM,
196: creation_Date Date := FND_API.G_MISS_DATE,
197: created_by Number := FND_API.G_MISS_NUM,
198: last_update_login Number := FND_API.G_MISS_NUM,
191: --
192:
193: TYPE line_rec_type IS RECORD
194: ( last_update_date Date := FND_API.G_MISS_DATE,
195: last_updated_by Number := FND_API.G_MISS_NUM,
196: creation_Date Date := FND_API.G_MISS_DATE,
197: created_by Number := FND_API.G_MISS_NUM,
198: last_update_login Number := FND_API.G_MISS_NUM,
199: request_id NUMBER := FND_API.G_MISS_NUM,
192:
193: TYPE line_rec_type IS RECORD
194: ( last_update_date Date := FND_API.G_MISS_DATE,
195: last_updated_by Number := FND_API.G_MISS_NUM,
196: creation_Date Date := FND_API.G_MISS_DATE,
197: created_by Number := FND_API.G_MISS_NUM,
198: last_update_login Number := FND_API.G_MISS_NUM,
199: request_id NUMBER := FND_API.G_MISS_NUM,
200: program_application_id NUMBER := FND_API.G_MISS_NUM,
193: TYPE line_rec_type IS RECORD
194: ( last_update_date Date := FND_API.G_MISS_DATE,
195: last_updated_by Number := FND_API.G_MISS_NUM,
196: creation_Date Date := FND_API.G_MISS_DATE,
197: created_by Number := FND_API.G_MISS_NUM,
198: last_update_login Number := FND_API.G_MISS_NUM,
199: request_id NUMBER := FND_API.G_MISS_NUM,
200: program_application_id NUMBER := FND_API.G_MISS_NUM,
201: program_id NUMBER := FND_API.G_MISS_NUM,
194: ( last_update_date Date := FND_API.G_MISS_DATE,
195: last_updated_by Number := FND_API.G_MISS_NUM,
196: creation_Date Date := FND_API.G_MISS_DATE,
197: created_by Number := FND_API.G_MISS_NUM,
198: last_update_login Number := FND_API.G_MISS_NUM,
199: request_id NUMBER := FND_API.G_MISS_NUM,
200: program_application_id NUMBER := FND_API.G_MISS_NUM,
201: program_id NUMBER := FND_API.G_MISS_NUM,
202: program_update_date DATE := FND_API.G_MISS_DATE,
195: last_updated_by Number := FND_API.G_MISS_NUM,
196: creation_Date Date := FND_API.G_MISS_DATE,
197: created_by Number := FND_API.G_MISS_NUM,
198: last_update_login Number := FND_API.G_MISS_NUM,
199: request_id NUMBER := FND_API.G_MISS_NUM,
200: program_application_id NUMBER := FND_API.G_MISS_NUM,
201: program_id NUMBER := FND_API.G_MISS_NUM,
202: program_update_date DATE := FND_API.G_MISS_DATE,
203: lead_id NUMBER := FND_API.G_MISS_NUM,
196: creation_Date Date := FND_API.G_MISS_DATE,
197: created_by Number := FND_API.G_MISS_NUM,
198: last_update_login Number := FND_API.G_MISS_NUM,
199: request_id NUMBER := FND_API.G_MISS_NUM,
200: program_application_id NUMBER := FND_API.G_MISS_NUM,
201: program_id NUMBER := FND_API.G_MISS_NUM,
202: program_update_date DATE := FND_API.G_MISS_DATE,
203: lead_id NUMBER := FND_API.G_MISS_NUM,
204: lead_line_id NUMBER := FND_API.G_MISS_NUM,
197: created_by Number := FND_API.G_MISS_NUM,
198: last_update_login Number := FND_API.G_MISS_NUM,
199: request_id NUMBER := FND_API.G_MISS_NUM,
200: program_application_id NUMBER := FND_API.G_MISS_NUM,
201: program_id NUMBER := FND_API.G_MISS_NUM,
202: program_update_date DATE := FND_API.G_MISS_DATE,
203: lead_id NUMBER := FND_API.G_MISS_NUM,
204: lead_line_id NUMBER := FND_API.G_MISS_NUM,
205: original_lead_line_id NUMBER := FND_API.G_MISS_NUM,
198: last_update_login Number := FND_API.G_MISS_NUM,
199: request_id NUMBER := FND_API.G_MISS_NUM,
200: program_application_id NUMBER := FND_API.G_MISS_NUM,
201: program_id NUMBER := FND_API.G_MISS_NUM,
202: program_update_date DATE := FND_API.G_MISS_DATE,
203: lead_id NUMBER := FND_API.G_MISS_NUM,
204: lead_line_id NUMBER := FND_API.G_MISS_NUM,
205: original_lead_line_id NUMBER := FND_API.G_MISS_NUM,
206: interest_type_id NUMBER := FND_API.G_MISS_NUM,
199: request_id NUMBER := FND_API.G_MISS_NUM,
200: program_application_id NUMBER := FND_API.G_MISS_NUM,
201: program_id NUMBER := FND_API.G_MISS_NUM,
202: program_update_date DATE := FND_API.G_MISS_DATE,
203: lead_id NUMBER := FND_API.G_MISS_NUM,
204: lead_line_id NUMBER := FND_API.G_MISS_NUM,
205: original_lead_line_id NUMBER := FND_API.G_MISS_NUM,
206: interest_type_id NUMBER := FND_API.G_MISS_NUM,
207: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
200: program_application_id NUMBER := FND_API.G_MISS_NUM,
201: program_id NUMBER := FND_API.G_MISS_NUM,
202: program_update_date DATE := FND_API.G_MISS_DATE,
203: lead_id NUMBER := FND_API.G_MISS_NUM,
204: lead_line_id NUMBER := FND_API.G_MISS_NUM,
205: original_lead_line_id NUMBER := FND_API.G_MISS_NUM,
206: interest_type_id NUMBER := FND_API.G_MISS_NUM,
207: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
208: interest_status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: program_id NUMBER := FND_API.G_MISS_NUM,
202: program_update_date DATE := FND_API.G_MISS_DATE,
203: lead_id NUMBER := FND_API.G_MISS_NUM,
204: lead_line_id NUMBER := FND_API.G_MISS_NUM,
205: original_lead_line_id NUMBER := FND_API.G_MISS_NUM,
206: interest_type_id NUMBER := FND_API.G_MISS_NUM,
207: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
208: interest_status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
202: program_update_date DATE := FND_API.G_MISS_DATE,
203: lead_id NUMBER := FND_API.G_MISS_NUM,
204: lead_line_id NUMBER := FND_API.G_MISS_NUM,
205: original_lead_line_id NUMBER := FND_API.G_MISS_NUM,
206: interest_type_id NUMBER := FND_API.G_MISS_NUM,
207: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
208: interest_status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
210: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
203: lead_id NUMBER := FND_API.G_MISS_NUM,
204: lead_line_id NUMBER := FND_API.G_MISS_NUM,
205: original_lead_line_id NUMBER := FND_API.G_MISS_NUM,
206: interest_type_id NUMBER := FND_API.G_MISS_NUM,
207: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
208: interest_status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
210: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
211: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
204: lead_line_id NUMBER := FND_API.G_MISS_NUM,
205: original_lead_line_id NUMBER := FND_API.G_MISS_NUM,
206: interest_type_id NUMBER := FND_API.G_MISS_NUM,
207: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
208: interest_status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
210: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
211: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
212: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
205: original_lead_line_id NUMBER := FND_API.G_MISS_NUM,
206: interest_type_id NUMBER := FND_API.G_MISS_NUM,
207: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
208: interest_status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
210: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
211: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
212: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
213: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
206: interest_type_id NUMBER := FND_API.G_MISS_NUM,
207: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
208: interest_status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
210: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
211: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
212: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
213: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
214: inventory_item_conc_segs VARCHAR2(2000) := FND_API.G_MISS_CHAR,
207: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
208: interest_status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
210: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
211: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
212: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
213: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
214: inventory_item_conc_segs VARCHAR2(2000) := FND_API.G_MISS_CHAR,
215: organization_id NUMBER := FND_API.G_MISS_NUM,
208: interest_status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
209: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
210: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
211: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
212: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
213: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
214: inventory_item_conc_segs VARCHAR2(2000) := FND_API.G_MISS_CHAR,
215: organization_id NUMBER := FND_API.G_MISS_NUM,
216: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
209: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
210: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
211: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
212: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
213: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
214: inventory_item_conc_segs VARCHAR2(2000) := FND_API.G_MISS_CHAR,
215: organization_id NUMBER := FND_API.G_MISS_NUM,
216: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
217: uom VARCHAR2(25) := FND_API.G_MISS_CHAR,
210: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
211: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
212: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
213: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
214: inventory_item_conc_segs VARCHAR2(2000) := FND_API.G_MISS_CHAR,
215: organization_id NUMBER := FND_API.G_MISS_NUM,
216: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
217: uom VARCHAR2(25) := FND_API.G_MISS_CHAR,
218: quantity NUMBER := FND_API.G_MISS_NUM,
211: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
212: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
213: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
214: inventory_item_conc_segs VARCHAR2(2000) := FND_API.G_MISS_CHAR,
215: organization_id NUMBER := FND_API.G_MISS_NUM,
216: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
217: uom VARCHAR2(25) := FND_API.G_MISS_CHAR,
218: quantity NUMBER := FND_API.G_MISS_NUM,
219: ship_date DATE := FND_API.G_MISS_DATE,
212: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
213: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
214: inventory_item_conc_segs VARCHAR2(2000) := FND_API.G_MISS_CHAR,
215: organization_id NUMBER := FND_API.G_MISS_NUM,
216: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
217: uom VARCHAR2(25) := FND_API.G_MISS_CHAR,
218: quantity NUMBER := FND_API.G_MISS_NUM,
219: ship_date DATE := FND_API.G_MISS_DATE,
220: total_amount NUMBER := FND_API.G_MISS_NUM,
213: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
214: inventory_item_conc_segs VARCHAR2(2000) := FND_API.G_MISS_CHAR,
215: organization_id NUMBER := FND_API.G_MISS_NUM,
216: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
217: uom VARCHAR2(25) := FND_API.G_MISS_CHAR,
218: quantity NUMBER := FND_API.G_MISS_NUM,
219: ship_date DATE := FND_API.G_MISS_DATE,
220: total_amount NUMBER := FND_API.G_MISS_NUM,
221: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
214: inventory_item_conc_segs VARCHAR2(2000) := FND_API.G_MISS_CHAR,
215: organization_id NUMBER := FND_API.G_MISS_NUM,
216: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
217: uom VARCHAR2(25) := FND_API.G_MISS_CHAR,
218: quantity NUMBER := FND_API.G_MISS_NUM,
219: ship_date DATE := FND_API.G_MISS_DATE,
220: total_amount NUMBER := FND_API.G_MISS_NUM,
221: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
222: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
215: organization_id NUMBER := FND_API.G_MISS_NUM,
216: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
217: uom VARCHAR2(25) := FND_API.G_MISS_CHAR,
218: quantity NUMBER := FND_API.G_MISS_NUM,
219: ship_date DATE := FND_API.G_MISS_DATE,
220: total_amount NUMBER := FND_API.G_MISS_NUM,
221: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
222: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
223: win_probability NUMBER := FND_API.G_MISS_NUM,
216: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
217: uom VARCHAR2(25) := FND_API.G_MISS_CHAR,
218: quantity NUMBER := FND_API.G_MISS_NUM,
219: ship_date DATE := FND_API.G_MISS_DATE,
220: total_amount NUMBER := FND_API.G_MISS_NUM,
221: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
222: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
223: win_probability NUMBER := FND_API.G_MISS_NUM,
224: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
217: uom VARCHAR2(25) := FND_API.G_MISS_CHAR,
218: quantity NUMBER := FND_API.G_MISS_NUM,
219: ship_date DATE := FND_API.G_MISS_DATE,
220: total_amount NUMBER := FND_API.G_MISS_NUM,
221: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
222: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
223: win_probability NUMBER := FND_API.G_MISS_NUM,
224: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
218: quantity NUMBER := FND_API.G_MISS_NUM,
219: ship_date DATE := FND_API.G_MISS_DATE,
220: total_amount NUMBER := FND_API.G_MISS_NUM,
221: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
222: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
223: win_probability NUMBER := FND_API.G_MISS_NUM,
224: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
226: decision_date DATE := FND_API.G_MISS_DATE,
219: ship_date DATE := FND_API.G_MISS_DATE,
220: total_amount NUMBER := FND_API.G_MISS_NUM,
221: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
222: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
223: win_probability NUMBER := FND_API.G_MISS_NUM,
224: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
226: decision_date DATE := FND_API.G_MISS_DATE,
227: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: total_amount NUMBER := FND_API.G_MISS_NUM,
221: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
222: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
223: win_probability NUMBER := FND_API.G_MISS_NUM,
224: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
226: decision_date DATE := FND_API.G_MISS_DATE,
227: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
228: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
221: sales_stage_id NUMBER := FND_API.G_MISS_NUM,
222: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
223: win_probability NUMBER := FND_API.G_MISS_NUM,
224: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
226: decision_date DATE := FND_API.G_MISS_DATE,
227: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
228: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
229: unit_price Number := FND_API.G_MISS_NUM,
222: sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
223: win_probability NUMBER := FND_API.G_MISS_NUM,
224: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
226: decision_date DATE := FND_API.G_MISS_DATE,
227: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
228: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
229: unit_price Number := FND_API.G_MISS_NUM,
230: price Number := FND_API.G_MISS_NUM,
223: win_probability NUMBER := FND_API.G_MISS_NUM,
224: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
226: decision_date DATE := FND_API.G_MISS_DATE,
227: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
228: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
229: unit_price Number := FND_API.G_MISS_NUM,
230: price Number := FND_API.G_MISS_NUM,
231: price_volume_margin Number := FND_API.G_MISS_NUM,
224: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
226: decision_date DATE := FND_API.G_MISS_DATE,
227: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
228: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
229: unit_price Number := FND_API.G_MISS_NUM,
230: price Number := FND_API.G_MISS_NUM,
231: price_volume_margin Number := FND_API.G_MISS_NUM,
232: quoted_line_flag Varchar(1) := FND_API.G_MISS_CHAR,
225: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
226: decision_date DATE := FND_API.G_MISS_DATE,
227: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
228: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
229: unit_price Number := FND_API.G_MISS_NUM,
230: price Number := FND_API.G_MISS_NUM,
231: price_volume_margin Number := FND_API.G_MISS_NUM,
232: quoted_line_flag Varchar(1) := FND_API.G_MISS_CHAR,
233: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
226: decision_date DATE := FND_API.G_MISS_DATE,
227: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
228: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
229: unit_price Number := FND_API.G_MISS_NUM,
230: price Number := FND_API.G_MISS_NUM,
231: price_volume_margin Number := FND_API.G_MISS_NUM,
232: quoted_line_flag Varchar(1) := FND_API.G_MISS_CHAR,
233: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
227: channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
228: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
229: unit_price Number := FND_API.G_MISS_NUM,
230: price Number := FND_API.G_MISS_NUM,
231: price_volume_margin Number := FND_API.G_MISS_NUM,
232: quoted_line_flag Varchar(1) := FND_API.G_MISS_CHAR,
233: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
228: channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
229: unit_price Number := FND_API.G_MISS_NUM,
230: price Number := FND_API.G_MISS_NUM,
231: price_volume_margin Number := FND_API.G_MISS_NUM,
232: quoted_line_flag Varchar(1) := FND_API.G_MISS_CHAR,
233: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
236: owner_scredit_percent NUMBER := FND_API.G_MISS_NUM,
229: unit_price Number := FND_API.G_MISS_NUM,
230: price Number := FND_API.G_MISS_NUM,
231: price_volume_margin Number := FND_API.G_MISS_NUM,
232: quoted_line_flag Varchar(1) := FND_API.G_MISS_CHAR,
233: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
236: owner_scredit_percent NUMBER := FND_API.G_MISS_NUM,
237: Source_Promotion_Id NUMBER := FND_API.G_MISS_NUM,
230: price Number := FND_API.G_MISS_NUM,
231: price_volume_margin Number := FND_API.G_MISS_NUM,
232: quoted_line_flag Varchar(1) := FND_API.G_MISS_CHAR,
233: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
236: owner_scredit_percent NUMBER := FND_API.G_MISS_NUM,
237: Source_Promotion_Id NUMBER := FND_API.G_MISS_NUM,
238: forecast_date DATE := FND_API.G_MISS_DATE,
231: price_volume_margin Number := FND_API.G_MISS_NUM,
232: quoted_line_flag Varchar(1) := FND_API.G_MISS_CHAR,
233: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
236: owner_scredit_percent NUMBER := FND_API.G_MISS_NUM,
237: Source_Promotion_Id NUMBER := FND_API.G_MISS_NUM,
238: forecast_date DATE := FND_API.G_MISS_DATE,
239: rolling_forecast_flag Varchar(1) := FND_API.G_MISS_CHAR,
232: quoted_line_flag Varchar(1) := FND_API.G_MISS_CHAR,
233: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
236: owner_scredit_percent NUMBER := FND_API.G_MISS_NUM,
237: Source_Promotion_Id NUMBER := FND_API.G_MISS_NUM,
238: forecast_date DATE := FND_API.G_MISS_DATE,
239: rolling_forecast_flag Varchar(1) := FND_API.G_MISS_CHAR,
240: Offer_Id NUMBER := FND_API.G_MISS_NUM,
233: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
236: owner_scredit_percent NUMBER := FND_API.G_MISS_NUM,
237: Source_Promotion_Id NUMBER := FND_API.G_MISS_NUM,
238: forecast_date DATE := FND_API.G_MISS_DATE,
239: rolling_forecast_flag Varchar(1) := FND_API.G_MISS_CHAR,
240: Offer_Id NUMBER := FND_API.G_MISS_NUM,
241: ORG_ID NUMBER := FND_API.G_MISS_NUM,
234: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
236: owner_scredit_percent NUMBER := FND_API.G_MISS_NUM,
237: Source_Promotion_Id NUMBER := FND_API.G_MISS_NUM,
238: forecast_date DATE := FND_API.G_MISS_DATE,
239: rolling_forecast_flag Varchar(1) := FND_API.G_MISS_CHAR,
240: Offer_Id NUMBER := FND_API.G_MISS_NUM,
241: ORG_ID NUMBER := FND_API.G_MISS_NUM,
242: product_category_id NUMBER := FND_API.G_MISS_NUM,
235: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
236: owner_scredit_percent NUMBER := FND_API.G_MISS_NUM,
237: Source_Promotion_Id NUMBER := FND_API.G_MISS_NUM,
238: forecast_date DATE := FND_API.G_MISS_DATE,
239: rolling_forecast_flag Varchar(1) := FND_API.G_MISS_CHAR,
240: Offer_Id NUMBER := FND_API.G_MISS_NUM,
241: ORG_ID NUMBER := FND_API.G_MISS_NUM,
242: product_category_id NUMBER := FND_API.G_MISS_NUM,
243: product_cat_set_id NUMBER := FND_API.G_MISS_NUM,
236: owner_scredit_percent NUMBER := FND_API.G_MISS_NUM,
237: Source_Promotion_Id NUMBER := FND_API.G_MISS_NUM,
238: forecast_date DATE := FND_API.G_MISS_DATE,
239: rolling_forecast_flag Varchar(1) := FND_API.G_MISS_CHAR,
240: Offer_Id NUMBER := FND_API.G_MISS_NUM,
241: ORG_ID NUMBER := FND_API.G_MISS_NUM,
242: product_category_id NUMBER := FND_API.G_MISS_NUM,
243: product_cat_set_id NUMBER := FND_API.G_MISS_NUM,
244: attribute_category VARCHAR2(30),
237: Source_Promotion_Id NUMBER := FND_API.G_MISS_NUM,
238: forecast_date DATE := FND_API.G_MISS_DATE,
239: rolling_forecast_flag Varchar(1) := FND_API.G_MISS_CHAR,
240: Offer_Id NUMBER := FND_API.G_MISS_NUM,
241: ORG_ID NUMBER := FND_API.G_MISS_NUM,
242: product_category_id NUMBER := FND_API.G_MISS_NUM,
243: product_cat_set_id NUMBER := FND_API.G_MISS_NUM,
244: attribute_category VARCHAR2(30),
245: attribute1 VARCHAR2(150),
238: forecast_date DATE := FND_API.G_MISS_DATE,
239: rolling_forecast_flag Varchar(1) := FND_API.G_MISS_CHAR,
240: Offer_Id NUMBER := FND_API.G_MISS_NUM,
241: ORG_ID NUMBER := FND_API.G_MISS_NUM,
242: product_category_id NUMBER := FND_API.G_MISS_NUM,
243: product_cat_set_id NUMBER := FND_API.G_MISS_NUM,
244: attribute_category VARCHAR2(30),
245: attribute1 VARCHAR2(150),
246: attribute2 VARCHAR2(150),
239: rolling_forecast_flag Varchar(1) := FND_API.G_MISS_CHAR,
240: Offer_Id NUMBER := FND_API.G_MISS_NUM,
241: ORG_ID NUMBER := FND_API.G_MISS_NUM,
242: product_category_id NUMBER := FND_API.G_MISS_NUM,
243: product_cat_set_id NUMBER := FND_API.G_MISS_NUM,
244: attribute_category VARCHAR2(30),
245: attribute1 VARCHAR2(150),
246: attribute2 VARCHAR2(150),
247: attribute3 VARCHAR2(150),
256: attribute12 VARCHAR2(150),
257: attribute13 VARCHAR2(150),
258: attribute14 VARCHAR2(150),
259: attribute15 VARCHAR2(150),
260: opp_worst_forecast_amount NUMBER := FND_API.G_MISS_NUM,
261: opp_forecast_amount NUMBER := FND_API.G_MISS_NUM,
262: opp_best_forecast_amount NUMBER := FND_API.G_MISS_NUM
263: );
264:
257: attribute13 VARCHAR2(150),
258: attribute14 VARCHAR2(150),
259: attribute15 VARCHAR2(150),
260: opp_worst_forecast_amount NUMBER := FND_API.G_MISS_NUM,
261: opp_forecast_amount NUMBER := FND_API.G_MISS_NUM,
262: opp_best_forecast_amount NUMBER := FND_API.G_MISS_NUM
263: );
264:
265: G_MISS_LINE_REC line_rec_type;
258: attribute14 VARCHAR2(150),
259: attribute15 VARCHAR2(150),
260: opp_worst_forecast_amount NUMBER := FND_API.G_MISS_NUM,
261: opp_forecast_amount NUMBER := FND_API.G_MISS_NUM,
262: opp_best_forecast_amount NUMBER := FND_API.G_MISS_NUM
263: );
264:
265: G_MISS_LINE_REC line_rec_type;
266: TYPE line_tbl_type IS TABLE OF line_rec_type
280: -- Sales Credit Record Type
281: --
282:
283: TYPE sales_credit_rec_type IS RECORD
284: ( last_update_date Date := FND_API.G_MISS_DATE,
285: last_updated_by Number := FND_API.G_MISS_NUM,
286: creation_Date Date := FND_API.G_MISS_DATE,
287: created_by Number := FND_API.G_MISS_NUM,
288: last_update_login Number := FND_API.G_MISS_NUM,
281: --
282:
283: TYPE sales_credit_rec_type IS RECORD
284: ( last_update_date Date := FND_API.G_MISS_DATE,
285: last_updated_by Number := FND_API.G_MISS_NUM,
286: creation_Date Date := FND_API.G_MISS_DATE,
287: created_by Number := FND_API.G_MISS_NUM,
288: last_update_login Number := FND_API.G_MISS_NUM,
289: request_id NUMBER := FND_API.G_MISS_NUM,
282:
283: TYPE sales_credit_rec_type IS RECORD
284: ( last_update_date Date := FND_API.G_MISS_DATE,
285: last_updated_by Number := FND_API.G_MISS_NUM,
286: creation_Date Date := FND_API.G_MISS_DATE,
287: created_by Number := FND_API.G_MISS_NUM,
288: last_update_login Number := FND_API.G_MISS_NUM,
289: request_id NUMBER := FND_API.G_MISS_NUM,
290: program_application_id NUMBER := FND_API.G_MISS_NUM,
283: TYPE sales_credit_rec_type IS RECORD
284: ( last_update_date Date := FND_API.G_MISS_DATE,
285: last_updated_by Number := FND_API.G_MISS_NUM,
286: creation_Date Date := FND_API.G_MISS_DATE,
287: created_by Number := FND_API.G_MISS_NUM,
288: last_update_login Number := FND_API.G_MISS_NUM,
289: request_id NUMBER := FND_API.G_MISS_NUM,
290: program_application_id NUMBER := FND_API.G_MISS_NUM,
291: program_id NUMBER := FND_API.G_MISS_NUM,
284: ( last_update_date Date := FND_API.G_MISS_DATE,
285: last_updated_by Number := FND_API.G_MISS_NUM,
286: creation_Date Date := FND_API.G_MISS_DATE,
287: created_by Number := FND_API.G_MISS_NUM,
288: last_update_login Number := FND_API.G_MISS_NUM,
289: request_id NUMBER := FND_API.G_MISS_NUM,
290: program_application_id NUMBER := FND_API.G_MISS_NUM,
291: program_id NUMBER := FND_API.G_MISS_NUM,
292: program_update_date DATE := FND_API.G_MISS_DATE,
285: last_updated_by Number := FND_API.G_MISS_NUM,
286: creation_Date Date := FND_API.G_MISS_DATE,
287: created_by Number := FND_API.G_MISS_NUM,
288: last_update_login Number := FND_API.G_MISS_NUM,
289: request_id NUMBER := FND_API.G_MISS_NUM,
290: program_application_id NUMBER := FND_API.G_MISS_NUM,
291: program_id NUMBER := FND_API.G_MISS_NUM,
292: program_update_date DATE := FND_API.G_MISS_DATE,
293: sales_credit_id NUMBER := FND_API.G_MISS_NUM,
286: creation_Date Date := FND_API.G_MISS_DATE,
287: created_by Number := FND_API.G_MISS_NUM,
288: last_update_login Number := FND_API.G_MISS_NUM,
289: request_id NUMBER := FND_API.G_MISS_NUM,
290: program_application_id NUMBER := FND_API.G_MISS_NUM,
291: program_id NUMBER := FND_API.G_MISS_NUM,
292: program_update_date DATE := FND_API.G_MISS_DATE,
293: sales_credit_id NUMBER := FND_API.G_MISS_NUM,
294: original_sales_credit_id NUMBER := FND_API.G_MISS_NUM,
287: created_by Number := FND_API.G_MISS_NUM,
288: last_update_login Number := FND_API.G_MISS_NUM,
289: request_id NUMBER := FND_API.G_MISS_NUM,
290: program_application_id NUMBER := FND_API.G_MISS_NUM,
291: program_id NUMBER := FND_API.G_MISS_NUM,
292: program_update_date DATE := FND_API.G_MISS_DATE,
293: sales_credit_id NUMBER := FND_API.G_MISS_NUM,
294: original_sales_credit_id NUMBER := FND_API.G_MISS_NUM,
295: lead_id NUMBER := FND_API.G_MISS_NUM,
288: last_update_login Number := FND_API.G_MISS_NUM,
289: request_id NUMBER := FND_API.G_MISS_NUM,
290: program_application_id NUMBER := FND_API.G_MISS_NUM,
291: program_id NUMBER := FND_API.G_MISS_NUM,
292: program_update_date DATE := FND_API.G_MISS_DATE,
293: sales_credit_id NUMBER := FND_API.G_MISS_NUM,
294: original_sales_credit_id NUMBER := FND_API.G_MISS_NUM,
295: lead_id NUMBER := FND_API.G_MISS_NUM,
296: lead_line_id NUMBER := FND_API.G_MISS_NUM,
289: request_id NUMBER := FND_API.G_MISS_NUM,
290: program_application_id NUMBER := FND_API.G_MISS_NUM,
291: program_id NUMBER := FND_API.G_MISS_NUM,
292: program_update_date DATE := FND_API.G_MISS_DATE,
293: sales_credit_id NUMBER := FND_API.G_MISS_NUM,
294: original_sales_credit_id NUMBER := FND_API.G_MISS_NUM,
295: lead_id NUMBER := FND_API.G_MISS_NUM,
296: lead_line_id NUMBER := FND_API.G_MISS_NUM,
297: salesforce_id NUMBER := FND_API.G_MISS_NUM,
290: program_application_id NUMBER := FND_API.G_MISS_NUM,
291: program_id NUMBER := FND_API.G_MISS_NUM,
292: program_update_date DATE := FND_API.G_MISS_DATE,
293: sales_credit_id NUMBER := FND_API.G_MISS_NUM,
294: original_sales_credit_id NUMBER := FND_API.G_MISS_NUM,
295: lead_id NUMBER := FND_API.G_MISS_NUM,
296: lead_line_id NUMBER := FND_API.G_MISS_NUM,
297: salesforce_id NUMBER := FND_API.G_MISS_NUM,
298: person_id NUMBER := FND_API.G_MISS_NUM,
291: program_id NUMBER := FND_API.G_MISS_NUM,
292: program_update_date DATE := FND_API.G_MISS_DATE,
293: sales_credit_id NUMBER := FND_API.G_MISS_NUM,
294: original_sales_credit_id NUMBER := FND_API.G_MISS_NUM,
295: lead_id NUMBER := FND_API.G_MISS_NUM,
296: lead_line_id NUMBER := FND_API.G_MISS_NUM,
297: salesforce_id NUMBER := FND_API.G_MISS_NUM,
298: person_id NUMBER := FND_API.G_MISS_NUM,
299: employee_last_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
292: program_update_date DATE := FND_API.G_MISS_DATE,
293: sales_credit_id NUMBER := FND_API.G_MISS_NUM,
294: original_sales_credit_id NUMBER := FND_API.G_MISS_NUM,
295: lead_id NUMBER := FND_API.G_MISS_NUM,
296: lead_line_id NUMBER := FND_API.G_MISS_NUM,
297: salesforce_id NUMBER := FND_API.G_MISS_NUM,
298: person_id NUMBER := FND_API.G_MISS_NUM,
299: employee_last_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
300: employee_first_name VARCHAR2(20) := FND_API.G_MISS_CHAR,
293: sales_credit_id NUMBER := FND_API.G_MISS_NUM,
294: original_sales_credit_id NUMBER := FND_API.G_MISS_NUM,
295: lead_id NUMBER := FND_API.G_MISS_NUM,
296: lead_line_id NUMBER := FND_API.G_MISS_NUM,
297: salesforce_id NUMBER := FND_API.G_MISS_NUM,
298: person_id NUMBER := FND_API.G_MISS_NUM,
299: employee_last_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
300: employee_first_name VARCHAR2(20) := FND_API.G_MISS_CHAR,
301: salesgroup_id NUMBER := FND_API.G_MISS_NUM,
294: original_sales_credit_id NUMBER := FND_API.G_MISS_NUM,
295: lead_id NUMBER := FND_API.G_MISS_NUM,
296: lead_line_id NUMBER := FND_API.G_MISS_NUM,
297: salesforce_id NUMBER := FND_API.G_MISS_NUM,
298: person_id NUMBER := FND_API.G_MISS_NUM,
299: employee_last_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
300: employee_first_name VARCHAR2(20) := FND_API.G_MISS_CHAR,
301: salesgroup_id NUMBER := FND_API.G_MISS_NUM,
302: salesgroup_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
295: lead_id NUMBER := FND_API.G_MISS_NUM,
296: lead_line_id NUMBER := FND_API.G_MISS_NUM,
297: salesforce_id NUMBER := FND_API.G_MISS_NUM,
298: person_id NUMBER := FND_API.G_MISS_NUM,
299: employee_last_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
300: employee_first_name VARCHAR2(20) := FND_API.G_MISS_CHAR,
301: salesgroup_id NUMBER := FND_API.G_MISS_NUM,
302: salesgroup_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
303: partner_customer_id NUMBER := FND_API.G_MISS_NUM,
296: lead_line_id NUMBER := FND_API.G_MISS_NUM,
297: salesforce_id NUMBER := FND_API.G_MISS_NUM,
298: person_id NUMBER := FND_API.G_MISS_NUM,
299: employee_last_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
300: employee_first_name VARCHAR2(20) := FND_API.G_MISS_CHAR,
301: salesgroup_id NUMBER := FND_API.G_MISS_NUM,
302: salesgroup_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
303: partner_customer_id NUMBER := FND_API.G_MISS_NUM,
304: partner_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
297: salesforce_id NUMBER := FND_API.G_MISS_NUM,
298: person_id NUMBER := FND_API.G_MISS_NUM,
299: employee_last_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
300: employee_first_name VARCHAR2(20) := FND_API.G_MISS_CHAR,
301: salesgroup_id NUMBER := FND_API.G_MISS_NUM,
302: salesgroup_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
303: partner_customer_id NUMBER := FND_API.G_MISS_NUM,
304: partner_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
305: partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
298: person_id NUMBER := FND_API.G_MISS_NUM,
299: employee_last_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
300: employee_first_name VARCHAR2(20) := FND_API.G_MISS_CHAR,
301: salesgroup_id NUMBER := FND_API.G_MISS_NUM,
302: salesgroup_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
303: partner_customer_id NUMBER := FND_API.G_MISS_NUM,
304: partner_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
305: partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
306: partner_address_id NUMBER := FND_API.G_MISS_NUM,
299: employee_last_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
300: employee_first_name VARCHAR2(20) := FND_API.G_MISS_CHAR,
301: salesgroup_id NUMBER := FND_API.G_MISS_NUM,
302: salesgroup_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
303: partner_customer_id NUMBER := FND_API.G_MISS_NUM,
304: partner_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
305: partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
306: partner_address_id NUMBER := FND_API.G_MISS_NUM,
307: revenue_amount NUMBER := FND_API.G_MISS_NUM,
300: employee_first_name VARCHAR2(20) := FND_API.G_MISS_CHAR,
301: salesgroup_id NUMBER := FND_API.G_MISS_NUM,
302: salesgroup_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
303: partner_customer_id NUMBER := FND_API.G_MISS_NUM,
304: partner_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
305: partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
306: partner_address_id NUMBER := FND_API.G_MISS_NUM,
307: revenue_amount NUMBER := FND_API.G_MISS_NUM,
308: revenue_percent NUMBER := FND_API.G_MISS_NUM,
301: salesgroup_id NUMBER := FND_API.G_MISS_NUM,
302: salesgroup_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
303: partner_customer_id NUMBER := FND_API.G_MISS_NUM,
304: partner_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
305: partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
306: partner_address_id NUMBER := FND_API.G_MISS_NUM,
307: revenue_amount NUMBER := FND_API.G_MISS_NUM,
308: revenue_percent NUMBER := FND_API.G_MISS_NUM,
309: quota_credit_amount NUMBER := FND_API.G_MISS_NUM,
302: salesgroup_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
303: partner_customer_id NUMBER := FND_API.G_MISS_NUM,
304: partner_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
305: partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
306: partner_address_id NUMBER := FND_API.G_MISS_NUM,
307: revenue_amount NUMBER := FND_API.G_MISS_NUM,
308: revenue_percent NUMBER := FND_API.G_MISS_NUM,
309: quota_credit_amount NUMBER := FND_API.G_MISS_NUM,
310: quota_credit_percent NUMBER := FND_API.G_MISS_NUM,
303: partner_customer_id NUMBER := FND_API.G_MISS_NUM,
304: partner_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
305: partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
306: partner_address_id NUMBER := FND_API.G_MISS_NUM,
307: revenue_amount NUMBER := FND_API.G_MISS_NUM,
308: revenue_percent NUMBER := FND_API.G_MISS_NUM,
309: quota_credit_amount NUMBER := FND_API.G_MISS_NUM,
310: quota_credit_percent NUMBER := FND_API.G_MISS_NUM,
311: revenue_derived_col NUMBER := FND_API.G_MISS_NUM,
304: partner_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
305: partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
306: partner_address_id NUMBER := FND_API.G_MISS_NUM,
307: revenue_amount NUMBER := FND_API.G_MISS_NUM,
308: revenue_percent NUMBER := FND_API.G_MISS_NUM,
309: quota_credit_amount NUMBER := FND_API.G_MISS_NUM,
310: quota_credit_percent NUMBER := FND_API.G_MISS_NUM,
311: revenue_derived_col NUMBER := FND_API.G_MISS_NUM,
312: quota_derived_col NUMBER := FND_API.G_MISS_NUM,
305: partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
306: partner_address_id NUMBER := FND_API.G_MISS_NUM,
307: revenue_amount NUMBER := FND_API.G_MISS_NUM,
308: revenue_percent NUMBER := FND_API.G_MISS_NUM,
309: quota_credit_amount NUMBER := FND_API.G_MISS_NUM,
310: quota_credit_percent NUMBER := FND_API.G_MISS_NUM,
311: revenue_derived_col NUMBER := FND_API.G_MISS_NUM,
312: quota_derived_col NUMBER := FND_API.G_MISS_NUM,
313: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
306: partner_address_id NUMBER := FND_API.G_MISS_NUM,
307: revenue_amount NUMBER := FND_API.G_MISS_NUM,
308: revenue_percent NUMBER := FND_API.G_MISS_NUM,
309: quota_credit_amount NUMBER := FND_API.G_MISS_NUM,
310: quota_credit_percent NUMBER := FND_API.G_MISS_NUM,
311: revenue_derived_col NUMBER := FND_API.G_MISS_NUM,
312: quota_derived_col NUMBER := FND_API.G_MISS_NUM,
313: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
307: revenue_amount NUMBER := FND_API.G_MISS_NUM,
308: revenue_percent NUMBER := FND_API.G_MISS_NUM,
309: quota_credit_amount NUMBER := FND_API.G_MISS_NUM,
310: quota_credit_percent NUMBER := FND_API.G_MISS_NUM,
311: revenue_derived_col NUMBER := FND_API.G_MISS_NUM,
312: quota_derived_col NUMBER := FND_API.G_MISS_NUM,
313: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
315: MANAGER_REVIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
308: revenue_percent NUMBER := FND_API.G_MISS_NUM,
309: quota_credit_amount NUMBER := FND_API.G_MISS_NUM,
310: quota_credit_percent NUMBER := FND_API.G_MISS_NUM,
311: revenue_derived_col NUMBER := FND_API.G_MISS_NUM,
312: quota_derived_col NUMBER := FND_API.G_MISS_NUM,
313: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
315: MANAGER_REVIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
316: MANAGER_REVIEW_DATE DATE := FND_API.G_MISS_DATE,
309: quota_credit_amount NUMBER := FND_API.G_MISS_NUM,
310: quota_credit_percent NUMBER := FND_API.G_MISS_NUM,
311: revenue_derived_col NUMBER := FND_API.G_MISS_NUM,
312: quota_derived_col NUMBER := FND_API.G_MISS_NUM,
313: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
315: MANAGER_REVIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
316: MANAGER_REVIEW_DATE DATE := FND_API.G_MISS_DATE,
317: line_tbl_index NUMBER := NULL,
310: quota_credit_percent NUMBER := FND_API.G_MISS_NUM,
311: revenue_derived_col NUMBER := FND_API.G_MISS_NUM,
312: quota_derived_col NUMBER := FND_API.G_MISS_NUM,
313: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
315: MANAGER_REVIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
316: MANAGER_REVIEW_DATE DATE := FND_API.G_MISS_DATE,
317: line_tbl_index NUMBER := NULL,
318: delete_flag VARCHAR2(10) := FND_API.G_FALSE,
311: revenue_derived_col NUMBER := FND_API.G_MISS_NUM,
312: quota_derived_col NUMBER := FND_API.G_MISS_NUM,
313: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
315: MANAGER_REVIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
316: MANAGER_REVIEW_DATE DATE := FND_API.G_MISS_DATE,
317: line_tbl_index NUMBER := NULL,
318: delete_flag VARCHAR2(10) := FND_API.G_FALSE,
319: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
312: quota_derived_col NUMBER := FND_API.G_MISS_NUM,
313: member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
315: MANAGER_REVIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
316: MANAGER_REVIEW_DATE DATE := FND_API.G_MISS_DATE,
317: line_tbl_index NUMBER := NULL,
318: delete_flag VARCHAR2(10) := FND_API.G_FALSE,
319: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
320: credit_type_id NUMBER := FND_API.G_MISS_NUM,
314: member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
315: MANAGER_REVIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
316: MANAGER_REVIEW_DATE DATE := FND_API.G_MISS_DATE,
317: line_tbl_index NUMBER := NULL,
318: delete_flag VARCHAR2(10) := FND_API.G_FALSE,
319: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
320: credit_type_id NUMBER := FND_API.G_MISS_NUM,
321: credit_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
322: credit_amount NUMBER := FND_API.G_MISS_NUM,
315: MANAGER_REVIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
316: MANAGER_REVIEW_DATE DATE := FND_API.G_MISS_DATE,
317: line_tbl_index NUMBER := NULL,
318: delete_flag VARCHAR2(10) := FND_API.G_FALSE,
319: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
320: credit_type_id NUMBER := FND_API.G_MISS_NUM,
321: credit_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
322: credit_amount NUMBER := FND_API.G_MISS_NUM,
323: credit_percent NUMBER := FND_API.G_MISS_NUM,
316: MANAGER_REVIEW_DATE DATE := FND_API.G_MISS_DATE,
317: line_tbl_index NUMBER := NULL,
318: delete_flag VARCHAR2(10) := FND_API.G_FALSE,
319: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
320: credit_type_id NUMBER := FND_API.G_MISS_NUM,
321: credit_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
322: credit_amount NUMBER := FND_API.G_MISS_NUM,
323: credit_percent NUMBER := FND_API.G_MISS_NUM,
324: ORG_ID NUMBER := FND_API.G_MISS_NUM,
317: line_tbl_index NUMBER := NULL,
318: delete_flag VARCHAR2(10) := FND_API.G_FALSE,
319: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
320: credit_type_id NUMBER := FND_API.G_MISS_NUM,
321: credit_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
322: credit_amount NUMBER := FND_API.G_MISS_NUM,
323: credit_percent NUMBER := FND_API.G_MISS_NUM,
324: ORG_ID NUMBER := FND_API.G_MISS_NUM,
325: attribute_category VARCHAR2(30),
318: delete_flag VARCHAR2(10) := FND_API.G_FALSE,
319: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
320: credit_type_id NUMBER := FND_API.G_MISS_NUM,
321: credit_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
322: credit_amount NUMBER := FND_API.G_MISS_NUM,
323: credit_percent NUMBER := FND_API.G_MISS_NUM,
324: ORG_ID NUMBER := FND_API.G_MISS_NUM,
325: attribute_category VARCHAR2(30),
326: attribute1 VARCHAR2(150),
319: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
320: credit_type_id NUMBER := FND_API.G_MISS_NUM,
321: credit_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
322: credit_amount NUMBER := FND_API.G_MISS_NUM,
323: credit_percent NUMBER := FND_API.G_MISS_NUM,
324: ORG_ID NUMBER := FND_API.G_MISS_NUM,
325: attribute_category VARCHAR2(30),
326: attribute1 VARCHAR2(150),
327: attribute2 VARCHAR2(150),
320: credit_type_id NUMBER := FND_API.G_MISS_NUM,
321: credit_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
322: credit_amount NUMBER := FND_API.G_MISS_NUM,
323: credit_percent NUMBER := FND_API.G_MISS_NUM,
324: ORG_ID NUMBER := FND_API.G_MISS_NUM,
325: attribute_category VARCHAR2(30),
326: attribute1 VARCHAR2(150),
327: attribute2 VARCHAR2(150),
328: attribute3 VARCHAR2(150),
337: attribute12 VARCHAR2(150),
338: attribute13 VARCHAR2(150),
339: attribute14 VARCHAR2(150),
340: attribute15 VARCHAR2(150),
341: opp_worst_forecast_amount NUMBER := FND_API.G_MISS_NUM,
342: opp_forecast_amount NUMBER := FND_API.G_MISS_NUM,
343: opp_best_forecast_amount NUMBER := FND_API.G_MISS_NUM,
344: defaulted_from_owner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
345: );
338: attribute13 VARCHAR2(150),
339: attribute14 VARCHAR2(150),
340: attribute15 VARCHAR2(150),
341: opp_worst_forecast_amount NUMBER := FND_API.G_MISS_NUM,
342: opp_forecast_amount NUMBER := FND_API.G_MISS_NUM,
343: opp_best_forecast_amount NUMBER := FND_API.G_MISS_NUM,
344: defaulted_from_owner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
345: );
346:
339: attribute14 VARCHAR2(150),
340: attribute15 VARCHAR2(150),
341: opp_worst_forecast_amount NUMBER := FND_API.G_MISS_NUM,
342: opp_forecast_amount NUMBER := FND_API.G_MISS_NUM,
343: opp_best_forecast_amount NUMBER := FND_API.G_MISS_NUM,
344: defaulted_from_owner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
345: );
346:
347: G_MISS_SALES_CREDIT_REC sales_credit_rec_type;
340: attribute15 VARCHAR2(150),
341: opp_worst_forecast_amount NUMBER := FND_API.G_MISS_NUM,
342: opp_forecast_amount NUMBER := FND_API.G_MISS_NUM,
343: opp_best_forecast_amount NUMBER := FND_API.G_MISS_NUM,
344: defaulted_from_owner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
345: );
346:
347: G_MISS_SALES_CREDIT_REC sales_credit_rec_type;
348: TYPE sales_credit_tbl_type IS TABLE OF sales_credit_rec_type
365: -- Obstacle Record Type
366: --
367:
368: TYPE obstacle_rec_type IS RECORD
369: ( last_update_date Date := FND_API.G_MISS_DATE,
370: last_updated_by Number := FND_API.G_MISS_NUM,
371: creation_Date Date := FND_API.G_MISS_DATE,
372: created_by Number := FND_API.G_MISS_NUM,
373: last_update_login Number := FND_API.G_MISS_NUM,
366: --
367:
368: TYPE obstacle_rec_type IS RECORD
369: ( last_update_date Date := FND_API.G_MISS_DATE,
370: last_updated_by Number := FND_API.G_MISS_NUM,
371: creation_Date Date := FND_API.G_MISS_DATE,
372: created_by Number := FND_API.G_MISS_NUM,
373: last_update_login Number := FND_API.G_MISS_NUM,
374: request_id NUMBER := FND_API.G_MISS_NUM,
367:
368: TYPE obstacle_rec_type IS RECORD
369: ( last_update_date Date := FND_API.G_MISS_DATE,
370: last_updated_by Number := FND_API.G_MISS_NUM,
371: creation_Date Date := FND_API.G_MISS_DATE,
372: created_by Number := FND_API.G_MISS_NUM,
373: last_update_login Number := FND_API.G_MISS_NUM,
374: request_id NUMBER := FND_API.G_MISS_NUM,
375: program_application_id NUMBER := FND_API.G_MISS_NUM,
368: TYPE obstacle_rec_type IS RECORD
369: ( last_update_date Date := FND_API.G_MISS_DATE,
370: last_updated_by Number := FND_API.G_MISS_NUM,
371: creation_Date Date := FND_API.G_MISS_DATE,
372: created_by Number := FND_API.G_MISS_NUM,
373: last_update_login Number := FND_API.G_MISS_NUM,
374: request_id NUMBER := FND_API.G_MISS_NUM,
375: program_application_id NUMBER := FND_API.G_MISS_NUM,
376: program_id NUMBER := FND_API.G_MISS_NUM,
369: ( last_update_date Date := FND_API.G_MISS_DATE,
370: last_updated_by Number := FND_API.G_MISS_NUM,
371: creation_Date Date := FND_API.G_MISS_DATE,
372: created_by Number := FND_API.G_MISS_NUM,
373: last_update_login Number := FND_API.G_MISS_NUM,
374: request_id NUMBER := FND_API.G_MISS_NUM,
375: program_application_id NUMBER := FND_API.G_MISS_NUM,
376: program_id NUMBER := FND_API.G_MISS_NUM,
377: program_update_date DATE := FND_API.G_MISS_DATE,
370: last_updated_by Number := FND_API.G_MISS_NUM,
371: creation_Date Date := FND_API.G_MISS_DATE,
372: created_by Number := FND_API.G_MISS_NUM,
373: last_update_login Number := FND_API.G_MISS_NUM,
374: request_id NUMBER := FND_API.G_MISS_NUM,
375: program_application_id NUMBER := FND_API.G_MISS_NUM,
376: program_id NUMBER := FND_API.G_MISS_NUM,
377: program_update_date DATE := FND_API.G_MISS_DATE,
378: lead_obstacle_id NUMBER := FND_API.G_MISS_NUM,
371: creation_Date Date := FND_API.G_MISS_DATE,
372: created_by Number := FND_API.G_MISS_NUM,
373: last_update_login Number := FND_API.G_MISS_NUM,
374: request_id NUMBER := FND_API.G_MISS_NUM,
375: program_application_id NUMBER := FND_API.G_MISS_NUM,
376: program_id NUMBER := FND_API.G_MISS_NUM,
377: program_update_date DATE := FND_API.G_MISS_DATE,
378: lead_obstacle_id NUMBER := FND_API.G_MISS_NUM,
379: lead_id NUMBER := FND_API.G_MISS_NUM,
372: created_by Number := FND_API.G_MISS_NUM,
373: last_update_login Number := FND_API.G_MISS_NUM,
374: request_id NUMBER := FND_API.G_MISS_NUM,
375: program_application_id NUMBER := FND_API.G_MISS_NUM,
376: program_id NUMBER := FND_API.G_MISS_NUM,
377: program_update_date DATE := FND_API.G_MISS_DATE,
378: lead_obstacle_id NUMBER := FND_API.G_MISS_NUM,
379: lead_id NUMBER := FND_API.G_MISS_NUM,
380: obstacle_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
373: last_update_login Number := FND_API.G_MISS_NUM,
374: request_id NUMBER := FND_API.G_MISS_NUM,
375: program_application_id NUMBER := FND_API.G_MISS_NUM,
376: program_id NUMBER := FND_API.G_MISS_NUM,
377: program_update_date DATE := FND_API.G_MISS_DATE,
378: lead_obstacle_id NUMBER := FND_API.G_MISS_NUM,
379: lead_id NUMBER := FND_API.G_MISS_NUM,
380: obstacle_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
381: obstacle VARCHAR2(80) := FND_API.G_MISS_CHAR,
374: request_id NUMBER := FND_API.G_MISS_NUM,
375: program_application_id NUMBER := FND_API.G_MISS_NUM,
376: program_id NUMBER := FND_API.G_MISS_NUM,
377: program_update_date DATE := FND_API.G_MISS_DATE,
378: lead_obstacle_id NUMBER := FND_API.G_MISS_NUM,
379: lead_id NUMBER := FND_API.G_MISS_NUM,
380: obstacle_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
381: obstacle VARCHAR2(80) := FND_API.G_MISS_CHAR,
382: obstacle_status VARCHAR2(80) := FND_API.G_MISS_CHAR,
375: program_application_id NUMBER := FND_API.G_MISS_NUM,
376: program_id NUMBER := FND_API.G_MISS_NUM,
377: program_update_date DATE := FND_API.G_MISS_DATE,
378: lead_obstacle_id NUMBER := FND_API.G_MISS_NUM,
379: lead_id NUMBER := FND_API.G_MISS_NUM,
380: obstacle_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
381: obstacle VARCHAR2(80) := FND_API.G_MISS_CHAR,
382: obstacle_status VARCHAR2(80) := FND_API.G_MISS_CHAR,
383: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
376: program_id NUMBER := FND_API.G_MISS_NUM,
377: program_update_date DATE := FND_API.G_MISS_DATE,
378: lead_obstacle_id NUMBER := FND_API.G_MISS_NUM,
379: lead_id NUMBER := FND_API.G_MISS_NUM,
380: obstacle_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
381: obstacle VARCHAR2(80) := FND_API.G_MISS_CHAR,
382: obstacle_status VARCHAR2(80) := FND_API.G_MISS_CHAR,
383: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
377: program_update_date DATE := FND_API.G_MISS_DATE,
378: lead_obstacle_id NUMBER := FND_API.G_MISS_NUM,
379: lead_id NUMBER := FND_API.G_MISS_NUM,
380: obstacle_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
381: obstacle VARCHAR2(80) := FND_API.G_MISS_CHAR,
382: obstacle_status VARCHAR2(80) := FND_API.G_MISS_CHAR,
383: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
385: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
378: lead_obstacle_id NUMBER := FND_API.G_MISS_NUM,
379: lead_id NUMBER := FND_API.G_MISS_NUM,
380: obstacle_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
381: obstacle VARCHAR2(80) := FND_API.G_MISS_CHAR,
382: obstacle_status VARCHAR2(80) := FND_API.G_MISS_CHAR,
383: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
385: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
386: ORG_ID NUMBER := FND_API.G_MISS_NUM,
379: lead_id NUMBER := FND_API.G_MISS_NUM,
380: obstacle_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
381: obstacle VARCHAR2(80) := FND_API.G_MISS_CHAR,
382: obstacle_status VARCHAR2(80) := FND_API.G_MISS_CHAR,
383: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
385: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
386: ORG_ID NUMBER := FND_API.G_MISS_NUM,
387: attribute_category VARCHAR2(30),
380: obstacle_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
381: obstacle VARCHAR2(80) := FND_API.G_MISS_CHAR,
382: obstacle_status VARCHAR2(80) := FND_API.G_MISS_CHAR,
383: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
385: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
386: ORG_ID NUMBER := FND_API.G_MISS_NUM,
387: attribute_category VARCHAR2(30),
388: attribute1 VARCHAR2(150),
381: obstacle VARCHAR2(80) := FND_API.G_MISS_CHAR,
382: obstacle_status VARCHAR2(80) := FND_API.G_MISS_CHAR,
383: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
385: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
386: ORG_ID NUMBER := FND_API.G_MISS_NUM,
387: attribute_category VARCHAR2(30),
388: attribute1 VARCHAR2(150),
389: attribute2 VARCHAR2(150),
382: obstacle_status VARCHAR2(80) := FND_API.G_MISS_CHAR,
383: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
385: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
386: ORG_ID NUMBER := FND_API.G_MISS_NUM,
387: attribute_category VARCHAR2(30),
388: attribute1 VARCHAR2(150),
389: attribute2 VARCHAR2(150),
390: attribute3 VARCHAR2(150),
419: -- Competitor Record Type
420: --
421:
422: TYPE competitor_rec_type IS RECORD
423: ( last_update_date Date := FND_API.G_MISS_DATE,
424: last_updated_by Number := FND_API.G_MISS_NUM,
425: creation_Date Date := FND_API.G_MISS_DATE,
426: created_by Number := FND_API.G_MISS_NUM,
427: last_update_login Number := FND_API.G_MISS_NUM,
420: --
421:
422: TYPE competitor_rec_type IS RECORD
423: ( last_update_date Date := FND_API.G_MISS_DATE,
424: last_updated_by Number := FND_API.G_MISS_NUM,
425: creation_Date Date := FND_API.G_MISS_DATE,
426: created_by Number := FND_API.G_MISS_NUM,
427: last_update_login Number := FND_API.G_MISS_NUM,
428: request_id NUMBER := FND_API.G_MISS_NUM,
421:
422: TYPE competitor_rec_type IS RECORD
423: ( last_update_date Date := FND_API.G_MISS_DATE,
424: last_updated_by Number := FND_API.G_MISS_NUM,
425: creation_Date Date := FND_API.G_MISS_DATE,
426: created_by Number := FND_API.G_MISS_NUM,
427: last_update_login Number := FND_API.G_MISS_NUM,
428: request_id NUMBER := FND_API.G_MISS_NUM,
429: program_application_id NUMBER := FND_API.G_MISS_NUM,
422: TYPE competitor_rec_type IS RECORD
423: ( last_update_date Date := FND_API.G_MISS_DATE,
424: last_updated_by Number := FND_API.G_MISS_NUM,
425: creation_Date Date := FND_API.G_MISS_DATE,
426: created_by Number := FND_API.G_MISS_NUM,
427: last_update_login Number := FND_API.G_MISS_NUM,
428: request_id NUMBER := FND_API.G_MISS_NUM,
429: program_application_id NUMBER := FND_API.G_MISS_NUM,
430: program_id NUMBER := FND_API.G_MISS_NUM,
423: ( last_update_date Date := FND_API.G_MISS_DATE,
424: last_updated_by Number := FND_API.G_MISS_NUM,
425: creation_Date Date := FND_API.G_MISS_DATE,
426: created_by Number := FND_API.G_MISS_NUM,
427: last_update_login Number := FND_API.G_MISS_NUM,
428: request_id NUMBER := FND_API.G_MISS_NUM,
429: program_application_id NUMBER := FND_API.G_MISS_NUM,
430: program_id NUMBER := FND_API.G_MISS_NUM,
431: program_update_date DATE := FND_API.G_MISS_DATE,
424: last_updated_by Number := FND_API.G_MISS_NUM,
425: creation_Date Date := FND_API.G_MISS_DATE,
426: created_by Number := FND_API.G_MISS_NUM,
427: last_update_login Number := FND_API.G_MISS_NUM,
428: request_id NUMBER := FND_API.G_MISS_NUM,
429: program_application_id NUMBER := FND_API.G_MISS_NUM,
430: program_id NUMBER := FND_API.G_MISS_NUM,
431: program_update_date DATE := FND_API.G_MISS_DATE,
432: lead_competitor_id NUMBER := FND_API.G_MISS_NUM,
425: creation_Date Date := FND_API.G_MISS_DATE,
426: created_by Number := FND_API.G_MISS_NUM,
427: last_update_login Number := FND_API.G_MISS_NUM,
428: request_id NUMBER := FND_API.G_MISS_NUM,
429: program_application_id NUMBER := FND_API.G_MISS_NUM,
430: program_id NUMBER := FND_API.G_MISS_NUM,
431: program_update_date DATE := FND_API.G_MISS_DATE,
432: lead_competitor_id NUMBER := FND_API.G_MISS_NUM,
433: competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
426: created_by Number := FND_API.G_MISS_NUM,
427: last_update_login Number := FND_API.G_MISS_NUM,
428: request_id NUMBER := FND_API.G_MISS_NUM,
429: program_application_id NUMBER := FND_API.G_MISS_NUM,
430: program_id NUMBER := FND_API.G_MISS_NUM,
431: program_update_date DATE := FND_API.G_MISS_DATE,
432: lead_competitor_id NUMBER := FND_API.G_MISS_NUM,
433: competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
434: competitor_id NUMBER := FND_API.G_MISS_NUM,
427: last_update_login Number := FND_API.G_MISS_NUM,
428: request_id NUMBER := FND_API.G_MISS_NUM,
429: program_application_id NUMBER := FND_API.G_MISS_NUM,
430: program_id NUMBER := FND_API.G_MISS_NUM,
431: program_update_date DATE := FND_API.G_MISS_DATE,
432: lead_competitor_id NUMBER := FND_API.G_MISS_NUM,
433: competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
434: competitor_id NUMBER := FND_API.G_MISS_NUM,
435: relationship_party_id NUMBER := FND_API.G_MISS_NUM,
428: request_id NUMBER := FND_API.G_MISS_NUM,
429: program_application_id NUMBER := FND_API.G_MISS_NUM,
430: program_id NUMBER := FND_API.G_MISS_NUM,
431: program_update_date DATE := FND_API.G_MISS_DATE,
432: lead_competitor_id NUMBER := FND_API.G_MISS_NUM,
433: competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
434: competitor_id NUMBER := FND_API.G_MISS_NUM,
435: relationship_party_id NUMBER := FND_API.G_MISS_NUM,
436: lead_id NUMBER := FND_API.G_MISS_NUM,
429: program_application_id NUMBER := FND_API.G_MISS_NUM,
430: program_id NUMBER := FND_API.G_MISS_NUM,
431: program_update_date DATE := FND_API.G_MISS_DATE,
432: lead_competitor_id NUMBER := FND_API.G_MISS_NUM,
433: competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
434: competitor_id NUMBER := FND_API.G_MISS_NUM,
435: relationship_party_id NUMBER := FND_API.G_MISS_NUM,
436: lead_id NUMBER := FND_API.G_MISS_NUM,
437: competitor VARCHAR2(80) := FND_API.G_MISS_CHAR,
430: program_id NUMBER := FND_API.G_MISS_NUM,
431: program_update_date DATE := FND_API.G_MISS_DATE,
432: lead_competitor_id NUMBER := FND_API.G_MISS_NUM,
433: competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
434: competitor_id NUMBER := FND_API.G_MISS_NUM,
435: relationship_party_id NUMBER := FND_API.G_MISS_NUM,
436: lead_id NUMBER := FND_API.G_MISS_NUM,
437: competitor VARCHAR2(80) := FND_API.G_MISS_CHAR,
438: competitor_meaning VARCHAR2(240) := FND_API.G_MISS_CHAR,
431: program_update_date DATE := FND_API.G_MISS_DATE,
432: lead_competitor_id NUMBER := FND_API.G_MISS_NUM,
433: competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
434: competitor_id NUMBER := FND_API.G_MISS_NUM,
435: relationship_party_id NUMBER := FND_API.G_MISS_NUM,
436: lead_id NUMBER := FND_API.G_MISS_NUM,
437: competitor VARCHAR2(80) := FND_API.G_MISS_CHAR,
438: competitor_meaning VARCHAR2(240) := FND_API.G_MISS_CHAR,
439: competitor_rank NUMBER := FND_API.G_MISS_NUM,
432: lead_competitor_id NUMBER := FND_API.G_MISS_NUM,
433: competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
434: competitor_id NUMBER := FND_API.G_MISS_NUM,
435: relationship_party_id NUMBER := FND_API.G_MISS_NUM,
436: lead_id NUMBER := FND_API.G_MISS_NUM,
437: competitor VARCHAR2(80) := FND_API.G_MISS_CHAR,
438: competitor_meaning VARCHAR2(240) := FND_API.G_MISS_CHAR,
439: competitor_rank NUMBER := FND_API.G_MISS_NUM,
440: win_loss_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
433: competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
434: competitor_id NUMBER := FND_API.G_MISS_NUM,
435: relationship_party_id NUMBER := FND_API.G_MISS_NUM,
436: lead_id NUMBER := FND_API.G_MISS_NUM,
437: competitor VARCHAR2(80) := FND_API.G_MISS_CHAR,
438: competitor_meaning VARCHAR2(240) := FND_API.G_MISS_CHAR,
439: competitor_rank NUMBER := FND_API.G_MISS_NUM,
440: win_loss_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
441: products VARCHAR2(80) := FND_API.G_MISS_CHAR,
434: competitor_id NUMBER := FND_API.G_MISS_NUM,
435: relationship_party_id NUMBER := FND_API.G_MISS_NUM,
436: lead_id NUMBER := FND_API.G_MISS_NUM,
437: competitor VARCHAR2(80) := FND_API.G_MISS_CHAR,
438: competitor_meaning VARCHAR2(240) := FND_API.G_MISS_CHAR,
439: competitor_rank NUMBER := FND_API.G_MISS_NUM,
440: win_loss_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
441: products VARCHAR2(80) := FND_API.G_MISS_CHAR,
442: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
435: relationship_party_id NUMBER := FND_API.G_MISS_NUM,
436: lead_id NUMBER := FND_API.G_MISS_NUM,
437: competitor VARCHAR2(80) := FND_API.G_MISS_CHAR,
438: competitor_meaning VARCHAR2(240) := FND_API.G_MISS_CHAR,
439: competitor_rank NUMBER := FND_API.G_MISS_NUM,
440: win_loss_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
441: products VARCHAR2(80) := FND_API.G_MISS_CHAR,
442: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
443: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
436: lead_id NUMBER := FND_API.G_MISS_NUM,
437: competitor VARCHAR2(80) := FND_API.G_MISS_CHAR,
438: competitor_meaning VARCHAR2(240) := FND_API.G_MISS_CHAR,
439: competitor_rank NUMBER := FND_API.G_MISS_NUM,
440: win_loss_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
441: products VARCHAR2(80) := FND_API.G_MISS_CHAR,
442: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
443: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
444: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
437: competitor VARCHAR2(80) := FND_API.G_MISS_CHAR,
438: competitor_meaning VARCHAR2(240) := FND_API.G_MISS_CHAR,
439: competitor_rank NUMBER := FND_API.G_MISS_NUM,
440: win_loss_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
441: products VARCHAR2(80) := FND_API.G_MISS_CHAR,
442: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
443: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
444: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
445: ORG_ID NUMBER := FND_API.G_MISS_NUM,
438: competitor_meaning VARCHAR2(240) := FND_API.G_MISS_CHAR,
439: competitor_rank NUMBER := FND_API.G_MISS_NUM,
440: win_loss_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
441: products VARCHAR2(80) := FND_API.G_MISS_CHAR,
442: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
443: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
444: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
445: ORG_ID NUMBER := FND_API.G_MISS_NUM,
446: attribute_category VARCHAR2(30),
439: competitor_rank NUMBER := FND_API.G_MISS_NUM,
440: win_loss_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
441: products VARCHAR2(80) := FND_API.G_MISS_CHAR,
442: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
443: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
444: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
445: ORG_ID NUMBER := FND_API.G_MISS_NUM,
446: attribute_category VARCHAR2(30),
447: attribute1 VARCHAR2(150),
440: win_loss_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
441: products VARCHAR2(80) := FND_API.G_MISS_CHAR,
442: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
443: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
444: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
445: ORG_ID NUMBER := FND_API.G_MISS_NUM,
446: attribute_category VARCHAR2(30),
447: attribute1 VARCHAR2(150),
448: attribute2 VARCHAR2(150),
441: products VARCHAR2(80) := FND_API.G_MISS_CHAR,
442: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
443: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
444: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
445: ORG_ID NUMBER := FND_API.G_MISS_NUM,
446: attribute_category VARCHAR2(30),
447: attribute1 VARCHAR2(150),
448: attribute2 VARCHAR2(150),
449: attribute3 VARCHAR2(150),
478: -- Order Record Type
479: --
480:
481: TYPE order_rec_type IS RECORD
482: ( last_update_date Date := FND_API.G_MISS_DATE,
483: last_updated_by Number := FND_API.G_MISS_NUM,
484: creation_Date Date := FND_API.G_MISS_DATE,
485: created_by Number := FND_API.G_MISS_NUM,
486: last_update_login Number := FND_API.G_MISS_NUM,
479: --
480:
481: TYPE order_rec_type IS RECORD
482: ( last_update_date Date := FND_API.G_MISS_DATE,
483: last_updated_by Number := FND_API.G_MISS_NUM,
484: creation_Date Date := FND_API.G_MISS_DATE,
485: created_by Number := FND_API.G_MISS_NUM,
486: last_update_login Number := FND_API.G_MISS_NUM,
487: request_id NUMBER := FND_API.G_MISS_NUM,
480:
481: TYPE order_rec_type IS RECORD
482: ( last_update_date Date := FND_API.G_MISS_DATE,
483: last_updated_by Number := FND_API.G_MISS_NUM,
484: creation_Date Date := FND_API.G_MISS_DATE,
485: created_by Number := FND_API.G_MISS_NUM,
486: last_update_login Number := FND_API.G_MISS_NUM,
487: request_id NUMBER := FND_API.G_MISS_NUM,
488: program_application_id NUMBER := FND_API.G_MISS_NUM,
481: TYPE order_rec_type IS RECORD
482: ( last_update_date Date := FND_API.G_MISS_DATE,
483: last_updated_by Number := FND_API.G_MISS_NUM,
484: creation_Date Date := FND_API.G_MISS_DATE,
485: created_by Number := FND_API.G_MISS_NUM,
486: last_update_login Number := FND_API.G_MISS_NUM,
487: request_id NUMBER := FND_API.G_MISS_NUM,
488: program_application_id NUMBER := FND_API.G_MISS_NUM,
489: program_id NUMBER := FND_API.G_MISS_NUM,
482: ( last_update_date Date := FND_API.G_MISS_DATE,
483: last_updated_by Number := FND_API.G_MISS_NUM,
484: creation_Date Date := FND_API.G_MISS_DATE,
485: created_by Number := FND_API.G_MISS_NUM,
486: last_update_login Number := FND_API.G_MISS_NUM,
487: request_id NUMBER := FND_API.G_MISS_NUM,
488: program_application_id NUMBER := FND_API.G_MISS_NUM,
489: program_id NUMBER := FND_API.G_MISS_NUM,
490: program_update_date DATE := FND_API.G_MISS_DATE,
483: last_updated_by Number := FND_API.G_MISS_NUM,
484: creation_Date Date := FND_API.G_MISS_DATE,
485: created_by Number := FND_API.G_MISS_NUM,
486: last_update_login Number := FND_API.G_MISS_NUM,
487: request_id NUMBER := FND_API.G_MISS_NUM,
488: program_application_id NUMBER := FND_API.G_MISS_NUM,
489: program_id NUMBER := FND_API.G_MISS_NUM,
490: program_update_date DATE := FND_API.G_MISS_DATE,
491: lead_order_id NUMBER := FND_API.G_MISS_NUM,
484: creation_Date Date := FND_API.G_MISS_DATE,
485: created_by Number := FND_API.G_MISS_NUM,
486: last_update_login Number := FND_API.G_MISS_NUM,
487: request_id NUMBER := FND_API.G_MISS_NUM,
488: program_application_id NUMBER := FND_API.G_MISS_NUM,
489: program_id NUMBER := FND_API.G_MISS_NUM,
490: program_update_date DATE := FND_API.G_MISS_DATE,
491: lead_order_id NUMBER := FND_API.G_MISS_NUM,
492: lead_id NUMBER := FND_API.G_MISS_NUM,
485: created_by Number := FND_API.G_MISS_NUM,
486: last_update_login Number := FND_API.G_MISS_NUM,
487: request_id NUMBER := FND_API.G_MISS_NUM,
488: program_application_id NUMBER := FND_API.G_MISS_NUM,
489: program_id NUMBER := FND_API.G_MISS_NUM,
490: program_update_date DATE := FND_API.G_MISS_DATE,
491: lead_order_id NUMBER := FND_API.G_MISS_NUM,
492: lead_id NUMBER := FND_API.G_MISS_NUM,
493: order_number NUMBER := FND_API.G_MISS_NUM,
486: last_update_login Number := FND_API.G_MISS_NUM,
487: request_id NUMBER := FND_API.G_MISS_NUM,
488: program_application_id NUMBER := FND_API.G_MISS_NUM,
489: program_id NUMBER := FND_API.G_MISS_NUM,
490: program_update_date DATE := FND_API.G_MISS_DATE,
491: lead_order_id NUMBER := FND_API.G_MISS_NUM,
492: lead_id NUMBER := FND_API.G_MISS_NUM,
493: order_number NUMBER := FND_API.G_MISS_NUM,
494: order_header_id NUMBER := FND_API.G_MISS_NUM,
487: request_id NUMBER := FND_API.G_MISS_NUM,
488: program_application_id NUMBER := FND_API.G_MISS_NUM,
489: program_id NUMBER := FND_API.G_MISS_NUM,
490: program_update_date DATE := FND_API.G_MISS_DATE,
491: lead_order_id NUMBER := FND_API.G_MISS_NUM,
492: lead_id NUMBER := FND_API.G_MISS_NUM,
493: order_number NUMBER := FND_API.G_MISS_NUM,
494: order_header_id NUMBER := FND_API.G_MISS_NUM,
495: date_ordered Date := FND_API.G_MISS_DATE,
488: program_application_id NUMBER := FND_API.G_MISS_NUM,
489: program_id NUMBER := FND_API.G_MISS_NUM,
490: program_update_date DATE := FND_API.G_MISS_DATE,
491: lead_order_id NUMBER := FND_API.G_MISS_NUM,
492: lead_id NUMBER := FND_API.G_MISS_NUM,
493: order_number NUMBER := FND_API.G_MISS_NUM,
494: order_header_id NUMBER := FND_API.G_MISS_NUM,
495: date_ordered Date := FND_API.G_MISS_DATE,
496: order_type_id Number := FND_API.G_MISS_NUM,
489: program_id NUMBER := FND_API.G_MISS_NUM,
490: program_update_date DATE := FND_API.G_MISS_DATE,
491: lead_order_id NUMBER := FND_API.G_MISS_NUM,
492: lead_id NUMBER := FND_API.G_MISS_NUM,
493: order_number NUMBER := FND_API.G_MISS_NUM,
494: order_header_id NUMBER := FND_API.G_MISS_NUM,
495: date_ordered Date := FND_API.G_MISS_DATE,
496: order_type_id Number := FND_API.G_MISS_NUM,
497: order_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
490: program_update_date DATE := FND_API.G_MISS_DATE,
491: lead_order_id NUMBER := FND_API.G_MISS_NUM,
492: lead_id NUMBER := FND_API.G_MISS_NUM,
493: order_number NUMBER := FND_API.G_MISS_NUM,
494: order_header_id NUMBER := FND_API.G_MISS_NUM,
495: date_ordered Date := FND_API.G_MISS_DATE,
496: order_type_id Number := FND_API.G_MISS_NUM,
497: order_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
498: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
491: lead_order_id NUMBER := FND_API.G_MISS_NUM,
492: lead_id NUMBER := FND_API.G_MISS_NUM,
493: order_number NUMBER := FND_API.G_MISS_NUM,
494: order_header_id NUMBER := FND_API.G_MISS_NUM,
495: date_ordered Date := FND_API.G_MISS_DATE,
496: order_type_id Number := FND_API.G_MISS_NUM,
497: order_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
498: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
499: order_amount NUMBER := FND_API.G_MISS_NUM,
492: lead_id NUMBER := FND_API.G_MISS_NUM,
493: order_number NUMBER := FND_API.G_MISS_NUM,
494: order_header_id NUMBER := FND_API.G_MISS_NUM,
495: date_ordered Date := FND_API.G_MISS_DATE,
496: order_type_id Number := FND_API.G_MISS_NUM,
497: order_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
498: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
499: order_amount NUMBER := FND_API.G_MISS_NUM,
500: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
493: order_number NUMBER := FND_API.G_MISS_NUM,
494: order_header_id NUMBER := FND_API.G_MISS_NUM,
495: date_ordered Date := FND_API.G_MISS_DATE,
496: order_type_id Number := FND_API.G_MISS_NUM,
497: order_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
498: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
499: order_amount NUMBER := FND_API.G_MISS_NUM,
500: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
501: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
494: order_header_id NUMBER := FND_API.G_MISS_NUM,
495: date_ordered Date := FND_API.G_MISS_DATE,
496: order_type_id Number := FND_API.G_MISS_NUM,
497: order_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
498: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
499: order_amount NUMBER := FND_API.G_MISS_NUM,
500: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
501: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
502: ORG_ID NUMBER := FND_API.G_MISS_NUM,
495: date_ordered Date := FND_API.G_MISS_DATE,
496: order_type_id Number := FND_API.G_MISS_NUM,
497: order_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
498: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
499: order_amount NUMBER := FND_API.G_MISS_NUM,
500: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
501: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
502: ORG_ID NUMBER := FND_API.G_MISS_NUM,
503: attribute_category VARCHAR2(30),
496: order_type_id Number := FND_API.G_MISS_NUM,
497: order_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
498: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
499: order_amount NUMBER := FND_API.G_MISS_NUM,
500: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
501: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
502: ORG_ID NUMBER := FND_API.G_MISS_NUM,
503: attribute_category VARCHAR2(30),
504: attribute1 VARCHAR2(150),
497: order_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
498: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
499: order_amount NUMBER := FND_API.G_MISS_NUM,
500: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
501: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
502: ORG_ID NUMBER := FND_API.G_MISS_NUM,
503: attribute_category VARCHAR2(30),
504: attribute1 VARCHAR2(150),
505: attribute2 VARCHAR2(150),
498: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
499: order_amount NUMBER := FND_API.G_MISS_NUM,
500: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
501: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
502: ORG_ID NUMBER := FND_API.G_MISS_NUM,
503: attribute_category VARCHAR2(30),
504: attribute1 VARCHAR2(150),
505: attribute2 VARCHAR2(150),
506: attribute3 VARCHAR2(150),
535: -- Contact Record Type
536: --
537:
538: TYPE contact_rec_type IS RECORD
539: ( last_update_date Date := FND_API.G_MISS_DATE,
540: last_updated_by Number := FND_API.G_MISS_NUM,
541: creation_Date Date := FND_API.G_MISS_DATE,
542: created_by Number := FND_API.G_MISS_NUM,
543: last_update_login Number := FND_API.G_MISS_NUM,
536: --
537:
538: TYPE contact_rec_type IS RECORD
539: ( last_update_date Date := FND_API.G_MISS_DATE,
540: last_updated_by Number := FND_API.G_MISS_NUM,
541: creation_Date Date := FND_API.G_MISS_DATE,
542: created_by Number := FND_API.G_MISS_NUM,
543: last_update_login Number := FND_API.G_MISS_NUM,
544: request_id NUMBER := FND_API.G_MISS_NUM,
537:
538: TYPE contact_rec_type IS RECORD
539: ( last_update_date Date := FND_API.G_MISS_DATE,
540: last_updated_by Number := FND_API.G_MISS_NUM,
541: creation_Date Date := FND_API.G_MISS_DATE,
542: created_by Number := FND_API.G_MISS_NUM,
543: last_update_login Number := FND_API.G_MISS_NUM,
544: request_id NUMBER := FND_API.G_MISS_NUM,
545: program_application_id NUMBER := FND_API.G_MISS_NUM,
538: TYPE contact_rec_type IS RECORD
539: ( last_update_date Date := FND_API.G_MISS_DATE,
540: last_updated_by Number := FND_API.G_MISS_NUM,
541: creation_Date Date := FND_API.G_MISS_DATE,
542: created_by Number := FND_API.G_MISS_NUM,
543: last_update_login Number := FND_API.G_MISS_NUM,
544: request_id NUMBER := FND_API.G_MISS_NUM,
545: program_application_id NUMBER := FND_API.G_MISS_NUM,
546: program_id NUMBER := FND_API.G_MISS_NUM,
539: ( last_update_date Date := FND_API.G_MISS_DATE,
540: last_updated_by Number := FND_API.G_MISS_NUM,
541: creation_Date Date := FND_API.G_MISS_DATE,
542: created_by Number := FND_API.G_MISS_NUM,
543: last_update_login Number := FND_API.G_MISS_NUM,
544: request_id NUMBER := FND_API.G_MISS_NUM,
545: program_application_id NUMBER := FND_API.G_MISS_NUM,
546: program_id NUMBER := FND_API.G_MISS_NUM,
547: program_update_date DATE := FND_API.G_MISS_DATE,
540: last_updated_by Number := FND_API.G_MISS_NUM,
541: creation_Date Date := FND_API.G_MISS_DATE,
542: created_by Number := FND_API.G_MISS_NUM,
543: last_update_login Number := FND_API.G_MISS_NUM,
544: request_id NUMBER := FND_API.G_MISS_NUM,
545: program_application_id NUMBER := FND_API.G_MISS_NUM,
546: program_id NUMBER := FND_API.G_MISS_NUM,
547: program_update_date DATE := FND_API.G_MISS_DATE,
548: lead_contact_id NUMBER := FND_API.G_MISS_NUM,
541: creation_Date Date := FND_API.G_MISS_DATE,
542: created_by Number := FND_API.G_MISS_NUM,
543: last_update_login Number := FND_API.G_MISS_NUM,
544: request_id NUMBER := FND_API.G_MISS_NUM,
545: program_application_id NUMBER := FND_API.G_MISS_NUM,
546: program_id NUMBER := FND_API.G_MISS_NUM,
547: program_update_date DATE := FND_API.G_MISS_DATE,
548: lead_contact_id NUMBER := FND_API.G_MISS_NUM,
549: lead_id NUMBER := FND_API.G_MISS_NUM,
542: created_by Number := FND_API.G_MISS_NUM,
543: last_update_login Number := FND_API.G_MISS_NUM,
544: request_id NUMBER := FND_API.G_MISS_NUM,
545: program_application_id NUMBER := FND_API.G_MISS_NUM,
546: program_id NUMBER := FND_API.G_MISS_NUM,
547: program_update_date DATE := FND_API.G_MISS_DATE,
548: lead_contact_id NUMBER := FND_API.G_MISS_NUM,
549: lead_id NUMBER := FND_API.G_MISS_NUM,
550: customer_id NUMBER := FND_API.G_MISS_NUM,
543: last_update_login Number := FND_API.G_MISS_NUM,
544: request_id NUMBER := FND_API.G_MISS_NUM,
545: program_application_id NUMBER := FND_API.G_MISS_NUM,
546: program_id NUMBER := FND_API.G_MISS_NUM,
547: program_update_date DATE := FND_API.G_MISS_DATE,
548: lead_contact_id NUMBER := FND_API.G_MISS_NUM,
549: lead_id NUMBER := FND_API.G_MISS_NUM,
550: customer_id NUMBER := FND_API.G_MISS_NUM,
551: address_id NUMBER := FND_API.G_MISS_NUM,
544: request_id NUMBER := FND_API.G_MISS_NUM,
545: program_application_id NUMBER := FND_API.G_MISS_NUM,
546: program_id NUMBER := FND_API.G_MISS_NUM,
547: program_update_date DATE := FND_API.G_MISS_DATE,
548: lead_contact_id NUMBER := FND_API.G_MISS_NUM,
549: lead_id NUMBER := FND_API.G_MISS_NUM,
550: customer_id NUMBER := FND_API.G_MISS_NUM,
551: address_id NUMBER := FND_API.G_MISS_NUM,
552: phone_id NUMBER := FND_API.G_MISS_NUM,
545: program_application_id NUMBER := FND_API.G_MISS_NUM,
546: program_id NUMBER := FND_API.G_MISS_NUM,
547: program_update_date DATE := FND_API.G_MISS_DATE,
548: lead_contact_id NUMBER := FND_API.G_MISS_NUM,
549: lead_id NUMBER := FND_API.G_MISS_NUM,
550: customer_id NUMBER := FND_API.G_MISS_NUM,
551: address_id NUMBER := FND_API.G_MISS_NUM,
552: phone_id NUMBER := FND_API.G_MISS_NUM,
553: first_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
546: program_id NUMBER := FND_API.G_MISS_NUM,
547: program_update_date DATE := FND_API.G_MISS_DATE,
548: lead_contact_id NUMBER := FND_API.G_MISS_NUM,
549: lead_id NUMBER := FND_API.G_MISS_NUM,
550: customer_id NUMBER := FND_API.G_MISS_NUM,
551: address_id NUMBER := FND_API.G_MISS_NUM,
552: phone_id NUMBER := FND_API.G_MISS_NUM,
553: first_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
554: last_name VARCHAR2(50) := FND_API.G_MISS_CHAR,
547: program_update_date DATE := FND_API.G_MISS_DATE,
548: lead_contact_id NUMBER := FND_API.G_MISS_NUM,
549: lead_id NUMBER := FND_API.G_MISS_NUM,
550: customer_id NUMBER := FND_API.G_MISS_NUM,
551: address_id NUMBER := FND_API.G_MISS_NUM,
552: phone_id NUMBER := FND_API.G_MISS_NUM,
553: first_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
554: last_name VARCHAR2(50) := FND_API.G_MISS_CHAR,
555: contact_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
548: lead_contact_id NUMBER := FND_API.G_MISS_NUM,
549: lead_id NUMBER := FND_API.G_MISS_NUM,
550: customer_id NUMBER := FND_API.G_MISS_NUM,
551: address_id NUMBER := FND_API.G_MISS_NUM,
552: phone_id NUMBER := FND_API.G_MISS_NUM,
553: first_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
554: last_name VARCHAR2(50) := FND_API.G_MISS_CHAR,
555: contact_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
556: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
549: lead_id NUMBER := FND_API.G_MISS_NUM,
550: customer_id NUMBER := FND_API.G_MISS_NUM,
551: address_id NUMBER := FND_API.G_MISS_NUM,
552: phone_id NUMBER := FND_API.G_MISS_NUM,
553: first_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
554: last_name VARCHAR2(50) := FND_API.G_MISS_CHAR,
555: contact_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
556: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
557: contact_id NUMBER := FND_API.G_MISS_NUM,
550: customer_id NUMBER := FND_API.G_MISS_NUM,
551: address_id NUMBER := FND_API.G_MISS_NUM,
552: phone_id NUMBER := FND_API.G_MISS_NUM,
553: first_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
554: last_name VARCHAR2(50) := FND_API.G_MISS_CHAR,
555: contact_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
556: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
557: contact_id NUMBER := FND_API.G_MISS_NUM,
558: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
551: address_id NUMBER := FND_API.G_MISS_NUM,
552: phone_id NUMBER := FND_API.G_MISS_NUM,
553: first_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
554: last_name VARCHAR2(50) := FND_API.G_MISS_CHAR,
555: contact_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
556: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
557: contact_id NUMBER := FND_API.G_MISS_NUM,
558: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
559: rank_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
552: phone_id NUMBER := FND_API.G_MISS_NUM,
553: first_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
554: last_name VARCHAR2(50) := FND_API.G_MISS_CHAR,
555: contact_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
556: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
557: contact_id NUMBER := FND_API.G_MISS_NUM,
558: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
559: rank_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
560: rank VARCHAR2(80) := FND_API.G_MISS_CHAR,
553: first_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
554: last_name VARCHAR2(50) := FND_API.G_MISS_CHAR,
555: contact_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
556: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
557: contact_id NUMBER := FND_API.G_MISS_NUM,
558: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
559: rank_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
560: rank VARCHAR2(80) := FND_API.G_MISS_CHAR,
561: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
554: last_name VARCHAR2(50) := FND_API.G_MISS_CHAR,
555: contact_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
556: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
557: contact_id NUMBER := FND_API.G_MISS_NUM,
558: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
559: rank_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
560: rank VARCHAR2(80) := FND_API.G_MISS_CHAR,
561: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
562: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
555: contact_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
556: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
557: contact_id NUMBER := FND_API.G_MISS_NUM,
558: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
559: rank_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
560: rank VARCHAR2(80) := FND_API.G_MISS_CHAR,
561: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
562: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
563: contact_party_id NUMBER := FND_API.G_MISS_NUM,
556: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
557: contact_id NUMBER := FND_API.G_MISS_NUM,
558: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
559: rank_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
560: rank VARCHAR2(80) := FND_API.G_MISS_CHAR,
561: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
562: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
563: contact_party_id NUMBER := FND_API.G_MISS_NUM,
564: primary_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
557: contact_id NUMBER := FND_API.G_MISS_NUM,
558: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
559: rank_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
560: rank VARCHAR2(80) := FND_API.G_MISS_CHAR,
561: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
562: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
563: contact_party_id NUMBER := FND_API.G_MISS_NUM,
564: primary_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
565: role VARCHAR2(30) := FND_API.G_MISS_CHAR,
558: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
559: rank_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
560: rank VARCHAR2(80) := FND_API.G_MISS_CHAR,
561: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
562: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
563: contact_party_id NUMBER := FND_API.G_MISS_NUM,
564: primary_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
565: role VARCHAR2(30) := FND_API.G_MISS_CHAR,
566: ORG_ID NUMBER := FND_API.G_MISS_NUM,
559: rank_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
560: rank VARCHAR2(80) := FND_API.G_MISS_CHAR,
561: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
562: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
563: contact_party_id NUMBER := FND_API.G_MISS_NUM,
564: primary_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
565: role VARCHAR2(30) := FND_API.G_MISS_CHAR,
566: ORG_ID NUMBER := FND_API.G_MISS_NUM,
567: attribute_category VARCHAR2(30),
560: rank VARCHAR2(80) := FND_API.G_MISS_CHAR,
561: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
562: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
563: contact_party_id NUMBER := FND_API.G_MISS_NUM,
564: primary_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
565: role VARCHAR2(30) := FND_API.G_MISS_CHAR,
566: ORG_ID NUMBER := FND_API.G_MISS_NUM,
567: attribute_category VARCHAR2(30),
568: attribute1 VARCHAR2(150),
561: member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
562: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
563: contact_party_id NUMBER := FND_API.G_MISS_NUM,
564: primary_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
565: role VARCHAR2(30) := FND_API.G_MISS_CHAR,
566: ORG_ID NUMBER := FND_API.G_MISS_NUM,
567: attribute_category VARCHAR2(30),
568: attribute1 VARCHAR2(150),
569: attribute2 VARCHAR2(150),
562: member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
563: contact_party_id NUMBER := FND_API.G_MISS_NUM,
564: primary_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
565: role VARCHAR2(30) := FND_API.G_MISS_CHAR,
566: ORG_ID NUMBER := FND_API.G_MISS_NUM,
567: attribute_category VARCHAR2(30),
568: attribute1 VARCHAR2(150),
569: attribute2 VARCHAR2(150),
570: attribute3 VARCHAR2(150),
597:
598:
599: TYPE Competitor_Prod_Rec_Type IS RECORD
600: (
601: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
602: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
603: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
604: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
605: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
598:
599: TYPE Competitor_Prod_Rec_Type IS RECORD
600: (
601: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
602: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
603: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
604: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
605: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
606: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
599: TYPE Competitor_Prod_Rec_Type IS RECORD
600: (
601: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
602: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
603: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
604: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
605: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
606: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
607: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
600: (
601: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
602: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
603: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
604: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
605: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
606: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
607: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
608: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
601: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
602: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
603: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
604: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
605: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
606: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
607: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
608: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
609: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
602: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
603: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
604: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
605: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
606: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
607: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
608: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
609: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
610: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
603: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
604: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
605: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
606: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
607: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
608: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
609: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
610: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
611: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
604: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
605: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
606: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
607: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
608: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
609: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
610: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
611: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
612: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
605: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
606: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
607: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
608: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
609: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
610: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
611: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
612: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
613: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
606: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
607: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
608: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
609: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
610: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
611: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
612: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
613: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
614: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
607: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
608: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
609: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
610: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
611: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
612: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
613: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
614: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
615: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
608: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
609: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
610: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
611: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
612: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
613: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
614: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
615: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
616: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
609: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
610: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
611: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
612: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
613: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
614: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
615: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
616: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
617: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
610: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
611: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
612: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
613: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
614: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
615: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
616: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
617: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
611: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
612: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
613: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
614: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
615: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
616: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
617: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
619: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
612: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
613: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
614: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
615: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
616: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
617: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
619: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
620: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
613: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
614: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
615: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
616: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
617: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
619: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
620: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
621: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
614: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
615: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
616: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
617: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
619: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
620: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
621: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
622: WIN_LOSS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
615: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
616: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
617: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
619: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
620: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
621: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
622: WIN_LOSS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
623: COMPETITOR_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
616: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
617: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
619: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
620: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
621: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
622: WIN_LOSS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
623: COMPETITOR_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
624: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
617: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
619: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
620: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
621: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
622: WIN_LOSS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
623: COMPETITOR_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
624: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
625: LEAD_ID NUMBER := FND_API.G_MISS_NUM,
618: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
619: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
620: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
621: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
622: WIN_LOSS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
623: COMPETITOR_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
624: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
625: LEAD_ID NUMBER := FND_API.G_MISS_NUM,
626: LEAD_COMPETITOR_PROD_ID NUMBER := FND_API.G_MISS_NUM,
619: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
620: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
621: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
622: WIN_LOSS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
623: COMPETITOR_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
624: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
625: LEAD_ID NUMBER := FND_API.G_MISS_NUM,
626: LEAD_COMPETITOR_PROD_ID NUMBER := FND_API.G_MISS_NUM,
627: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
620: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
621: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
622: WIN_LOSS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
623: COMPETITOR_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
624: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
625: LEAD_ID NUMBER := FND_API.G_MISS_NUM,
626: LEAD_COMPETITOR_PROD_ID NUMBER := FND_API.G_MISS_NUM,
627: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
628: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
621: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
622: WIN_LOSS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
623: COMPETITOR_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
624: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
625: LEAD_ID NUMBER := FND_API.G_MISS_NUM,
626: LEAD_COMPETITOR_PROD_ID NUMBER := FND_API.G_MISS_NUM,
627: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
628: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
629: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
622: WIN_LOSS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
623: COMPETITOR_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
624: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
625: LEAD_ID NUMBER := FND_API.G_MISS_NUM,
626: LEAD_COMPETITOR_PROD_ID NUMBER := FND_API.G_MISS_NUM,
627: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
628: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
629: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
630: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
623: COMPETITOR_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
624: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
625: LEAD_ID NUMBER := FND_API.G_MISS_NUM,
626: LEAD_COMPETITOR_PROD_ID NUMBER := FND_API.G_MISS_NUM,
627: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
628: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
629: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
630: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
631: CREATION_DATE DATE := FND_API.G_MISS_DATE
624: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
625: LEAD_ID NUMBER := FND_API.G_MISS_NUM,
626: LEAD_COMPETITOR_PROD_ID NUMBER := FND_API.G_MISS_NUM,
627: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
628: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
629: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
630: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
631: CREATION_DATE DATE := FND_API.G_MISS_DATE
632: );
625: LEAD_ID NUMBER := FND_API.G_MISS_NUM,
626: LEAD_COMPETITOR_PROD_ID NUMBER := FND_API.G_MISS_NUM,
627: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
628: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
629: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
630: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
631: CREATION_DATE DATE := FND_API.G_MISS_DATE
632: );
633:
626: LEAD_COMPETITOR_PROD_ID NUMBER := FND_API.G_MISS_NUM,
627: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
628: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
629: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
630: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
631: CREATION_DATE DATE := FND_API.G_MISS_DATE
632: );
633:
634: G_MISS_Competitor_Prod_REC Competitor_Prod_Rec_Type;
627: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
628: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
629: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
630: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
631: CREATION_DATE DATE := FND_API.G_MISS_DATE
632: );
633:
634: G_MISS_Competitor_Prod_REC Competitor_Prod_Rec_Type;
635: TYPE Competitor_Prod_Tbl_Type IS TABLE OF Competitor_Prod_Rec_Type
646:
647:
648: TYPE Decision_Factor_Rec_Type IS RECORD
649: (
650: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
651: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
652: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
653: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
654: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
647:
648: TYPE Decision_Factor_Rec_Type IS RECORD
649: (
650: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
651: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
652: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
653: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
654: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
655: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
648: TYPE Decision_Factor_Rec_Type IS RECORD
649: (
650: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
651: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
652: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
653: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
654: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
655: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
656: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
649: (
650: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
651: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
652: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
653: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
654: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
655: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
656: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
657: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
650: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
651: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
652: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
653: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
654: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
655: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
656: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
657: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
658: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
651: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
652: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
653: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
654: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
655: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
656: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
657: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
658: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
659: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
652: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
653: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
654: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
655: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
656: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
657: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
658: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
659: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
660: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
653: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
654: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
655: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
656: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
657: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
658: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
659: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
660: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
661: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
654: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
655: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
656: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
657: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
658: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
659: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
660: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
661: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
662: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
655: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
656: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
657: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
658: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
659: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
660: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
661: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
662: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
663: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
656: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
657: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
658: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
659: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
660: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
661: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
662: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
663: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
664: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
657: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
658: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
659: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
660: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
661: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
662: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
663: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
664: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
665: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
658: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
659: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
660: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
661: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
662: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
663: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
664: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
665: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
666: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
659: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
660: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
661: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
662: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
663: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
664: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
665: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
666: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
667: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
660: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
661: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
662: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
663: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
664: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
665: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
666: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
667: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
668: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
661: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
662: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
663: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
664: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
665: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
666: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
667: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
668: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
669: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
662: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
663: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
664: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
665: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
666: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
667: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
668: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
669: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
670: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
663: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
664: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
665: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
666: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
667: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
668: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
669: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
670: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
671: DECISION_RANK NUMBER := FND_API.G_MISS_NUM,
664: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
665: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
666: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
667: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
668: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
669: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
670: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
671: DECISION_RANK NUMBER := FND_API.G_MISS_NUM,
672: DECISION_PRIORITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
665: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
666: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
667: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
668: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
669: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
670: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
671: DECISION_RANK NUMBER := FND_API.G_MISS_NUM,
672: DECISION_PRIORITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
673: DECISION_FACTOR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
666: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
667: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
668: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
669: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
670: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
671: DECISION_RANK NUMBER := FND_API.G_MISS_NUM,
672: DECISION_PRIORITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
673: DECISION_FACTOR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
674: LEAD_DECISION_FACTOR_ID NUMBER := FND_API.G_MISS_NUM,
667: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
668: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
669: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
670: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
671: DECISION_RANK NUMBER := FND_API.G_MISS_NUM,
672: DECISION_PRIORITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
673: DECISION_FACTOR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
674: LEAD_DECISION_FACTOR_ID NUMBER := FND_API.G_MISS_NUM,
675: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
668: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
669: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
670: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
671: DECISION_RANK NUMBER := FND_API.G_MISS_NUM,
672: DECISION_PRIORITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
673: DECISION_FACTOR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
674: LEAD_DECISION_FACTOR_ID NUMBER := FND_API.G_MISS_NUM,
675: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
676: CREATE_BY NUMBER := FND_API.G_MISS_NUM,
669: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
670: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
671: DECISION_RANK NUMBER := FND_API.G_MISS_NUM,
672: DECISION_PRIORITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
673: DECISION_FACTOR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
674: LEAD_DECISION_FACTOR_ID NUMBER := FND_API.G_MISS_NUM,
675: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
676: CREATE_BY NUMBER := FND_API.G_MISS_NUM,
677: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
670: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
671: DECISION_RANK NUMBER := FND_API.G_MISS_NUM,
672: DECISION_PRIORITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
673: DECISION_FACTOR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
674: LEAD_DECISION_FACTOR_ID NUMBER := FND_API.G_MISS_NUM,
675: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
676: CREATE_BY NUMBER := FND_API.G_MISS_NUM,
677: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
678: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
671: DECISION_RANK NUMBER := FND_API.G_MISS_NUM,
672: DECISION_PRIORITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
673: DECISION_FACTOR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
674: LEAD_DECISION_FACTOR_ID NUMBER := FND_API.G_MISS_NUM,
675: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
676: CREATE_BY NUMBER := FND_API.G_MISS_NUM,
677: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
678: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
679: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
672: DECISION_PRIORITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
673: DECISION_FACTOR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
674: LEAD_DECISION_FACTOR_ID NUMBER := FND_API.G_MISS_NUM,
675: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
676: CREATE_BY NUMBER := FND_API.G_MISS_NUM,
677: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
678: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
679: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
680: CREATION_DATE DATE := FND_API.G_MISS_DATE
673: DECISION_FACTOR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
674: LEAD_DECISION_FACTOR_ID NUMBER := FND_API.G_MISS_NUM,
675: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
676: CREATE_BY NUMBER := FND_API.G_MISS_NUM,
677: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
678: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
679: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
680: CREATION_DATE DATE := FND_API.G_MISS_DATE
681: );
674: LEAD_DECISION_FACTOR_ID NUMBER := FND_API.G_MISS_NUM,
675: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
676: CREATE_BY NUMBER := FND_API.G_MISS_NUM,
677: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
678: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
679: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
680: CREATION_DATE DATE := FND_API.G_MISS_DATE
681: );
682:
675: LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
676: CREATE_BY NUMBER := FND_API.G_MISS_NUM,
677: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
678: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
679: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
680: CREATION_DATE DATE := FND_API.G_MISS_DATE
681: );
682:
683: G_MISS_Decision_Factor_REC Decision_Factor_Rec_Type;
676: CREATE_BY NUMBER := FND_API.G_MISS_NUM,
677: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
678: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
679: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
680: CREATION_DATE DATE := FND_API.G_MISS_DATE
681: );
682:
683: G_MISS_Decision_Factor_REC Decision_Factor_Rec_Type;
684: TYPE Decision_Factor_Tbl_Type IS TABLE OF Decision_Factor_Rec_Type
730: *
731: * @param p_api_version_number API version number.
732: * @param p_init_msg_list Intialize the message array.
733: * @param p_commit Commit after processing the transaction.
734: * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
735: * or FND_API.G_VALID_LEVEL_FULL).
736: * @param p_header_rec Record of the opportunity header to be created. The
737: * record type passed in p_header_rec is defined in the package AS_OPPORTUNITY_PUB.
738: * @param p_check_access_flag Check whether the logged in user has privileges
731: * @param p_api_version_number API version number.
732: * @param p_init_msg_list Intialize the message array.
733: * @param p_commit Commit after processing the transaction.
734: * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
735: * or FND_API.G_VALID_LEVEL_FULL).
736: * @param p_header_rec Record of the opportunity header to be created. The
737: * record type passed in p_header_rec is defined in the package AS_OPPORTUNITY_PUB.
738: * @param p_check_access_flag Check whether the logged in user has privileges
739: * to create the opportunity.
757: * @rep:displayname Create Opportunity Header
758: */
759: PROCEDURE Create_Opp_Header
760: ( p_api_version_number IN NUMBER,
761: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
762: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
763: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
764: p_header_rec IN HEADER_REC_TYPE DEFAULT G_MISS_HEADER_REC,
765: p_check_access_flag IN VARCHAR2,
758: */
759: PROCEDURE Create_Opp_Header
760: ( p_api_version_number IN NUMBER,
761: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
762: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
763: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
764: p_header_rec IN HEADER_REC_TYPE DEFAULT G_MISS_HEADER_REC,
765: p_check_access_flag IN VARCHAR2,
766: p_admin_flag IN VARCHAR2,
759: PROCEDURE Create_Opp_Header
760: ( p_api_version_number IN NUMBER,
761: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
762: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
763: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
764: p_header_rec IN HEADER_REC_TYPE DEFAULT G_MISS_HEADER_REC,
765: p_check_access_flag IN VARCHAR2,
766: p_admin_flag IN VARCHAR2,
767: p_admin_group_id IN NUMBER,
806: *
807: * @param p_api_version_number API version number.
808: * @param p_init_msg_list Intialize the message array.
809: * @param p_commit Commit after processing the transaction.
810: * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
811: * or FND_API.G_VALID_LEVEL_FULL).
812: * @param p_header_rec Record of the opportunity header to be updated. The
813: * record type passed in p_header_rec is defined in the package AS_OPPORTUNITY_PUB.
814: * @param p_check_access_flag Check whether the logged in user has privileges
807: * @param p_api_version_number API version number.
808: * @param p_init_msg_list Intialize the message array.
809: * @param p_commit Commit after processing the transaction.
810: * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
811: * or FND_API.G_VALID_LEVEL_FULL).
812: * @param p_header_rec Record of the opportunity header to be updated. The
813: * record type passed in p_header_rec is defined in the package AS_OPPORTUNITY_PUB.
814: * @param p_check_access_flag Check whether the logged in user has privileges
815: * to update the opportunity.
832: * @rep:displayname Update Opportunity Header
833: */
834: PROCEDURE Update_Opp_Header
835: ( p_api_version_number IN NUMBER,
836: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
837: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
838: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
839: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
840: p_check_access_flag IN VARCHAR2,
833: */
834: PROCEDURE Update_Opp_Header
835: ( p_api_version_number IN NUMBER,
836: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
837: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
838: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
839: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
840: p_check_access_flag IN VARCHAR2,
841: p_admin_flag IN VARCHAR2,
834: PROCEDURE Update_Opp_Header
835: ( p_api_version_number IN NUMBER,
836: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
837: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
838: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
839: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
840: p_check_access_flag IN VARCHAR2,
841: p_admin_flag IN VARCHAR2,
842: p_admin_group_id IN NUMBER,
858: --
859:
860: PROCEDURE Delete_Opp_Header
861: ( p_api_version_number IN NUMBER,
862: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
863: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
864: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
865: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
866: p_check_access_flag IN VARCHAR2,
859:
860: PROCEDURE Delete_Opp_Header
861: ( p_api_version_number IN NUMBER,
862: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
863: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
864: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
865: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
866: p_check_access_flag IN VARCHAR2,
867: p_admin_flag IN VARCHAR2,
860: PROCEDURE Delete_Opp_Header
861: ( p_api_version_number IN NUMBER,
862: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
863: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
864: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
865: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
866: p_check_access_flag IN VARCHAR2,
867: p_admin_flag IN VARCHAR2,
868: p_admin_group_id IN NUMBER,
903: *
904: * @param p_api_version_number API version number.
905: * @param p_init_msg_list Intialize the message array.
906: * @param p_commit Commit after processing the transaction.
907: * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
908: * or FND_API.G_VALID_LEVEL_FULL).
909: * @param p_line_tbl A PL/SQL table of product lines to be created. This PL/SQL
910: * table is of record type AS_OPPORTUNITY_PUB.line_rec_type defined in the
911: * package AS_OPPORTUNITY_PUB.
904: * @param p_api_version_number API version number.
905: * @param p_init_msg_list Intialize the message array.
906: * @param p_commit Commit after processing the transaction.
907: * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
908: * or FND_API.G_VALID_LEVEL_FULL).
909: * @param p_line_tbl A PL/SQL table of product lines to be created. This PL/SQL
910: * table is of record type AS_OPPORTUNITY_PUB.line_rec_type defined in the
911: * package AS_OPPORTUNITY_PUB.
912: * @param p_header_rec Record of the opportunity header to which the purchase
936: * @rep:displayname Create Opportunity Lines
937: */
938: PROCEDURE Create_Opp_Lines
939: ( p_api_version_number IN NUMBER,
940: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
941: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
942: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
943: p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
944: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
937: */
938: PROCEDURE Create_Opp_Lines
939: ( p_api_version_number IN NUMBER,
940: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
941: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
942: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
943: p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
944: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
945: p_check_access_flag IN VARCHAR2,
938: PROCEDURE Create_Opp_Lines
939: ( p_api_version_number IN NUMBER,
940: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
941: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
942: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
943: p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
944: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
945: p_check_access_flag IN VARCHAR2,
946: p_admin_flag IN VARCHAR2,
985: *
986: * @param p_api_version_number API version number.
987: * @param p_init_msg_list Initialize the message array.
988: * @param p_commit Commit after processing the transaction.
989: * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
990: * or FND_API.G_VALID_LEVEL_FULL).
991: * @param p_identity_salesforce_id Sales force identifier of the logged in user
992: * @param p_line_tbl A PL/SQL table of product lines to be updated. This PL/SQL
993: * table is of record type AS_OPPORTUNITY_PUB.line_rec_type defined in the
986: * @param p_api_version_number API version number.
987: * @param p_init_msg_list Initialize the message array.
988: * @param p_commit Commit after processing the transaction.
989: * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
990: * or FND_API.G_VALID_LEVEL_FULL).
991: * @param p_identity_salesforce_id Sales force identifier of the logged in user
992: * @param p_line_tbl A PL/SQL table of product lines to be updated. This PL/SQL
993: * table is of record type AS_OPPORTUNITY_PUB.line_rec_type defined in the
994: * package AS_OPPORTUNITY_PUB.
1017: * @rep:displayname Update Opportunity Lines
1018: */
1019: PROCEDURE Update_Opp_Lines
1020: ( p_api_version_number IN NUMBER,
1021: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1022: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1023: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1024: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1025: p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1018: */
1019: PROCEDURE Update_Opp_Lines
1020: ( p_api_version_number IN NUMBER,
1021: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1022: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1023: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1024: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1025: p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1026: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1019: PROCEDURE Update_Opp_Lines
1020: ( p_api_version_number IN NUMBER,
1021: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1022: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1023: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1024: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1025: p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1026: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1027: p_check_access_flag IN VARCHAR2,
1046: --
1047:
1048: PROCEDURE Delete_Opp_Lines
1049: ( p_api_version_number IN NUMBER,
1050: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1051: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1052: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1053: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1054: p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1047:
1048: PROCEDURE Delete_Opp_Lines
1049: ( p_api_version_number IN NUMBER,
1050: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1051: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1052: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1053: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1054: p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1055: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1048: PROCEDURE Delete_Opp_Lines
1049: ( p_api_version_number IN NUMBER,
1050: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1051: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1052: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1053: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1054: p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1055: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1056: p_check_access_flag IN VARCHAR2,
1078:
1079:
1080: PROCEDURE Create_Sales_Credits
1081: ( p_api_version_number IN NUMBER,
1082: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1083: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1084: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1085: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1086: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1079:
1080: PROCEDURE Create_Sales_Credits
1081: ( p_api_version_number IN NUMBER,
1082: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1083: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1084: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1085: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1086: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1087: p_check_access_flag IN VARCHAR2,
1080: PROCEDURE Create_Sales_Credits
1081: ( p_api_version_number IN NUMBER,
1082: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1083: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1084: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1085: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1086: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1087: p_check_access_flag IN VARCHAR2,
1088: p_admin_flag IN VARCHAR2,
1108: --
1109:
1110: PROCEDURE Update_Sales_Credits
1111: ( p_api_version_number IN NUMBER,
1112: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1113: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1114: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1115: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1116: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1109:
1110: PROCEDURE Update_Sales_Credits
1111: ( p_api_version_number IN NUMBER,
1112: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1113: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1114: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1115: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1116: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1117: p_check_access_flag IN VARCHAR2,
1110: PROCEDURE Update_Sales_Credits
1111: ( p_api_version_number IN NUMBER,
1112: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1113: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1114: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1115: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1116: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1117: p_check_access_flag IN VARCHAR2,
1118: p_admin_flag IN VARCHAR2,
1143: --
1144:
1145: PROCEDURE Modify_Sales_Credits
1146: ( p_api_version_number IN NUMBER,
1147: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1148: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1149: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1150: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1151: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1144:
1145: PROCEDURE Modify_Sales_Credits
1146: ( p_api_version_number IN NUMBER,
1147: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1148: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1149: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1150: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1151: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1152: p_check_access_flag IN VARCHAR2,
1145: PROCEDURE Modify_Sales_Credits
1146: ( p_api_version_number IN NUMBER,
1147: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1148: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1149: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1150: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1151: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1152: p_check_access_flag IN VARCHAR2,
1153: p_admin_flag IN VARCHAR2,
1166: --
1167:
1168: PROCEDURE Delete_Sales_Credits
1169: ( p_api_version_number IN NUMBER,
1170: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1171: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1172: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1173: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1174: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_tbl_Type,
1167:
1168: PROCEDURE Delete_Sales_Credits
1169: ( p_api_version_number IN NUMBER,
1170: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1171: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1172: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1173: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1174: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_tbl_Type,
1175: p_check_access_flag IN VARCHAR2,
1168: PROCEDURE Delete_Sales_Credits
1169: ( p_api_version_number IN NUMBER,
1170: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1171: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1172: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1173: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1174: p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_tbl_Type,
1175: p_check_access_flag IN VARCHAR2,
1176: p_admin_flag IN VARCHAR2,
1192: --
1193:
1194: PROCEDURE Create_Obstacles
1195: ( p_api_version_number IN NUMBER,
1196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1199: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1200: p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1193:
1194: PROCEDURE Create_Obstacles
1195: ( p_api_version_number IN NUMBER,
1196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1199: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1200: p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1201: p_check_access_flag IN VARCHAR2,
1194: PROCEDURE Create_Obstacles
1195: ( p_api_version_number IN NUMBER,
1196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1199: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1200: p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1201: p_check_access_flag IN VARCHAR2,
1202: p_admin_flag IN VARCHAR2,
1219: --
1220:
1221: PROCEDURE Update_Obstacles
1222: ( p_api_version_number IN NUMBER,
1223: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1224: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1225: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1226: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1227: p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1220:
1221: PROCEDURE Update_Obstacles
1222: ( p_api_version_number IN NUMBER,
1223: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1224: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1225: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1226: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1227: p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1228: p_check_access_flag IN VARCHAR2,
1221: PROCEDURE Update_Obstacles
1222: ( p_api_version_number IN NUMBER,
1223: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1224: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1225: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1226: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1227: p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1228: p_check_access_flag IN VARCHAR2,
1229: p_admin_flag IN VARCHAR2,
1241: --
1242:
1243: PROCEDURE Delete_Obstacles
1244: ( p_api_version_number IN NUMBER,
1245: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1246: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1247: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1248: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1249: p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1242:
1243: PROCEDURE Delete_Obstacles
1244: ( p_api_version_number IN NUMBER,
1245: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1246: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1247: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1248: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1249: p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1250: p_check_access_flag IN VARCHAR2,
1243: PROCEDURE Delete_Obstacles
1244: ( p_api_version_number IN NUMBER,
1245: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1246: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1247: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1248: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1249: p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1250: p_check_access_flag IN VARCHAR2,
1251: p_admin_flag IN VARCHAR2,
1268: --
1269:
1270: PROCEDURE Update_Orders
1271: ( p_api_version_number IN NUMBER,
1272: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1273: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1274: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1275: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1276: p_lead_order_tbl IN AS_OPPORTUNITY_PUB.Order_tbl_Type,
1269:
1270: PROCEDURE Update_Orders
1271: ( p_api_version_number IN NUMBER,
1272: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1273: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1274: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1275: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1276: p_lead_order_tbl IN AS_OPPORTUNITY_PUB.Order_tbl_Type,
1277: p_check_access_flag IN VARCHAR2,
1270: PROCEDURE Update_Orders
1271: ( p_api_version_number IN NUMBER,
1272: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1273: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1274: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1275: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1276: p_lead_order_tbl IN AS_OPPORTUNITY_PUB.Order_tbl_Type,
1277: p_check_access_flag IN VARCHAR2,
1278: p_admin_flag IN VARCHAR2,
1290: --
1291:
1292: PROCEDURE Delete_Orders
1293: ( p_api_version_number IN NUMBER,
1294: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1295: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1296: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1297: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1298: p_lead_order_tbl IN AS_OPPORTUNITY_PUB.Order_tbl_Type,
1291:
1292: PROCEDURE Delete_Orders
1293: ( p_api_version_number IN NUMBER,
1294: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1295: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1296: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1297: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1298: p_lead_order_tbl IN AS_OPPORTUNITY_PUB.Order_tbl_Type,
1299: p_check_access_flag IN VARCHAR2,
1292: PROCEDURE Delete_Orders
1293: ( p_api_version_number IN NUMBER,
1294: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1295: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1296: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1297: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1298: p_lead_order_tbl IN AS_OPPORTUNITY_PUB.Order_tbl_Type,
1299: p_check_access_flag IN VARCHAR2,
1300: p_admin_flag IN VARCHAR2,
1316: --
1317:
1318: PROCEDURE Create_Competitors
1319: ( p_api_version_number IN NUMBER,
1320: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1321: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1322: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1323: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1324: p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1317:
1318: PROCEDURE Create_Competitors
1319: ( p_api_version_number IN NUMBER,
1320: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1321: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1322: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1323: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1324: p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1325: p_check_access_flag IN VARCHAR2,
1318: PROCEDURE Create_Competitors
1319: ( p_api_version_number IN NUMBER,
1320: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1321: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1322: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1323: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1324: p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1325: p_check_access_flag IN VARCHAR2,
1326: p_admin_flag IN VARCHAR2,
1343: --
1344:
1345: PROCEDURE Update_Competitors
1346: ( p_api_version_number IN NUMBER,
1347: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1348: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1349: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1350: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1351: p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1344:
1345: PROCEDURE Update_Competitors
1346: ( p_api_version_number IN NUMBER,
1347: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1348: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1349: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1350: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1351: p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1352: p_check_access_flag IN VARCHAR2,
1345: PROCEDURE Update_Competitors
1346: ( p_api_version_number IN NUMBER,
1347: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1348: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1349: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1350: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1351: p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1352: p_check_access_flag IN VARCHAR2,
1353: p_admin_flag IN VARCHAR2,
1362:
1363:
1364: PROCEDURE Delete_Competitors
1365: ( p_api_version_number IN NUMBER,
1366: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1367: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1368: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1369: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1370: p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1363:
1364: PROCEDURE Delete_Competitors
1365: ( p_api_version_number IN NUMBER,
1366: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1367: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1368: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1369: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1370: p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1371: p_check_access_flag IN VARCHAR2,
1364: PROCEDURE Delete_Competitors
1365: ( p_api_version_number IN NUMBER,
1366: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1367: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1368: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1369: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1370: p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1371: p_check_access_flag IN VARCHAR2,
1372: p_admin_flag IN VARCHAR2,
1389: -- Lead_Competitor_Id
1390:
1391: PROCEDURE Create_Competitor_Prods
1392: ( p_api_version_number IN NUMBER,
1393: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1394: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1395: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1396: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1397: p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1390:
1391: PROCEDURE Create_Competitor_Prods
1392: ( p_api_version_number IN NUMBER,
1393: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1394: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1395: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1396: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1397: p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1398: p_check_access_flag IN VARCHAR2,
1391: PROCEDURE Create_Competitor_Prods
1392: ( p_api_version_number IN NUMBER,
1393: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1394: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1395: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1396: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1397: p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1398: p_check_access_flag IN VARCHAR2,
1399: p_admin_flag IN VARCHAR2,
1417: --
1418:
1419: PROCEDURE Update_Competitor_Prods
1420: ( p_api_version_number IN NUMBER,
1421: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1422: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1423: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1424: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1425: p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1418:
1419: PROCEDURE Update_Competitor_Prods
1420: ( p_api_version_number IN NUMBER,
1421: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1422: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1423: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1424: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1425: p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1426: p_check_access_flag IN VARCHAR2,
1419: PROCEDURE Update_Competitor_Prods
1420: ( p_api_version_number IN NUMBER,
1421: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1422: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1423: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1424: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1425: p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1426: p_check_access_flag IN VARCHAR2,
1427: p_admin_flag IN VARCHAR2,
1436:
1437:
1438: PROCEDURE Delete_Competitor_Prods
1439: ( p_api_version_number IN NUMBER,
1440: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1441: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1442: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1443: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1444: p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1437:
1438: PROCEDURE Delete_Competitor_Prods
1439: ( p_api_version_number IN NUMBER,
1440: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1441: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1442: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1443: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1444: p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1445: p_check_access_flag IN VARCHAR2,
1438: PROCEDURE Delete_Competitor_Prods
1439: ( p_api_version_number IN NUMBER,
1440: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1441: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1442: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1443: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1444: p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1445: p_check_access_flag IN VARCHAR2,
1446: p_admin_flag IN VARCHAR2,
1463: --
1464:
1465: PROCEDURE Create_Decision_Factors
1466: ( p_api_version_number IN NUMBER,
1467: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1468: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1469: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1470: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1471: p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1464:
1465: PROCEDURE Create_Decision_Factors
1466: ( p_api_version_number IN NUMBER,
1467: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1468: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1469: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1470: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1471: p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1472: p_check_access_flag IN VARCHAR2,
1465: PROCEDURE Create_Decision_Factors
1466: ( p_api_version_number IN NUMBER,
1467: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1468: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1469: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1470: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1471: p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1472: p_check_access_flag IN VARCHAR2,
1473: p_admin_flag IN VARCHAR2,
1491: --
1492:
1493: PROCEDURE Update_Decision_Factors
1494: ( p_api_version_number IN NUMBER,
1495: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1496: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1497: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1498: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1499: p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1492:
1493: PROCEDURE Update_Decision_Factors
1494: ( p_api_version_number IN NUMBER,
1495: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1496: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1497: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1498: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1499: p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1500: p_check_access_flag IN VARCHAR2,
1493: PROCEDURE Update_Decision_Factors
1494: ( p_api_version_number IN NUMBER,
1495: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1496: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1497: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1498: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1499: p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1500: p_check_access_flag IN VARCHAR2,
1501: p_admin_flag IN VARCHAR2,
1510:
1511:
1512: PROCEDURE Delete_Decision_Factors
1513: ( p_api_version_number IN NUMBER,
1514: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1515: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1516: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1517: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1518: p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1511:
1512: PROCEDURE Delete_Decision_Factors
1513: ( p_api_version_number IN NUMBER,
1514: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1515: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1516: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1517: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1518: p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1519: p_check_access_flag IN VARCHAR2,
1512: PROCEDURE Delete_Decision_Factors
1513: ( p_api_version_number IN NUMBER,
1514: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1515: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1516: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1517: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1518: p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1519: p_check_access_flag IN VARCHAR2,
1520: p_admin_flag IN VARCHAR2,
1540: --
1541:
1542: PROCEDURE Create_Contacts
1543: ( p_api_version_number IN NUMBER,
1544: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1545: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1546: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1547: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1548: p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1541:
1542: PROCEDURE Create_Contacts
1543: ( p_api_version_number IN NUMBER,
1544: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1545: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1546: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1547: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1548: p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1549: p_header_rec IN HEADER_REC_TYPE DEFAULT G_MISS_HEADER_REC,
1542: PROCEDURE Create_Contacts
1543: ( p_api_version_number IN NUMBER,
1544: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1545: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1546: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1547: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1548: p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1549: p_header_rec IN HEADER_REC_TYPE DEFAULT G_MISS_HEADER_REC,
1550: p_check_access_flag IN VARCHAR2,
1571: --
1572:
1573: PROCEDURE Update_Contacts
1574: ( p_api_version_number IN NUMBER,
1575: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1576: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1577: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1578: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1579: p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1572:
1573: PROCEDURE Update_Contacts
1574: ( p_api_version_number IN NUMBER,
1575: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1576: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1577: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1578: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1579: p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1580: p_check_access_flag IN VARCHAR2,
1573: PROCEDURE Update_Contacts
1574: ( p_api_version_number IN NUMBER,
1575: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1576: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1577: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1578: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1579: p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1580: p_check_access_flag IN VARCHAR2,
1581: p_admin_flag IN VARCHAR2,
1593: --
1594:
1595: PROCEDURE Delete_Contacts
1596: ( p_api_version_number IN NUMBER,
1597: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1598: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1599: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1600: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1601: p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1594:
1595: PROCEDURE Delete_Contacts
1596: ( p_api_version_number IN NUMBER,
1597: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1598: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1599: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1600: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1601: p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1602: p_check_access_flag IN VARCHAR2,
1595: PROCEDURE Delete_Contacts
1596: ( p_api_version_number IN NUMBER,
1597: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1598: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1599: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1600: p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1601: p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1602: p_check_access_flag IN VARCHAR2,
1603: p_admin_flag IN VARCHAR2,
1616: --
1617:
1618: PROCEDURE Delete_SalesTeams
1619: ( p_api_version_number IN NUMBER,
1620: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1621: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1622: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1623: p_sales_team_tbl IN AS_ACCESS_PUB.SALES_TEAM_TBL_TYPE,
1624: p_check_access_flag IN VARCHAR2,
1617:
1618: PROCEDURE Delete_SalesTeams
1619: ( p_api_version_number IN NUMBER,
1620: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1621: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1622: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1623: p_sales_team_tbl IN AS_ACCESS_PUB.SALES_TEAM_TBL_TYPE,
1624: p_check_access_flag IN VARCHAR2,
1625: p_admin_flag IN VARCHAR2,
1618: PROCEDURE Delete_SalesTeams
1619: ( p_api_version_number IN NUMBER,
1620: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1621: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1622: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1623: p_sales_team_tbl IN AS_ACCESS_PUB.SALES_TEAM_TBL_TYPE,
1624: p_check_access_flag IN VARCHAR2,
1625: p_admin_flag IN VARCHAR2,
1626: p_admin_group_id IN NUMBER,
1642: -- Function: To copy an existing opportunity header with/without
1643: -- the salesteam, opportunity lines, sales_credits, contacts
1644: -- and competitors
1645: --
1646: -- Note: 1. If the p_sales_credits = FND_API.G_TRUE then
1647: -- the p_opp_lines must be FND_API.G_TRUE.
1648: -- 2. If the p_copy_salesteam is FALSE the salesteam
1649: -- will be defaulted as in creating a new opportunity.
1650: -- 3. If the p_copy_sales_credit is FALSE then the
1643: -- the salesteam, opportunity lines, sales_credits, contacts
1644: -- and competitors
1645: --
1646: -- Note: 1. If the p_sales_credits = FND_API.G_TRUE then
1647: -- the p_opp_lines must be FND_API.G_TRUE.
1648: -- 2. If the p_copy_salesteam is FALSE the salesteam
1649: -- will be defaulted as in creating a new opportunity.
1650: -- 3. If the p_copy_sales_credit is FALSE then the
1651: -- the sales credits will be defaulted 100% to the
1668: -- End of Comments
1669:
1670: PROCEDURE Copy_Opportunity
1671: ( p_api_version_number IN NUMBER,
1672: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1673: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1674: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1675: p_lead_id IN NUMBER,
1676: p_description IN VARCHAR2,
1669:
1670: PROCEDURE Copy_Opportunity
1671: ( p_api_version_number IN NUMBER,
1672: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1673: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1674: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1675: p_lead_id IN NUMBER,
1676: p_description IN VARCHAR2,
1677: p_copy_salesteam IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1670: PROCEDURE Copy_Opportunity
1671: ( p_api_version_number IN NUMBER,
1672: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1673: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1674: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1675: p_lead_id IN NUMBER,
1676: p_description IN VARCHAR2,
1677: p_copy_salesteam IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1678: p_copy_opp_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1673: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1674: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1675: p_lead_id IN NUMBER,
1676: p_description IN VARCHAR2,
1677: p_copy_salesteam IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1678: p_copy_opp_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1679: p_copy_lead_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1680: p_copy_lead_competitors IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1681: p_copy_sales_credits IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1674: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1675: p_lead_id IN NUMBER,
1676: p_description IN VARCHAR2,
1677: p_copy_salesteam IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1678: p_copy_opp_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1679: p_copy_lead_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1680: p_copy_lead_competitors IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1681: p_copy_sales_credits IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1682: p_copy_methodology IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1675: p_lead_id IN NUMBER,
1676: p_description IN VARCHAR2,
1677: p_copy_salesteam IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1678: p_copy_opp_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1679: p_copy_lead_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1680: p_copy_lead_competitors IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1681: p_copy_sales_credits IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1682: p_copy_methodology IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1683: p_new_customer_id IN NUMBER,
1676: p_description IN VARCHAR2,
1677: p_copy_salesteam IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1678: p_copy_opp_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1679: p_copy_lead_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1680: p_copy_lead_competitors IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1681: p_copy_sales_credits IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1682: p_copy_methodology IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1683: p_new_customer_id IN NUMBER,
1684: p_new_address_id IN NUMBER,
1677: p_copy_salesteam IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1678: p_copy_opp_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1679: p_copy_lead_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1680: p_copy_lead_competitors IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1681: p_copy_sales_credits IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1682: p_copy_methodology IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1683: p_new_customer_id IN NUMBER,
1684: p_new_address_id IN NUMBER,
1685: p_check_access_flag IN VARCHAR2,
1678: p_copy_opp_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1679: p_copy_lead_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1680: p_copy_lead_competitors IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1681: p_copy_sales_credits IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1682: p_copy_methodology IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1683: p_new_customer_id IN NUMBER,
1684: p_new_address_id IN NUMBER,
1685: p_check_access_flag IN VARCHAR2,
1686: p_admin_flag IN VARCHAR2,
1719: -- This function get profile value from profile table type
1720: -- and return the value for the input profile name.
1721: --
1722: -- If profile name is not found in profile table or
1723: -- profile value is NULL or FND_API.G_MISS_CHAR
1724: -- then the function return NULL
1725: --
1726:
1727: FUNCTION Get_Profile(