APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_USER_CC_PF_B

Line 2120: cursor C is select ROWID from IBY_FNDCPT_USER_CC_PF_B

2116: X_LAST_UPDATE_DATE in DATE,
2117: X_LAST_UPDATED_BY in NUMBER,
2118: X_LAST_UPDATE_LOGIN in NUMBER
2119: ) is
2120: cursor C is select ROWID from IBY_FNDCPT_USER_CC_PF_B
2121: where USER_CC_PROFILE_CODE = X_USER_CC_PROFILE_CODE
2122: ;
2123: begin
2124: insert into IBY_FNDCPT_USER_CC_PF_B (

Line 2124: insert into IBY_FNDCPT_USER_CC_PF_B (

2120: cursor C is select ROWID from IBY_FNDCPT_USER_CC_PF_B
2121: where USER_CC_PROFILE_CODE = X_USER_CC_PROFILE_CODE
2122: ;
2123: begin
2124: insert into IBY_FNDCPT_USER_CC_PF_B (
2125: OBJECT_VERSION_NUMBER,
2126: BEP_ACCOUNT_ID,
2127: USER_CC_PROFILE_CODE,
2128: SYS_CC_PROFILE_CODE,

Line 2209: update IBY_FNDCPT_USER_CC_PF_B set

2205: X_LAST_UPDATED_BY in NUMBER,
2206: X_LAST_UPDATE_LOGIN in NUMBER
2207: ) is
2208: begin
2209: update IBY_FNDCPT_USER_CC_PF_B set
2210: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
2211: BEP_ACCOUNT_ID = X_BEP_ACCOUNT_ID,
2212: SYS_CC_PROFILE_CODE = X_SYS_CC_PROFILE_CODE,
2213: INACTIVE_DATE = X_INACTIVE_DATE,

Line 2251: delete from IBY_FNDCPT_USER_CC_PF_B

2247: if (sql%notfound) then
2248: raise no_data_found;
2249: end if;
2250:
2251: delete from IBY_FNDCPT_USER_CC_PF_B
2252: where USER_CC_PROFILE_CODE = X_USER_CC_PROFILE_CODE;
2253:
2254: if (sql%notfound) then
2255: raise no_data_found;

Line 2265: from IBY_FNDCPT_USER_CC_PF_B B

2261: begin
2262: delete from IBY_FNDCPT_USER_CC_PF_TL T
2263: where not exists
2264: (select NULL
2265: from IBY_FNDCPT_USER_CC_PF_B B
2266: where B.USER_CC_PROFILE_CODE = T.USER_CC_PROFILE_CODE
2267: );
2268:
2269: update IBY_FNDCPT_USER_CC_PF_TL T set (