[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_person_id IN NUMBER,
x_enquiry_appl_number OUT NOCOPY NUMBER,
x_sales_lead_id OUT NOCOPY NUMBER,
x_acad_cal_type IN VARCHAR2,
x_acad_ci_sequence_number IN NUMBER,
x_adm_cal_type IN VARCHAR2,
x_adm_ci_sequence_number IN NUMBER,
x_enquiry_dt IN DATE,
x_registering_person_id IN NUMBER,
x_override_process_ind IN VARCHAR2,
x_indicated_mailing_dt IN DATE,
x_last_process_dt IN DATE,
x_comments IN VARCHAR2,
x_org_id IN NUMBER,
x_inq_entry_level_id IN NUMBER,
x_edu_goal_id IN NUMBER,
x_party_id IN NUMBER,
x_how_knowus_id IN NUMBER,
x_who_influenced_id IN NUMBER,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2,
x_s_enquiry_status IN VARCHAR2,
x_enabled_flag IN VARCHAR2,
x_inquiry_method_code IN VARCHAR2,
x_mode IN VARCHAR2 ,
x_action IN VARCHAR2,
x_person_type_code IN VARCHAR2,
x_funnel_status IN VARCHAR2,
x_source_promotion_id IN VARCHAR2,
x_ret_status OUT NOCOPY VARCHAR2,
x_msg_data OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_pkg_reduct_ind IN VARCHAR2 DEFAULT NULL
) AS
/*
|| Created By : hreddych
|| Created On : 22-JAN-2003
|| Purpose : Handles the INSERT DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_program_update_date DATE;
SELECT party_site_id
FROM hz_party_sites
WHERE identifying_address_flag = 'Y'
AND status = 'A'
AND party_id = x_person_id;
IGR_I_APPL_Pkg.insert_row (
X_Mode => 'R',
X_RowId =>X_RowId ,
X_Person_Id =>X_Person_Id ,
X_sales_lead_id =>l_sales_lead_id ,
X_Enquiry_Appl_Number =>X_Enquiry_Appl_Number ,
X_Acad_Cal_Type =>X_Acad_Cal_Type ,
X_Acad_Ci_Sequence_Number =>X_Acad_Ci_Sequence_Number ,
X_Adm_Cal_Type =>X_Adm_Cal_Type ,
X_Adm_Ci_Sequence_Number =>X_Adm_Ci_Sequence_Number ,
X_Enquiry_Dt =>X_Enquiry_Dt ,
X_Registering_Person_Id =>X_Registering_Person_Id ,
X_Override_Process_Ind =>X_Override_Process_Ind ,
X_Indicated_Mailing_Dt =>X_Indicated_Mailing_Dt ,
X_Last_Process_Dt =>X_Last_Process_Dt ,
X_Comments =>X_Comments ,
X_INQ_ENTRY_LEVEL_ID =>X_INQ_ENTRY_LEVEL_ID ,
X_EDU_GOAL_ID =>X_EDU_GOAL_ID ,
X_PARTY_ID =>X_PARTY_ID ,
X_HOW_KNOWUS_ID =>X_HOW_KNOWUS_ID ,
X_WHO_INFLUENCED_ID =>X_WHO_INFLUENCED_ID ,
X_ATTRIBUTE_CATEGORY =>X_ATTRIBUTE_CATEGORY ,
X_ATTRIBUTE1 =>X_ATTRIBUTE1 ,
X_ATTRIBUTE2 =>X_ATTRIBUTE2 ,
X_ATTRIBUTE3 =>X_ATTRIBUTE3 ,
X_ATTRIBUTE4 =>X_ATTRIBUTE4 ,
X_ATTRIBUTE5 =>X_ATTRIBUTE5 ,
X_ATTRIBUTE6 =>X_ATTRIBUTE6 ,
X_ATTRIBUTE7 =>X_ATTRIBUTE7 ,
X_ATTRIBUTE8 =>X_ATTRIBUTE8 ,
X_ATTRIBUTE9 =>X_ATTRIBUTE9 ,
X_ATTRIBUTE10 =>X_ATTRIBUTE10 ,
X_ATTRIBUTE11 =>X_ATTRIBUTE11 ,
X_ATTRIBUTE12 =>X_ATTRIBUTE12 ,
X_ATTRIBUTE13 =>X_ATTRIBUTE13 ,
X_ATTRIBUTE14 =>X_ATTRIBUTE14 ,
X_ATTRIBUTE15 =>X_ATTRIBUTE15 ,
X_ATTRIBUTE16 =>X_ATTRIBUTE16 ,
X_ATTRIBUTE17 =>X_ATTRIBUTE17 ,
X_ATTRIBUTE18 =>X_ATTRIBUTE18 ,
X_ATTRIBUTE19 =>X_ATTRIBUTE19 ,
X_ATTRIBUTE20 =>X_ATTRIBUTE20 ,
X_Org_Id =>X_Org_Id ,
X_PKG_REDUCT_IND =>x_pkg_reduct_ind
);
igr_person_type_pkg.update_persontype_funnel(
p_person_id => x_person_id,
p_person_type_code => x_person_type_code,
p_funnel_status => x_funnel_status,
p_return_status => x_ret_status,
p_message_text => x_msg_data) ;
END insert_row;
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_person_id IN NUMBER,
x_enquiry_appl_number IN NUMBER,
x_sales_lead_id IN NUMBER,
x_acad_cal_type IN VARCHAR2,
x_acad_ci_sequence_number IN NUMBER,
x_adm_cal_type IN VARCHAR2,
x_adm_ci_sequence_number IN NUMBER,
x_enquiry_dt IN DATE,
x_registering_person_id IN NUMBER,
x_override_process_ind IN VARCHAR2,
x_indicated_mailing_dt IN DATE,
x_last_process_dt IN DATE,
x_comments IN VARCHAR2,
x_org_id IN NUMBER,
x_inq_entry_level_id IN NUMBER,
x_edu_goal_id IN NUMBER,
x_party_id IN NUMBER,
x_how_knowus_id IN NUMBER,
x_who_influenced_id IN NUMBER,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2,
x_s_enquiry_status IN VARCHAR2,
x_enabled_flag IN VARCHAR2,
x_inquiry_method_code IN VARCHAR2,
x_mode IN VARCHAR2,
x_action IN VARCHAR2,
x_source_promotion_id IN VARCHAR2,
x_ret_status OUT NOCOPY VARCHAR2,
x_msg_data OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_pkg_reduct_ind IN VARCHAR2 DEFAULT NULL
) AS
/*
|| Created By : hreddych
|| Created On : 22-JAN-2003
|| Purpose : Handles the UPDATE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
x_last_update_date DATE ;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_program_update_date DATE;
CURSOR cur_last_update_date IS
SELECT last_update_date
FROM as_sales_leads
WHERE sales_lead_id = x_sales_lead_id;
SELECT assign_to_person_id, assign_to_salesforce_id
FROM as_sales_leads
WHERE sales_lead_id = x_sales_lead_id;
OPEN cur_last_update_date ;
FETCH cur_last_update_date INTO l_sales_lead_rec.last_update_date ;
CLOSE cur_last_update_date;
as_sales_leads_pub.update_sales_lead(
P_Api_Version_Number => 2.0 ,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
P_Validation_Level => AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
P_Check_Access_Flag => FND_API.G_MISS_CHAR,
P_Admin_Flag => 'Y',
P_Admin_Group_Id => FND_API.G_MISS_NUM,
P_identity_salesforce_id => FND_API.G_MISS_NUM,
P_Sales_Lead_Profile_Tbl => ddp_sales_lead_profile_tbl,
P_SALES_LEAD_Rec => l_sales_lead_rec,
X_Return_Status => x_ret_status ,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
igr_i_appl_pkg.update_row (
X_ROWID => X_ROWID ,
X_PERSON_ID => X_PERSON_ID ,
X_SALES_LEAD_ID => X_SALES_LEAD_ID ,
X_ENQUIRY_APPL_NUMBER => X_ENQUIRY_APPL_NUMBER ,
X_ACAD_CAL_TYPE => X_ACAD_CAL_TYPE ,
X_ACAD_CI_SEQUENCE_NUMBER => X_ACAD_CI_SEQUENCE_NUMBER ,
X_ADM_CAL_TYPE => X_ADM_CAL_TYPE ,
X_ADM_CI_SEQUENCE_NUMBER => X_ADM_CI_SEQUENCE_NUMBER ,
X_ENQUIRY_DT => X_ENQUIRY_DT ,
X_REGISTERING_PERSON_ID => X_REGISTERING_PERSON_ID ,
X_OVERRIDE_PROCESS_IND => X_OVERRIDE_PROCESS_IND ,
X_INDICATED_MAILING_DT => X_INDICATED_MAILING_DT ,
X_LAST_PROCESS_DT => X_LAST_PROCESS_DT ,
X_COMMENTS => X_COMMENTS ,
X_INQ_ENTRY_LEVEL_ID => X_INQ_ENTRY_LEVEL_ID ,
X_EDU_GOAL_ID => X_EDU_GOAL_ID ,
X_PARTY_ID => X_PARTY_ID ,
X_HOW_KNOWUS_ID => X_HOW_KNOWUS_ID ,
X_WHO_INFLUENCED_ID => X_WHO_INFLUENCED_ID ,
X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY ,
X_ATTRIBUTE1 => X_ATTRIBUTE1 ,
X_ATTRIBUTE2 => X_ATTRIBUTE2 ,
X_ATTRIBUTE3 => X_ATTRIBUTE3 ,
X_ATTRIBUTE4 => X_ATTRIBUTE4 ,
X_ATTRIBUTE5 => X_ATTRIBUTE5 ,
X_ATTRIBUTE6 => X_ATTRIBUTE6 ,
X_ATTRIBUTE7 => X_ATTRIBUTE7 ,
X_ATTRIBUTE8 => X_ATTRIBUTE8 ,
X_ATTRIBUTE9 => X_ATTRIBUTE9 ,
X_ATTRIBUTE10 => X_ATTRIBUTE10 ,
X_ATTRIBUTE11 => X_ATTRIBUTE11 ,
X_ATTRIBUTE12 => X_ATTRIBUTE12 ,
X_ATTRIBUTE13 => X_ATTRIBUTE13 ,
X_ATTRIBUTE14 => X_ATTRIBUTE14 ,
X_ATTRIBUTE15 => X_ATTRIBUTE15 ,
X_ATTRIBUTE16 => X_ATTRIBUTE16 ,
X_ATTRIBUTE17 => X_ATTRIBUTE17 ,
X_ATTRIBUTE18 => X_ATTRIBUTE18 ,
X_ATTRIBUTE19 => X_ATTRIBUTE19 ,
X_ATTRIBUTE20 => X_ATTRIBUTE20 ,
X_MODE => 'R' ,
X_PKG_REDUCT_IND => x_pkg_reduct_ind
);
AS_SALES_LEADS_PUB.Lead_Process_After_Update (
P_Api_Version_Number => 2.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
P_Validation_Level => AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
P_Check_Access_Flag => FND_API.G_MISS_CHAR,
P_Admin_Flag => FND_API.G_MISS_CHAR,
P_Admin_Group_Id => FND_API.G_MISS_NUM,
P_identity_salesforce_id => FND_API.G_MISS_NUM,
P_Salesgroup_id => FND_API.G_MISS_NUM,
P_Sales_Lead_Id => x_sales_lead_id,
X_Return_Status => l_lead_proc_ret_status,
X_Msg_Count => l_lead_proc_msg_count,
X_Msg_Data => l_lead_proc_msg_data
);
fnd_file.put_line(fnd_file.log, 'AS_SALES_LEADS_PUB.Lead_Process_After_Update failed.');
END update_row;