eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_DEBIT_AUTHORIZATIONS

Line 1297: ( p_mandate_id IN iby_debit_authorizations.debit_authorization_id%TYPE )

1293: is_amended: Gives whether the mandate has been amended or not.
1294: */
1295:
1296: FUNCTION is_amended
1297: ( p_mandate_id IN iby_debit_authorizations.debit_authorization_id%TYPE )
1298: RETURN varchar2
1299: IS
1300: l_count number(6);
1301: BEGIN

Line 1304: FROM iby_debit_authorizations

1300: l_count number(6);
1301: BEGIN
1302:
1303: SELECT count(*) INTO l_count
1304: FROM iby_debit_authorizations
1305: WHERE initial_debit_authorization_id = ( SELECT initial_debit_authorization_id
1306: FROM iby_debit_authorizations
1307: WHERE debit_authorization_id = p_mandate_id );
1308:

Line 1306: FROM iby_debit_authorizations

1302:
1303: SELECT count(*) INTO l_count
1304: FROM iby_debit_authorizations
1305: WHERE initial_debit_authorization_id = ( SELECT initial_debit_authorization_id
1306: FROM iby_debit_authorizations
1307: WHERE debit_authorization_id = p_mandate_id );
1308:
1309: IF (l_count >1)
1310: THEN RETURN 'TRUE';

Line 1329: ( p_assign_id IN iby_debit_authorizations.external_bank_account_use_id%TYPE )

1325: */
1326:
1327:
1328: FUNCTION get_assignment_iban
1329: ( p_assign_id IN iby_debit_authorizations.external_bank_account_use_id%TYPE )
1330: RETURN varchar2
1331: IS
1332: l_iban iby_ext_bank_accounts.iban%TYPE;
1333: BEGIN

Line 1366: ( p_mandate_id IN iby_debit_authorizations.debit_authorization_id%TYPE )

1362: */
1363:
1364:
1365: FUNCTION get_mandate_details
1366: ( p_mandate_id IN iby_debit_authorizations.debit_authorization_id%TYPE )
1367: RETURN XMLType
1368: IS
1369: l_doc_rec XMLType;
1370:

Line 1372: (c_mandate_id iby_debit_authorizations.debit_authorization_id%TYPE) IS

1368: IS
1369: l_doc_rec XMLType;
1370:
1371: CURSOR l_mandate
1372: (c_mandate_id iby_debit_authorizations.debit_authorization_id%TYPE) IS
1373: SELECT MandateDetails from (
1374: SELECT debit_id, XMLElement("MandateDetails", XMLConcat( XMLElement("AuthorizationReference", curr_auth_ref)
1375: , XMLElement("AuthorizationSignDate", curr_sign_date)
1376: , XMLElement("AmendmentIndicator", amend_indicator) , XMLElement("OrgnlAuthReference", prev_auth_ref)

Line 1387: FROM iby_debit_authorizations curr_mandate , iby_debit_authorizations prev_mandate

1383: , prev_mandate.authorization_reference_number prev_auth_ref , prev_mandate.creditor_le_name prev_cred_name
1384: , prev_mandate.creditor_identifier prev_cred_id
1385: ,get_assignment_iban(prev_mandate.external_bank_account_use_id) iban
1386: ,curr_mandate.creditor_le_name curr_cred_name , curr_mandate.creditor_identifier curr_cred_id
1387: FROM iby_debit_authorizations curr_mandate , iby_debit_authorizations prev_mandate
1388: WHERE curr_mandate.initial_debit_authorization_id = prev_mandate.initial_debit_authorization_id(+)
1389: AND curr_mandate.debit_authorization_id <> prev_mandate.debit_authorization_id(+)
1390: ORDER BY prev_mandate.authorization_revision_number DESC )
1391: WHERE debit_id = c_mandate_id