APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_PMT_CHNNLS_B

Line 2784: cursor C is select ROWID from IBY_FNDCPT_PMT_CHNNLS_B

2780: X_LAST_UPDATE_DATE in DATE,
2781: X_LAST_UPDATED_BY in NUMBER,
2782: X_LAST_UPDATE_LOGIN in NUMBER
2783: ) is
2784: cursor C is select ROWID from IBY_FNDCPT_PMT_CHNNLS_B
2785: where PAYMENT_CHANNEL_CODE = X_PAYMENT_CHANNEL_CODE
2786: ;
2787: begin
2788: insert into IBY_FNDCPT_PMT_CHNNLS_B (

Line 2788: insert into IBY_FNDCPT_PMT_CHNNLS_B (

2784: cursor C is select ROWID from IBY_FNDCPT_PMT_CHNNLS_B
2785: where PAYMENT_CHANNEL_CODE = X_PAYMENT_CHANNEL_CODE
2786: ;
2787: begin
2788: insert into IBY_FNDCPT_PMT_CHNNLS_B (
2789: ATTRIBUTE13,
2790: ATTRIBUTE14,
2791: ATTRIBUTE15,
2792: OBJECT_VERSION_NUMBER,

Line 2912: update IBY_FNDCPT_PMT_CHNNLS_B set

2908: X_LAST_UPDATED_BY in NUMBER,
2909: X_LAST_UPDATE_LOGIN in NUMBER
2910: ) is
2911: begin
2912: update IBY_FNDCPT_PMT_CHNNLS_B set
2913: ATTRIBUTE13 = X_ATTRIBUTE13,
2914: ATTRIBUTE14 = X_ATTRIBUTE14,
2915: ATTRIBUTE15 = X_ATTRIBUTE15,
2916: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 2967: delete from IBY_FNDCPT_PMT_CHNNLS_B

2963: if (sql%notfound) then
2964: raise no_data_found;
2965: end if;
2966:
2967: delete from IBY_FNDCPT_PMT_CHNNLS_B
2968: where PAYMENT_CHANNEL_CODE = X_PAYMENT_CHANNEL_CODE;
2969:
2970: if (sql%notfound) then
2971: raise no_data_found;

Line 2981: from IBY_FNDCPT_PMT_CHNNLS_B B

2977: begin
2978: delete from IBY_FNDCPT_PMT_CHNNLS_TL T
2979: where not exists
2980: (select NULL
2981: from IBY_FNDCPT_PMT_CHNNLS_B B
2982: where B.PAYMENT_CHANNEL_CODE = T.PAYMENT_CHANNEL_CODE
2983: );
2984:
2985: update IBY_FNDCPT_PMT_CHNNLS_TL T set (