APPS.IBY_SYS_PMT_PROFILES_PKG dependencies on IBY_SYS_PMT_PROFILES_B

Line 66: cursor C is select ROWID from IBY_SYS_PMT_PROFILES_B

62: X_LAST_UPDATE_DATE in DATE,
63: X_LAST_UPDATED_BY in NUMBER,
64: X_LAST_UPDATE_LOGIN in NUMBER
65: ) is
66: cursor C is select ROWID from IBY_SYS_PMT_PROFILES_B
67: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
68: ;
69: begin
70: insert into IBY_SYS_PMT_PROFILES_B (

Line 70: insert into IBY_SYS_PMT_PROFILES_B (

66: cursor C is select ROWID from IBY_SYS_PMT_PROFILES_B
67: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
68: ;
69: begin
70: insert into IBY_SYS_PMT_PROFILES_B (
71: PAYMENT_TEXT_MESSAGE2,
72: INACTIVE_DATE,
73: ACK_TRANSMIT_PROTOCOL_CODE,
74: ACK_SECURITY_PROTOCOL_CODE,

Line 342: from IBY_SYS_PMT_PROFILES_B

338: POSITIVE_PAY_FORMAT_CODE,
339: PAY_FILE_LETTER_FORMAT_CODE,
340: BEPID,
341: SECURITY_PROTOCOL_CODE
342: from IBY_SYS_PMT_PROFILES_B
343: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
344: for update of SYSTEM_PROFILE_CODE nowait;
345: recinfo c%rowtype;
346:

Line 542: update IBY_SYS_PMT_PROFILES_B set

538: X_LAST_UPDATED_BY in NUMBER,
539: X_LAST_UPDATE_LOGIN in NUMBER
540: ) is
541: begin
542: update IBY_SYS_PMT_PROFILES_B set
543: PAYMENT_TEXT_MESSAGE2 = X_PAYMENT_TEXT_MESSAGE2,
544: INACTIVE_DATE = X_INACTIVE_DATE,
545: ACK_TRANSMIT_PROTOCOL_CODE = X_ACK_TRANSMIT_PROTOCOL_CODE,
546: ACK_SECURITY_PROTOCOL_CODE = X_ACK_SECURITY_PROTOCOL_CODE,

Line 630: delete from IBY_SYS_PMT_PROFILES_B

626: if (sql%notfound) then
627: raise no_data_found;
628: end if;
629:
630: delete from IBY_SYS_PMT_PROFILES_B
631: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE;
632:
633: if (sql%notfound) then
634: raise no_data_found;

Line 644: from IBY_SYS_PMT_PROFILES_B B

640: begin
641: delete from IBY_SYS_PMT_PROFILES_TL T
642: where not exists
643: (select NULL
644: from IBY_SYS_PMT_PROFILES_B B
645: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE
646: );
647:
648: update IBY_SYS_PMT_PROFILES_TL T set (