APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_TRXN_EXTENSIBILITY

Line 189: INSERT INTO iby_trxn_extensibility

185: END IF;
186:
187:
188: FOR i IN p_extend_names.FIRST..p_extend_names.LAST LOOP
189: INSERT INTO iby_trxn_extensibility
190: (trxn_extend_id,trxnmid,extend_name,extend_value,created_by,
191: creation_date,last_updated_by,last_update_date,last_update_login,
192: object_version_number)
193: VALUES

Line 194: (iby_trxn_extensibility_s.NEXTVAL,

190: (trxn_extend_id,trxnmid,extend_name,extend_value,created_by,
191: creation_date,last_updated_by,last_update_date,last_update_login,
192: object_version_number)
193: VALUES
194: (iby_trxn_extensibility_s.NEXTVAL,
195: p_trxnmid,p_extend_names(i),p_extend_vals(i),
196: fnd_global.user_id,sysdate,fnd_global.user_id,sysdate,
197: fnd_global.login_id,1);
198: END LOOP;

Line 670: FROM IBY_TRXN_EXTENSIBILITY OLD_EXT,

666: ci_trxnmid_new iby_trxn_summaries_all.trxnmid%TYPE)
667: IS
668: SELECT old_ext.extend_name extend_name,
669: nvl(new_ext.EXTEND_VALUE, old_ext.extend_value) extend_value
670: FROM IBY_TRXN_EXTENSIBILITY OLD_EXT,
671: IBY_TRXN_EXTENSIBILITY NEW_EXT
672: WHERE OLD_EXT.TRXNMID=ci_trxnmid_old
673: AND NEW_EXT.TRXNMID(+)=ci_trxnmid_new
674: and old_ext.extend_name=new_ext.extend_name(+);

Line 671: IBY_TRXN_EXTENSIBILITY NEW_EXT

667: IS
668: SELECT old_ext.extend_name extend_name,
669: nvl(new_ext.EXTEND_VALUE, old_ext.extend_value) extend_value
670: FROM IBY_TRXN_EXTENSIBILITY OLD_EXT,
671: IBY_TRXN_EXTENSIBILITY NEW_EXT
672: WHERE OLD_EXT.TRXNMID=ci_trxnmid_old
673: AND NEW_EXT.TRXNMID(+)=ci_trxnmid_new
674: and old_ext.extend_name=new_ext.extend_name(+);
675:

Line 799: INSERT INTO iby_trxn_extensibility

795: -- Copy the extensibility data from the old authorization. Any updated
796: -- attribute obtained during reversal overrides the old values.
797: --
798: FOR extend_rec IN c_extend(l_old_auth_trxnmid,trxnmid_in) LOOP
799: INSERT INTO iby_trxn_extensibility
800: (trxn_extend_id,trxnmid,extend_name,extend_value,created_by,
801: creation_date,last_updated_by,last_update_date,last_update_login,
802: object_version_number)
803: VALUES

Line 804: (iby_trxn_extensibility_s.NEXTVAL,

800: (trxn_extend_id,trxnmid,extend_name,extend_value,created_by,
801: creation_date,last_updated_by,last_update_date,last_update_login,
802: object_version_number)
803: VALUES
804: (iby_trxn_extensibility_s.NEXTVAL,
805: l_new_auth_trxnmid,extend_rec.extend_name,extend_rec.extend_value,
806: fnd_global.user_id,sysdate,fnd_global.user_id,sysdate,
807: fnd_global.login_id,1);
808: END LOOP;