1008: X_LAST_UPDATE_DATE in DATE,
1009: X_LAST_UPDATED_BY in NUMBER,
1010: X_LAST_UPDATE_LOGIN in NUMBER
1011: ) is
1012: cursor C is select ROWID from IBY_FNDCPT_SYS_CC_PF_B
1013: where SYS_CC_PROFILE_CODE = X_SYS_CC_PROFILE_CODE
1014: ;
1015: begin
1016: insert into IBY_FNDCPT_SYS_CC_PF_B (
1012: cursor C is select ROWID from IBY_FNDCPT_SYS_CC_PF_B
1013: where SYS_CC_PROFILE_CODE = X_SYS_CC_PROFILE_CODE
1014: ;
1015: begin
1016: insert into IBY_FNDCPT_SYS_CC_PF_B (
1017: SETTLEMENT_TRANS_PRTCL_CODE,
1018: SETTLEMENT_ACK_RDR_CODE,
1019: QUERY_FORMAT_CODE,
1020: QUERY_TRANS_PRTCL_CODE,
1112: X_LAST_UPDATED_BY in NUMBER,
1113: X_LAST_UPDATE_LOGIN in NUMBER
1114: ) is
1115: begin
1116: update IBY_FNDCPT_SYS_CC_PF_B set
1117: SETTLEMENT_TRANS_PRTCL_CODE = X_SETTLEMENT_TRANS_PRTCL_CODE,
1118: SETTLEMENT_ACK_RDR_CODE = X_SETTLEMENT_ACK_RDR_CODE,
1119: QUERY_FORMAT_CODE = X_QUERY_FORMAT_CODE,
1120: QUERY_TRANS_PRTCL_CODE = X_QUERY_TRANS_PRTCL_CODE,
1159: if (sql%notfound) then
1160: raise no_data_found;
1161: end if;
1162:
1163: delete from IBY_FNDCPT_SYS_CC_PF_B
1164: where SYS_CC_PROFILE_CODE = X_SYS_CC_PROFILE_CODE;
1165:
1166: if (sql%notfound) then
1167: raise no_data_found;
1173: begin
1174: delete from IBY_FNDCPT_SYS_CC_PF_TL T
1175: where not exists
1176: (select NULL
1177: from IBY_FNDCPT_SYS_CC_PF_B B
1178: where B.SYS_CC_PROFILE_CODE = T.SYS_CC_PROFILE_CODE
1179: );
1180:
1181: update IBY_FNDCPT_SYS_CC_PF_TL T set (