DBA Data[Home] [Help]

APPS.CN_SF_PARAMS_PKG dependencies on CN_SF_REPOSITORIES_S

Line 82: cn_sf_repositories_s.nextval,

78: LAST_UPDATED_BY,
79: object_version_number
80: )
81: SELECT
82: cn_sf_repositories_s.nextval,
83: P_CONTRACT_TITLE,
84: P_TERMS_AND_CONDITIONS,
85: P_CLUB_QUAL_TEXT,
86: P_APPROVER_NAME ,

Line 199: --update cn_sf_repositories set contract_title = ( select 'wormsss4' from dual ) where repository_id = 10061 ;

195: --DBMS_OUTPUT.PUT_LINE(' Table Handlers update : Started. ID : ');
196: --DBMS_OUTPUT.PUT_LINE('Old Num : ' || l_num || ' ID in procedure : ' || p_repository_id);
197: --DBMS_OUTPUT.PUT_LINE('Parameter version ' || p_object_version_number) ;
198: --DBMS_OUTPUT.PUT_LINE('version Number :' || l_object_version_number || ': OVN :' || l_old_rec.object_version_number) ;
199: --update cn_sf_repositories set contract_title = ( select 'wormsss4' from dual ) where repository_id = 10061 ;
200:
201: UPDATE cn_sf_repositories SET (
202: CONTRACT_TITLE,
203: TERMS_AND_CONDITIONS,

Line 201: UPDATE cn_sf_repositories SET (

197: --DBMS_OUTPUT.PUT_LINE('Parameter version ' || p_object_version_number) ;
198: --DBMS_OUTPUT.PUT_LINE('version Number :' || l_object_version_number || ': OVN :' || l_old_rec.object_version_number) ;
199: --update cn_sf_repositories set contract_title = ( select 'wormsss4' from dual ) where repository_id = 10061 ;
200:
201: UPDATE cn_sf_repositories SET (
202: CONTRACT_TITLE,
203: TERMS_AND_CONDITIONS,
204: CLUB_QUAL_TEXT,
205: APPROVER_NAME,