[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select display_style, attribute_type, character_width, decimal_points
into l_display_style, l_attribute_type, l_char_width, l_dec_pts
from pv_attributes_vl
where attribute_id = l_attribute_id;
select fnd_profile.value('ICX_DATE_FORMAT_MASK') into l_date_format from dual;
select attr_code
from pv_attribute_codes_vl
where attribute_id = attr_id;
l_errors_tbl.delete;
select
'Y',
hz_parties.party_id
from
hz_orig_sys_references,
hz_parties
where
hz_orig_sys_references.owner_table_id = hz_parties.party_id and
hz_parties.party_type = 'ORGANIZATION' AND
hz_orig_sys_references.orig_system = cv_orig_system and
hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and
hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
hz_parties.status = 'A';
select
'Y'
FROM
hz_parties
where
party_id = cv_party_id and
orig_system_reference = cv_osr and
party_type = 'ORGANIZATION' and
status = 'A';
select
'Y'
FROM
hz_parties
where
party_id = cv_party_id and
party_type = 'ORGANIZATION' and
status = 'A';
select
'Y'
FROM
hz_parties
where
party_id = cv_party_id and
party_type = 'ORGANIZATION' and
status = 'A';
select
'Y'
from
hz_orig_sys_references,
hz_parties
where
hz_parties.party_id = cv_party_id and
hz_orig_sys_references.owner_table_id = hz_parties.party_id and
hz_parties.party_type = 'ORGANIZATION' AND
hz_orig_sys_references.orig_system = cv_os and
hz_orig_sys_references.orig_system_reference = cv_osr and
hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
hz_parties.status = 'A';
select
'Y'
from
pv_partner_profiles
where
partner_id = cv_partner_id and
partner_party_id = cv_party_id;
select
'Y',
hz_parties.party_id
from
pv_partner_profiles,
hz_parties
where
partner_id = cv_partner_id and
-- pv_partner_profiles.status = 'A' and
party_id = partner_party_id and
hz_parties.status = 'A' and
hz_parties.party_type = 'ORGANIZATION';
SELECT
hz_parties.party_id
from
hz_orig_sys_references,
hz_parties
where
hz_orig_sys_references.owner_table_id = hz_parties.party_id and
hz_parties.party_type = 'ORGANIZATION' AND
hz_orig_sys_references.orig_system = cv_orig_system and
hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and
hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
hz_parties.status = 'A';
SELECT
partner_id
FROM
pv_partner_profiles
WHERE
partner_party_id = cv_party_id;
SELECT
attr_value
from
pv_enty_attr_values
where
attribute_id = 6 and
latest_flag = 'Y' and
entity_id = cv_partner_id;
SELECT
'Y'
from
hz_cust_accounts
where
party_id = cv_party_id and
status = 'A';
SELECT
party_type, party_name
FROM
hz_parties
WHERE
party_id = l_party_id;
SELECT 1000 from dual;
Procedure Validate_Update_Attributes(
p_partner_details_rec IN partner_details_rec_type,
p_partner_id IN NUMBER,
x_exit_partner OUT NOCOPY varchar2
)
IS
CURSOR l_get_partner_type(cv_partner_id IN NUMBER) IS
select
attr_value
from
pv_enty_attr_values
where
entity_id = cv_partner_id and
attribute_id = 3 and
latest_flag = 'Y';
END Validate_Update_Attributes;
SELECT
partner_profile_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,object_version_number
,partner_id
,target_revenue_amt
,actual_revenue_amt
,target_revenue_pct
,actual_revenue_pct
,orig_system_reference
,orig_system_type
,capacity_size
,capacity_amount
,auto_match_allowed_flag
,purchase_method
,cm_id
,ph_support_rep
--,security_group_id
,lead_sharing_status
,lead_share_appr_flag
,partner_relationship_id
,partner_level
,preferred_vad_id
,partner_group_id
,partner_resource_id
,partner_group_number
,partner_resource_number
,sales_partner_flag
,indirectly_managed_flag
,channel_marketing_manager
,related_partner_id
,max_users
,partner_party_id
,status
FROM PV_PARTNER_PROFILES
WHERE partner_profile_id = p_prtnr_prfls_rec.partner_profile_id;
l_update_channel_team VARCHAR2(1);
l_update_history VARCHAR2(1);
SELECT
max(version)
FROM
pv_enty_attr_values
WHERE
attribute_id = cv_attr_id and
entity_id = cv_entity_id;
select
attr_code
from
pv_partner_profiles val,
pv_attribute_codes_b cod
where
cod.attr_code_id = val.partner_level and
val.partner_id = cv_partner_id;
select
attr_code_id
from
pv_attribute_codes_b
where
attr_code = cv_partner_level_cd;
select
partner_profile_id
from
pv_partner_profiles
where
partner_id = cv_partner_id;
select
attr_value
from
pv_enty_attr_values
where
entity_id = cv_partner_id and
attribute_id = 3 and
latest_flag = 'Y';
l_update_channel_team := 'Y';
l_update_history := 'Y';
l_update_channel_team := 'N';
PVX_PRTNR_PRFLS_PVT.Update_Prtnr_Prfls(
p_api_version => 1.0
,p_init_msg_list => FND_API.g_true
,p_commit => FND_API.g_false
,p_validation_level => FND_API.g_valid_level_full
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_prtnr_prfls_rec => l_complete_prtnr_prfls_rec);
l_update_channel_team := 'Y';
if l_update_channel_team = 'Y' then
PV_TERR_ASSIGN_PUB.Update_Channel_Team
(
p_api_version_number => 1.0,
p_init_msg_list => FND_API.g_true,
p_commit => FND_API.g_false,
p_validation_level => FND_API.g_valid_level_full,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_partner_id => p_entity_id,
p_vad_partner_id => Null,
p_mode => 'UPDATE',
p_login_user => Null,
p_upd_prtnr_qflr_flg_rec => l_prtnr_qflr_flg_rec,
x_prtnr_access_id_tbl => l_prtnr_access_id_tbl
);
IF l_update_history = 'Y' then
--dbms_output.put_line('udpating history ');
,p_update_if_exists IN varchar2
,p_data_block_size IN number
,x_file_name OUT NOCOPY varchar2
,x_partner_output_tbl OUT NOCOPY partner_output_tbl_type) IS
-- Get the value of Profile PV_IMPORT_COMMIT_SIZE.
CURSOR l_get_commit_size_csr(cv_profile_name IN VARCHAR2) IS
SELECT nvl(fnd_profile.value(cv_profile_name),0) from dual;
SELECT
HZ_PARTIES.PARTY_ID
FROM
HZ_ORIG_SYS_REFERENCES,
HZ_PARTIES
WHERE
HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
HZ_PARTIES.PARTY_TYPE = 'ORGANIZATION' AND
HZ_ORIG_SYS_REFERENCES.orig_system = cv_orig_system AND
HZ_ORIG_SYS_REFERENCES.orig_system_reference = cv_orig_system_ref AND
HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
HZ_PARTIES.STATUS = 'A';
SELECT
partner_id
FROM
pv_partner_profiles
WHERE
partner_party_id = cv_party_id;
select
trim(substr(value,0,(instr(value,',') - 1))),
trim(substr(value,(instr(value,',') + 1)))
from v$parameter where name = 'utl_file_dir';
l_update_if_exists VARCHAR2(1);
select to_char(systimestamp,'yyddmmsssss') || '.log' into l_file_name from dual;
l_mode := 'UPDATE';
if p_partner_details_tbl(partner_ident).Update_If_Exists is null then
l_update_if_exists := p_partner_details_tbl(partner_ident).Update_If_Exists;
l_update_if_exists := p_update_if_exists;
if NOT (l_update_if_exists = 'Y') then
fnd_message.set_name('PV', 'PV_IMP_PTNR_EXISTS');
Validate_Update_Attributes(
p_partner_details_rec => p_partner_details_tbl(partner_ident),
p_partner_id => l_partner_id,
x_exit_partner => l_exit_partner);
l_status := 'UPDATED';