APPS.POS_BATCH_IMPORT_PKG dependencies on POS_PARTY_TAX_PROFILE_INT

Line 5962: p_tax_profile_rec IN pos_party_tax_profile_int%ROWTYPE,

5958:
5959: PROCEDURE validate_tax_profile
5960: (
5961: p_batch_id IN NUMBER,
5962: p_tax_profile_rec IN pos_party_tax_profile_int%ROWTYPE,
5963: x_return_status OUT NOCOPY VARCHAR2,
5964: x_msg_count OUT NOCOPY NUMBER,
5965: x_msg_data OUT NOCOPY VARCHAR2,
5966: x_tax_prof_valid OUT NOCOPY VARCHAR2,

Line 6019: 'POS_PARTY_TAX_PROFILE_INT',

6015: x_return_status := fnd_api.g_ret_sts_error;
6016: x_msg_data := 'POS_INVALID_ROUNDING_LEVEL';
6017: IF (insert_rejections(p_batch_id,
6018: l_request_id,
6019: 'POS_PARTY_TAX_PROFILE_INT',
6020: p_tax_profile_rec.rounding_level_code,
6021: 'POS_INVALID_ROUNDING_LEVEL',
6022: g_user_id,
6023: g_login_id,

Line 6063: 'POS_PARTY_TAX_PROFILE_INT',

6059: x_return_status := fnd_api.g_ret_sts_error;
6060: x_msg_data := 'POS_INVALID_ROUNDING_RULE';
6061: IF (insert_rejections(p_batch_id,
6062: l_request_id,
6063: 'POS_PARTY_TAX_PROFILE_INT',
6064: p_tax_profile_rec.rounding_rule_code,
6065: 'POS_INVALID_ROUNDING_RULE',
6066: g_user_id,
6067: g_login_id,

Line 6103: ' POS_PARTY_TAX_PROFILE_INT',

6099: x_return_status := fnd_api.g_ret_sts_error;
6100: x_msg_data := 'POS_INVALID_COUNTRY_NAME';
6101: IF (insert_rejections(p_batch_id,
6102: l_request_id,
6103: ' POS_PARTY_TAX_PROFILE_INT',
6104: p_tax_profile_rec.country_name,
6105: 'POS_INVALID_COUNTRY_NAME',
6106: g_user_id,
6107: g_login_id,

Line 6147: 'POS_PARTY_TAX_PROFILE_INT',

6143: x_return_status := fnd_api.g_ret_sts_error;
6144: x_msg_data := 'POS_INVALID_REGI_TYPE_CODE';
6145: IF (insert_rejections(p_batch_id,
6146: l_request_id,
6147: 'POS_PARTY_TAX_PROFILE_INT',
6148: p_tax_profile_rec.registration_type_code,
6149: 'POS_INVALID_REGI_TYPE_CODE',
6150: g_user_id,
6151: g_login_id,

Line 6184: p_tax_profile_rec IN pos_party_tax_profile_int%ROWTYPE,

6180:
6181: PROCEDURE create_tax_profile
6182: (
6183: p_batch_id IN NUMBER,
6184: p_tax_profile_rec IN pos_party_tax_profile_int%ROWTYPE,
6185: x_return_status OUT NOCOPY VARCHAR2,
6186: x_msg_count OUT NOCOPY NUMBER,
6187: x_msg_data OUT NOCOPY VARCHAR2,
6188: x_tax_profile_id OUT NOCOPY NUMBER

Line 7338: FROM pos_party_tax_profile_int supp

7334: l_msg_data VARCHAR2(2000);
7335:
7336: CURSOR tax_profile_cur IS
7337: SELECT *
7338: FROM pos_party_tax_profile_int supp
7339: WHERE batch_id = p_batch_id
7340: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
7341: AND NOT EXISTS
7342: (SELECT 1

Line 7387: TYPE l_tax_profile_rec_tab_typ IS TABLE OF pos_party_tax_profile_int%ROWTYPE;

7383: l_tax_reg_id NUMBER;
7384: l_party_tax_profile_id NUMBER;
7385: l_classification_type VARCHAR2(50);
7386:
7387: TYPE l_tax_profile_rec_tab_typ IS TABLE OF pos_party_tax_profile_int%ROWTYPE;
7388: l_tax_profile_rec_tab l_tax_profile_rec_tab_typ;
7389:
7390: TYPE l_tax_reg_rec_tab_typ IS TABLE OF pos_party_tax_reg_int%ROWTYPE;
7391: l_tax_reg_rec_tab l_tax_reg_rec_tab_typ;

Line 7406: UPDATE pos_party_tax_profile_int api

7402: ' request_id: ' || l_request_id);
7403:
7404: -- This update statement resets the unprocessed rows so
7405: -- that they get picked in the current run.
7406: UPDATE pos_party_tax_profile_int api
7407: SET request_id = NULL
7408: WHERE request_id IS NOT NULL
7409: AND batch_id = p_batch_id
7410: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')

Line 7438: UPDATE pos_party_tax_profile_int

7434: AND fcr.phase_code = 'C');
7435:
7436: -- Updating Interface Record with request id
7437:
7438: UPDATE pos_party_tax_profile_int
7439: SET request_id = l_request_id
7440: WHERE request_id IS NULL
7441: AND batch_id = p_batch_id
7442: AND nvl(status, 'ACTIVE') <> 'PROCESSED';

Line 7456: UPDATE pos_party_tax_profile_int supp

7452: WHERE request_id IS NULL
7453: AND batch_id = p_batch_id
7454: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
7455:
7456: UPDATE pos_party_tax_profile_int supp
7457: SET status = 'REMOVED',
7458: request_id = l_request_id
7459: WHERE batch_id = p_batch_id
7460: AND nvl(status, 'ACTIVE') <> 'PROCESSED'

Line 7473: ' records from table pos_party_tax_profile_int. Reason interface_status in hz_imp_parties_int = R');

7469:
7470: fnd_file.put_line(fnd_file.log,
7471: ' Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS' ||
7472: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
7473: ' records from table pos_party_tax_profile_int. Reason interface_status in hz_imp_parties_int = R');
7474:
7475: INSERT INTO pos_supplier_int_rejections
7476: (SELECT p_batch_id,
7477: l_request_id,

Line 7486: FROM pos_party_tax_profile_int

7482: SYSDATE,
7483: g_login_id,
7484: g_user_id,
7485: SYSDATE
7486: FROM pos_party_tax_profile_int
7487: WHERE status = 'REMOVED'
7488: AND request_id = l_request_id
7489: AND batch_id = p_batch_id);
7490:

Line 7623: UPDATE pos_party_tax_profile_int

7619: .tax_profile_interface_id
7620: AND batch_id = p_batch_id;
7621:
7622: IF (x_return_status = 'S') THEN
7623: UPDATE pos_party_tax_profile_int
7624: SET status = 'PROCESSED'
7625: WHERE tax_profile_interface_id = l_tax_profile_rec_tab(cntr)
7626: .tax_profile_interface_id
7627: AND batch_id = p_batch_id;

Line 7646: UPDATE pos_party_tax_profile_int

7642: WHERE batch_id = p_batch_id;
7643: END IF;
7644:
7645: ELSE
7646: UPDATE pos_party_tax_profile_int
7647: SET status = 'REJECTED'
7648: WHERE tax_profile_interface_id = l_tax_profile_rec_tab(cntr)
7649: .tax_profile_interface_id
7650: AND batch_id = p_batch_id;

Line 7656: 'POS_PARTY_TAX_PROFILE_INT',

7652: x_return_status := fnd_api.g_ret_sts_error;
7653:
7654: IF (insert_rejections(p_batch_id,
7655: l_request_id,
7656: 'POS_PARTY_TAX_PROFILE_INT',
7657: l_tax_profile_rec_tab(cntr)
7658: .tax_profile_interface_id,
7659: 'POS_TAX_PROFILE_CREATION',
7660: g_user_id,

Line 10454: FROM pos_party_tax_profile_int

10450: retcode := 1;
10451: ELSE
10452: SELECT COUNT(1)
10453: INTO l_error_count
10454: FROM pos_party_tax_profile_int
10455: WHERE batch_id = p_batch_id
10456: AND nvl(status, 'ACTIVE') = 'REJECTED'
10457: AND rownum = 1;
10458: