229: X_VALIDATION_CODE_LANGUAGE,
230: X_OBJECT_VERSION_NUMBER,
231: X_VALIDATION_SET_DISPLAY_NAME,
232: X_LAST_UPDATE_DATE,
233: fnd_load_util.owner_id(X_OWNER),
234: fnd_load_util.owner_id(X_OWNER));
235: exception
236: when no_data_found then
237: VAL_SET_INSERT_ROW (
230: X_OBJECT_VERSION_NUMBER,
231: X_VALIDATION_SET_DISPLAY_NAME,
232: X_LAST_UPDATE_DATE,
233: fnd_load_util.owner_id(X_OWNER),
234: fnd_load_util.owner_id(X_OWNER));
235: exception
236: when no_data_found then
237: VAL_SET_INSERT_ROW (
238: row_id,
243: X_VALIDATION_CODE_LANGUAGE,
244: X_OBJECT_VERSION_NUMBER,
245: X_VALIDATION_SET_DISPLAY_NAME,
246: X_LAST_UPDATE_DATE,
247: fnd_load_util.owner_id(X_OWNER),
248: X_LAST_UPDATE_DATE,
249: fnd_load_util.owner_id(X_OWNER),
250: fnd_load_util.owner_id(X_OWNER));
251: end;
245: X_VALIDATION_SET_DISPLAY_NAME,
246: X_LAST_UPDATE_DATE,
247: fnd_load_util.owner_id(X_OWNER),
248: X_LAST_UPDATE_DATE,
249: fnd_load_util.owner_id(X_OWNER),
250: fnd_load_util.owner_id(X_OWNER));
251: end;
252:
253: procedure VAL_SET_TRANSLATE_ROW (
246: X_LAST_UPDATE_DATE,
247: fnd_load_util.owner_id(X_OWNER),
248: X_LAST_UPDATE_DATE,
249: fnd_load_util.owner_id(X_OWNER),
250: fnd_load_util.owner_id(X_OWNER));
251: end;
252:
253: procedure VAL_SET_TRANSLATE_ROW (
254: X_VALIDATION_SET_CODE in VARCHAR2,
260: begin
261: update iby_validation_sets_tl set
262: VALIDATION_SET_DISPLAY_NAME = X_VALIDATION_SET_DISPLAY_NAME,
263: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
264: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
265: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
266: LAST_UPDATE_LOGIN = fnd_load_util.owner_id(X_OWNER),
267: SOURCE_LANG = userenv('LANG')
268: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
262: VALIDATION_SET_DISPLAY_NAME = X_VALIDATION_SET_DISPLAY_NAME,
263: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
264: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
265: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
266: LAST_UPDATE_LOGIN = fnd_load_util.owner_id(X_OWNER),
267: SOURCE_LANG = userenv('LANG')
268: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
269: and VALIDATION_SET_CODE = X_VALIDATION_SET_CODE;
270: end;
507: X_VALIDATION_PARAM_DISPLAY_ORD,
508: X_OBJECT_VERSION_NUMBER,
509: X_VALIDATION_PARAM_DISPLAY_NAM,
510: X_LAST_UPDATE_DATE,
511: fnd_load_util.owner_id(X_OWNER),
512: fnd_load_util.owner_id(X_OWNER));
513: exception
514: when no_data_found then
515: VAL_PARAM_INSERT_ROW (
508: X_OBJECT_VERSION_NUMBER,
509: X_VALIDATION_PARAM_DISPLAY_NAM,
510: X_LAST_UPDATE_DATE,
511: fnd_load_util.owner_id(X_OWNER),
512: fnd_load_util.owner_id(X_OWNER));
513: exception
514: when no_data_found then
515: VAL_PARAM_INSERT_ROW (
516: row_id,
520: X_VALIDATION_PARAM_DISPLAY_ORD,
521: X_OBJECT_VERSION_NUMBER,
522: X_VALIDATION_PARAM_DISPLAY_NAM,
523: X_LAST_UPDATE_DATE,
524: fnd_load_util.owner_id(X_OWNER),
525: X_LAST_UPDATE_DATE,
526: fnd_load_util.owner_id(X_OWNER),
527: fnd_load_util.owner_id(X_OWNER));
528: end;
522: X_VALIDATION_PARAM_DISPLAY_NAM,
523: X_LAST_UPDATE_DATE,
524: fnd_load_util.owner_id(X_OWNER),
525: X_LAST_UPDATE_DATE,
526: fnd_load_util.owner_id(X_OWNER),
527: fnd_load_util.owner_id(X_OWNER));
528: end;
529:
530: procedure VAL_PARAM_TRANSLATE_ROW (
523: X_LAST_UPDATE_DATE,
524: fnd_load_util.owner_id(X_OWNER),
525: X_LAST_UPDATE_DATE,
526: fnd_load_util.owner_id(X_OWNER),
527: fnd_load_util.owner_id(X_OWNER));
528: end;
529:
530: procedure VAL_PARAM_TRANSLATE_ROW (
531: X_VALIDATION_SET_CODE in VARCHAR2,
538: begin
539: update iby_validation_params_tl set
540: VALIDATION_PARAM_DISPLAY_NAME = X_VALIDATION_PARAM_DISPLAY_NAM,
541: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
542: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
543: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
544: LAST_UPDATE_LOGIN = fnd_load_util.owner_id(X_OWNER),
545: SOURCE_LANG = userenv('LANG')
546: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
540: VALIDATION_PARAM_DISPLAY_NAME = X_VALIDATION_PARAM_DISPLAY_NAM,
541: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
542: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
543: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
544: LAST_UPDATE_LOGIN = fnd_load_util.owner_id(X_OWNER),
545: SOURCE_LANG = userenv('LANG')
546: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
547: and VALIDATION_SET_CODE = X_VALIDATION_SET_CODE
548: and VALIDATION_PARAMETER_CODE = X_VALIDATION_PARAMETER_CODE;
770: X_TRANSMIT_CODE_PACKAGE,
771: X_TRANSMIT_CODE_ENTRY_POINT,
772: X_TRANSMIT_PROTOCOL_NAME,
773: X_LAST_UPDATE_DATE,
774: fnd_load_util.owner_id(X_OWNER),
775: fnd_load_util.owner_id(X_OWNER));
776: exception
777: when no_data_found then
778: TRANS_PROT_INSERT_ROW (
771: X_TRANSMIT_CODE_ENTRY_POINT,
772: X_TRANSMIT_PROTOCOL_NAME,
773: X_LAST_UPDATE_DATE,
774: fnd_load_util.owner_id(X_OWNER),
775: fnd_load_util.owner_id(X_OWNER));
776: exception
777: when no_data_found then
778: TRANS_PROT_INSERT_ROW (
779: row_id,
783: X_TRANSMIT_CODE_PACKAGE,
784: X_TRANSMIT_CODE_ENTRY_POINT,
785: X_TRANSMIT_PROTOCOL_NAME,
786: X_LAST_UPDATE_DATE,
787: fnd_load_util.owner_id(X_OWNER),
788: X_LAST_UPDATE_DATE,
789: fnd_load_util.owner_id(X_OWNER),
790: fnd_load_util.owner_id(X_OWNER));
791: end;
785: X_TRANSMIT_PROTOCOL_NAME,
786: X_LAST_UPDATE_DATE,
787: fnd_load_util.owner_id(X_OWNER),
788: X_LAST_UPDATE_DATE,
789: fnd_load_util.owner_id(X_OWNER),
790: fnd_load_util.owner_id(X_OWNER));
791: end;
792:
793: procedure TRANS_PROT_TRANSLATE_ROW (
786: X_LAST_UPDATE_DATE,
787: fnd_load_util.owner_id(X_OWNER),
788: X_LAST_UPDATE_DATE,
789: fnd_load_util.owner_id(X_OWNER),
790: fnd_load_util.owner_id(X_OWNER));
791: end;
792:
793: procedure TRANS_PROT_TRANSLATE_ROW (
794: X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
800: begin
801: update iby_transmit_protocols_tl set
802: TRANSMIT_PROTOCOL_NAME = X_TRANSMIT_PROTOCOL_NAME,
803: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
804: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
805: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
806: LAST_UPDATE_LOGIN = fnd_load_util.owner_id(X_OWNER),
807: SOURCE_LANG = userenv('LANG')
808: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
802: TRANSMIT_PROTOCOL_NAME = X_TRANSMIT_PROTOCOL_NAME,
803: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
804: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
805: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
806: LAST_UPDATE_LOGIN = fnd_load_util.owner_id(X_OWNER),
807: SOURCE_LANG = userenv('LANG')
808: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
809: and TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE;
810: end;
1089: X_SECURED_FLAG,
1090: X_OBJECT_VERSION_NUMBER,
1091: X_TRANSMIT_PARAMETER_NAME,
1092: X_LAST_UPDATE_DATE,
1093: fnd_load_util.owner_id(X_OWNER),
1094: fnd_load_util.owner_id(X_OWNER));
1095: exception
1096: when no_data_found then
1097: TRANS_PARAM_INSERT_ROW (
1090: X_OBJECT_VERSION_NUMBER,
1091: X_TRANSMIT_PARAMETER_NAME,
1092: X_LAST_UPDATE_DATE,
1093: fnd_load_util.owner_id(X_OWNER),
1094: fnd_load_util.owner_id(X_OWNER));
1095: exception
1096: when no_data_found then
1097: TRANS_PARAM_INSERT_ROW (
1098: row_id,
1108: X_SECURED_FLAG,
1109: X_OBJECT_VERSION_NUMBER,
1110: X_TRANSMIT_PARAMETER_NAME,
1111: X_LAST_UPDATE_DATE,
1112: fnd_load_util.owner_id(X_OWNER),
1113: X_LAST_UPDATE_DATE,
1114: fnd_load_util.owner_id(X_OWNER),
1115: fnd_load_util.owner_id(X_OWNER));
1116: end;
1110: X_TRANSMIT_PARAMETER_NAME,
1111: X_LAST_UPDATE_DATE,
1112: fnd_load_util.owner_id(X_OWNER),
1113: X_LAST_UPDATE_DATE,
1114: fnd_load_util.owner_id(X_OWNER),
1115: fnd_load_util.owner_id(X_OWNER));
1116: end;
1117:
1118: procedure TRANS_PARAM_TRANSLATE_ROW (
1111: X_LAST_UPDATE_DATE,
1112: fnd_load_util.owner_id(X_OWNER),
1113: X_LAST_UPDATE_DATE,
1114: fnd_load_util.owner_id(X_OWNER),
1115: fnd_load_util.owner_id(X_OWNER));
1116: end;
1117:
1118: procedure TRANS_PARAM_TRANSLATE_ROW (
1119: X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
1126: begin
1127: update iby_transmit_parameters_tl set
1128: TRANSMIT_PARAMETER_NAME = X_TRANSMIT_PARAMETER_NAME,
1129: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
1130: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
1131: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1132: LAST_UPDATE_LOGIN = fnd_load_util.owner_id(X_OWNER),
1133: SOURCE_LANG = userenv('LANG')
1134: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1128: TRANSMIT_PARAMETER_NAME = X_TRANSMIT_PARAMETER_NAME,
1129: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
1130: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
1131: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1132: LAST_UPDATE_LOGIN = fnd_load_util.owner_id(X_OWNER),
1133: SOURCE_LANG = userenv('LANG')
1134: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1135: and TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE
1136: and TRANSMIT_PARAMETER_CODE = X_TRANSMIT_PARAMETER_CODE;