APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_USER_DC_PF_B

Line 2554: cursor C is select ROWID from IBY_FNDCPT_USER_DC_PF_B

2550: X_LAST_UPDATE_DATE in DATE,
2551: X_LAST_UPDATED_BY in NUMBER,
2552: X_LAST_UPDATE_LOGIN in NUMBER
2553: ) is
2554: cursor C is select ROWID from IBY_FNDCPT_USER_DC_PF_B
2555: where USER_DC_PROFILE_CODE = X_USER_DC_PROFILE_CODE
2556: ;
2557: begin
2558: insert into IBY_FNDCPT_USER_DC_PF_B (

Line 2558: insert into IBY_FNDCPT_USER_DC_PF_B (

2554: cursor C is select ROWID from IBY_FNDCPT_USER_DC_PF_B
2555: where USER_DC_PROFILE_CODE = X_USER_DC_PROFILE_CODE
2556: ;
2557: begin
2558: insert into IBY_FNDCPT_USER_DC_PF_B (
2559: SETTLEMENT_TRANS_CONFIG_ID,
2560: QUERY_TRANS_CONFIG_ID,
2561: INACTIVE_DATE,
2562: OBJECT_VERSION_NUMBER,

Line 2643: update IBY_FNDCPT_USER_DC_PF_B set

2639: X_LAST_UPDATED_BY in NUMBER,
2640: X_LAST_UPDATE_LOGIN in NUMBER
2641: ) is
2642: begin
2643: update IBY_FNDCPT_USER_DC_PF_B set
2644: SETTLEMENT_TRANS_CONFIG_ID = X_SETTLEMENT_TRANS_CONFIG_ID,
2645: QUERY_TRANS_CONFIG_ID = X_QUERY_TRANS_CONFIG_ID,
2646: INACTIVE_DATE = X_INACTIVE_DATE,
2647: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 2685: delete from IBY_FNDCPT_USER_DC_PF_B

2681: if (sql%notfound) then
2682: raise no_data_found;
2683: end if;
2684:
2685: delete from IBY_FNDCPT_USER_DC_PF_B
2686: where USER_DC_PROFILE_CODE = X_USER_DC_PROFILE_CODE;
2687:
2688: if (sql%notfound) then
2689: raise no_data_found;

Line 2699: from IBY_FNDCPT_USER_DC_PF_B B

2695: begin
2696: delete from IBY_FNDCPT_USER_DC_PF_TL T
2697: where not exists
2698: (select NULL
2699: from IBY_FNDCPT_USER_DC_PF_B B
2700: where B.USER_DC_PROFILE_CODE = T.USER_DC_PROFILE_CODE
2701: );
2702:
2703: update IBY_FNDCPT_USER_DC_PF_TL T set (