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.

[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on POS_BANK_ACCNT_OWNERS_INT

Line 8062: FROM pos_bank_accnt_owners_int supp

8058: AND party.interface_status = 'R');
8059:
8060: CURSOR account_owners_cur IS
8061: SELECT *
8062: FROM pos_bank_accnt_owners_int supp
8063: WHERE batch_id = p_batch_id
8064: AND nvl(interface_status, 'ACTIVE') NOT IN
8065: ('PROCESSED', 'REMOVED')
8066: AND NOT EXISTS

Line 8077: account_owners_rec pos_bank_accnt_owners_int%ROWTYPE;

8073: party.party_orig_system_reference
8074: AND party.interface_status = 'R');
8075:
8076: bank_account_dtls_rec bank_account_dtls_cur%ROWTYPE;
8077: account_owners_rec pos_bank_accnt_owners_int%ROWTYPE;
8078: l_party_id NUMBER;
8079:
8080: l_ret_status VARCHAR2(40);
8081: l_msg_count NUMBER;

Line 8161: UPDATE pos_bank_accnt_owners_int api

8157: FROM fnd_concurrent_requests fcr
8158: WHERE fcr.request_id = api.request_id
8159: AND fcr.phase_code = 'C');
8160:
8161: UPDATE pos_bank_accnt_owners_int api
8162: SET request_id = NULL
8163: WHERE request_id IS NOT NULL
8164: AND batch_id = p_batch_id
8165: AND nvl(interface_status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')

Line 8179: UPDATE pos_bank_accnt_owners_int

8175: WHERE request_id IS NULL
8176: AND batch_id = p_batch_id
8177: AND nvl(interface_status, 'ACTIVE') <> 'PROCESSED';
8178:
8179: UPDATE pos_bank_accnt_owners_int
8180: SET request_id = l_request_id
8181: WHERE request_id IS NULL
8182: AND batch_id = p_batch_id
8183: AND nvl(interface_status, 'ACTIVE') <> 'PROCESSED';

Line 8220: UPDATE pos_bank_accnt_owners_int supp

8216: WHERE interface_status = 'REMOVED'
8217: AND request_id = l_request_id
8218: AND batch_id = p_batch_id);
8219:
8220: UPDATE pos_bank_accnt_owners_int supp
8221: SET interface_status = 'REMOVED',
8222: request_id = l_request_id
8223: WHERE batch_id = p_batch_id
8224: AND nvl(interface_status, 'ACTIVE') <> 'PROCESSED'

Line 8237: ' records from table pos_bank_accnt_owners_int. Reason interface_status in hz_imp_parties_int = R');

8233:
8234: fnd_file.put_line(fnd_file.log,
8235: ' Message: Inside PROCEDURE IMPORT_VENDOR_BANK_DTLS' ||
8236: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
8237: ' records from table pos_bank_accnt_owners_int. Reason interface_status in hz_imp_parties_int = R');
8238:
8239: INSERT INTO pos_supplier_int_rejections
8240: (SELECT p_batch_id,
8241: l_request_id,

Line 8242: 'POS_BANK_ACCNT_OWNERS_INT',

8238:
8239: INSERT INTO pos_supplier_int_rejections
8240: (SELECT p_batch_id,
8241: l_request_id,
8242: 'POS_BANK_ACCNT_OWNERS_INT',
8243: bank_acct_owner_interface_id,
8244: 'POS_INVALID_PARTY_ORIG_SYSTEM',
8245: g_user_id,
8246: SYSDATE,

Line 8250: FROM pos_bank_accnt_owners_int

8246: SYSDATE,
8247: g_login_id,
8248: g_user_id,
8249: SYSDATE
8250: FROM pos_bank_accnt_owners_int
8251: WHERE interface_status = 'REMOVED'
8252: AND request_id = l_request_id
8253: AND batch_id = p_batch_id);
8254:

Line 9355: UPDATE pos_bank_accnt_owners_int

9351: bank_account_dtls_rec.bank_account_interface_id
9352: AND batch_id = p_batch_id;
9353:
9354: -- Update the interface table with the bank_id and branch_id that are obtained
9355: UPDATE pos_bank_accnt_owners_int
9356: SET bank_id = l_bank_id,
9357: branch_id = l_branch_id,
9358: account_id = l_account_id
9359: WHERE bank_account_interface_id =

Line 9744: UPDATE pos_bank_accnt_owners_int

9740: fnd_file.put_line(fnd_file.log, ' l_account_id: ' || l_account_id);
9741:
9742: EXCEPTION
9743: WHEN OTHERS THEN
9744: UPDATE pos_bank_accnt_owners_int
9745: SET interface_status = 'REJECTED'
9746: WHERE bank_acct_owner_interface_id =
9747: account_owners_rec.bank_acct_owner_interface_id
9748: AND batch_id = p_batch_id;

Line 9752: 'POS_BANK_ACCNT_OWNERS_INT',

9748: AND batch_id = p_batch_id;
9749:
9750: IF (insert_rejections(p_batch_id,
9751: l_request_id,
9752: 'POS_BANK_ACCNT_OWNERS_INT',
9753: bank_account_dtls_rec.bank_account_interface_id,
9754: 'POS_ADD_ACCT_OWNER',
9755: g_user_id,
9756: g_login_id,

Line 9798: UPDATE pos_bank_accnt_owners_int

9794: x_msg_data := l_msg_data;
9795:
9796: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
9797:
9798: UPDATE pos_bank_accnt_owners_int
9799: SET interface_status = 'REJECTED'
9800: WHERE bank_acct_owner_interface_id =
9801: account_owners_rec.bank_acct_owner_interface_id
9802: AND batch_id = p_batch_id;

Line 9806: 'POS_BANK_ACCNT_OWNERS_INT',

9802: AND batch_id = p_batch_id;
9803:
9804: IF (insert_rejections(p_batch_id,
9805: l_request_id,
9806: 'POS_BANK_ACCNT_OWNERS_INT',
9807: bank_account_dtls_rec.bank_account_interface_id,
9808: 'POS_ADD_ACCT_OWNER',
9809: g_user_id,
9810: g_login_id,

Line 9869: UPDATE pos_bank_accnt_owners_int

9865: x_msg_data := l_msg_data;
9866:
9867: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
9868:
9869: UPDATE pos_bank_accnt_owners_int
9870: SET interface_status = 'REJECTED'
9871: WHERE bank_acct_owner_interface_id =
9872: account_owners_rec.bank_acct_owner_interface_id
9873: AND batch_id = p_batch_id;

Line 9877: 'POS_BANK_ACCNT_OWNERS_INT',

9873: AND batch_id = p_batch_id;
9874:
9875: IF (insert_rejections(p_batch_id,
9876: l_request_id,
9877: 'POS_BANK_ACCNT_OWNERS_INT',
9878: bank_account_dtls_rec.bank_account_interface_id,
9879: 'POS_ADD_ACCT_OWNER',
9880: g_user_id,
9881: g_login_id,

Line 9922: UPDATE pos_bank_accnt_owners_int

9918: x_msg_data := l_msg_data;
9919:
9920: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
9921:
9922: UPDATE pos_bank_accnt_owners_int
9923: SET interface_status = 'REJECTED'
9924: WHERE bank_acct_owner_interface_id =
9925: account_owners_rec.bank_acct_owner_interface_id
9926: AND batch_id = p_batch_id;

Line 9930: 'POS_BANK_ACCNT_OWNERS_INT',

9926: AND batch_id = p_batch_id;
9927:
9928: IF (insert_rejections(p_batch_id,
9929: l_request_id,
9930: 'POS_BANK_ACCNT_OWNERS_INT',
9931: bank_account_dtls_rec.bank_account_interface_id,
9932: 'POS_PRIMARY_FLAG_NOTSET',
9933: g_user_id,
9934: g_login_id,

Line 9959: UPDATE pos_bank_accnt_owners_int

9955: END IF;
9956:
9957: END IF;
9958:
9959: UPDATE pos_bank_accnt_owners_int
9960: SET interface_status = 'PROCESSED'
9961: WHERE bank_acct_owner_interface_id =
9962: account_owners_rec.bank_acct_owner_interface_id
9963: AND batch_id = p_batch_id;

Line 10505: FROM pos_bank_accnt_owners_int

10501: l_tot_err_count := l_tot_err_count + l_error_count;
10502:
10503: SELECT COUNT(1)
10504: INTO l_error_count
10505: FROM pos_bank_accnt_owners_int
10506: WHERE batch_id = p_batch_id
10507: AND nvl(interface_status, 'ACTIVE') = 'REJECTED'
10508: AND rownum = 1;
10509: