APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_SYS_DC_PF_B

Line 1793: cursor C is select ROWID from IBY_FNDCPT_SYS_DC_PF_B

1789: X_LAST_UPDATE_DATE in DATE,
1790: X_LAST_UPDATED_BY in NUMBER,
1791: X_LAST_UPDATE_LOGIN in NUMBER
1792: ) is
1793: cursor C is select ROWID from IBY_FNDCPT_SYS_DC_PF_B
1794: where SYS_DC_PROFILE_CODE = X_SYS_DC_PROFILE_CODE
1795: ;
1796: begin
1797: insert into IBY_FNDCPT_SYS_DC_PF_B (

Line 1797: insert into IBY_FNDCPT_SYS_DC_PF_B (

1793: cursor C is select ROWID from IBY_FNDCPT_SYS_DC_PF_B
1794: where SYS_DC_PROFILE_CODE = X_SYS_DC_PROFILE_CODE
1795: ;
1796: begin
1797: insert into IBY_FNDCPT_SYS_DC_PF_B (
1798: ONLINE_DEB_FORMAT_CODE,
1799: ONLINE_DEB_TRANS_PRTCL_CODE,
1800: ONLINE_DEB_ACK_RDR_CODE,
1801: SETTLEMENT_REQ_FLAG,

Line 1900: update IBY_FNDCPT_SYS_DC_PF_B set

1896: X_LAST_UPDATED_BY in NUMBER,
1897: X_LAST_UPDATE_LOGIN in NUMBER
1898: ) is
1899: begin
1900: update IBY_FNDCPT_SYS_DC_PF_B set
1901: ONLINE_DEB_FORMAT_CODE = X_ONLINE_DEB_FORMAT_CODE,
1902: ONLINE_DEB_TRANS_PRTCL_CODE = X_ONLINE_DEB_TRANS_PRTCL_CODE,
1903: ONLINE_DEB_ACK_RDR_CODE = X_ONLINE_DEB_ACK_RDR_CODE,
1904: SETTLEMENT_REQ_FLAG = X_SETTLEMENT_REQ_FLAG,

Line 1948: delete from IBY_FNDCPT_SYS_DC_PF_B

1944: if (sql%notfound) then
1945: raise no_data_found;
1946: end if;
1947:
1948: delete from IBY_FNDCPT_SYS_DC_PF_B
1949: where SYS_DC_PROFILE_CODE = X_SYS_DC_PROFILE_CODE;
1950:
1951: if (sql%notfound) then
1952: raise no_data_found;

Line 1962: from IBY_FNDCPT_SYS_DC_PF_B B

1958: begin
1959: delete from IBY_FNDCPT_SYS_DC_PF_TL T
1960: where not exists
1961: (select NULL
1962: from IBY_FNDCPT_SYS_DC_PF_B B
1963: where B.SYS_DC_PROFILE_CODE = T.SYS_DC_PROFILE_CODE
1964: );
1965:
1966: update IBY_FNDCPT_SYS_DC_PF_TL T set (