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.POS_BATCH_IMPORT_PKG dependencies on POS_FISCAL_CLASS_INT

Line 6973: p_fiscal_class_rec IN pos_fiscal_class_int%ROWTYPE,

6969:
6970: PROCEDURE validate_fiscal_classification
6971: (
6972: p_batch_id IN NUMBER,
6973: p_fiscal_class_rec IN pos_fiscal_class_int%ROWTYPE,
6974: x_return_status OUT NOCOPY VARCHAR2,
6975: x_msg_count OUT NOCOPY NUMBER,
6976: x_msg_data OUT NOCOPY VARCHAR2,
6977: x_valid OUT NOCOPY VARCHAR2,

Line 7018: 'POS_FISCAL_CLASS_INT',

7014: x_return_status := fnd_api.g_ret_sts_error;
7015: x_msg_data := 'POS_INVALID_FISCAL_CLASS_TYPE';
7016: IF (insert_rejections(p_batch_id,
7017: l_request_id,
7018: 'POS_FISCAL_CLASS_INT',
7019: p_fiscal_class_rec.classification_type_code_name,
7020: 'POS_INVALID_FISCAL_CLASS_TYPE',
7021: g_user_id,
7022: g_login_id,

Line 7062: 'POS_FISCAL_CLASS_INT',

7058: x_return_status := fnd_api.g_ret_sts_error;
7059: x_msg_data := 'POS_INVALID_FISCAL_CLASS_NAME';
7060: IF (insert_rejections(p_batch_id,
7061: l_request_id,
7062: 'POS_FISCAL_CLASS_INT',
7063: p_fiscal_class_rec.classification_type_code_name,
7064: 'POS_INVALID_FISCAL_CLASS_NAME',
7065: g_user_id,
7066: g_login_id,

Line 7098: p_fiscal_class_rec IN pos_fiscal_class_int%ROWTYPE,

7094:
7095: PROCEDURE create_fiscal_classification
7096: (
7097: p_batch_id IN NUMBER,
7098: p_fiscal_class_rec IN pos_fiscal_class_int%ROWTYPE,
7099: x_return_status OUT NOCOPY VARCHAR2,
7100: x_msg_count OUT NOCOPY NUMBER,
7101: x_msg_data OUT NOCOPY VARCHAR2
7102: ) IS

Line 7171: 'POS_FISCAL_CLASS_INT',

7167: -- Add the error buffer message to supplier rejections
7168: -- table
7169: /*IF (insert_rejections(p_batch_id,
7170: l_request_id,
7171: 'POS_FISCAL_CLASS_INT',
7172: p_tax_registration_rec.registration_type_code,
7173: 'AP_INVALID_TAX_REG_INS',
7174: g_user_id,
7175: g_login_id,

Line 7204: p_fiscal_class_rec IN pos_fiscal_class_int%ROWTYPE,

7200:
7201: PROCEDURE update_fiscal_classification
7202: (
7203: p_batch_id IN NUMBER,
7204: p_fiscal_class_rec IN pos_fiscal_class_int%ROWTYPE,
7205: x_return_status OUT NOCOPY VARCHAR2,
7206: x_msg_count OUT NOCOPY NUMBER,
7207: x_msg_data OUT NOCOPY VARCHAR2
7208: ) IS

Line 7291: 'POS_FISCAL_CLASS_INT',

7287: -- Add the error buffer message to supplier rejections
7288: -- table
7289: /*IF (insert_rejections(p_batch_id,
7290: l_request_id,
7291: 'POS_FISCAL_CLASS_INT',
7292: p_tax_registration_rec.registration_type_code,
7293: 'AP_INVALID_TAX_REG_INS',
7294: g_user_id,
7295: g_login_id,

Line 7368: FROM pos_fiscal_class_int supp

7364: AND party.interface_status = 'R');
7365:
7366: CURSOR fiscal_class_cur IS
7367: SELECT *
7368: FROM pos_fiscal_class_int supp
7369: WHERE batch_id = p_batch_id
7370: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
7371: AND NOT EXISTS
7372: (SELECT 1

Line 7393: TYPE l_fiscal_class_rec_tab_typ IS TABLE OF pos_fiscal_class_int%ROWTYPE;

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;
7392:
7393: TYPE l_fiscal_class_rec_tab_typ IS TABLE OF pos_fiscal_class_int%ROWTYPE;
7394: l_fiscal_class_rec_tab l_fiscal_class_rec_tab_typ;
7395:
7396: BEGIN
7397: x_return_status := fnd_api.g_ret_sts_success;

Line 7426: UPDATE pos_fiscal_class_int api

7422: FROM fnd_concurrent_requests fcr
7423: WHERE fcr.request_id = api.request_id
7424: AND fcr.phase_code = 'C');
7425:
7426: UPDATE pos_fiscal_class_int api
7427: SET request_id = NULL
7428: WHERE request_id IS NOT NULL
7429: AND batch_id = p_batch_id
7430: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')

Line 7450: UPDATE pos_fiscal_class_int

7446: WHERE request_id IS NULL
7447: AND batch_id = p_batch_id
7448: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
7449:
7450: UPDATE pos_fiscal_class_int
7451: SET request_id = l_request_id
7452: WHERE request_id IS NULL
7453: AND batch_id = p_batch_id
7454: AND nvl(status, 'ACTIVE') <> 'PROCESSED';

Line 7526: UPDATE pos_fiscal_class_int supp

7522: WHERE status = 'REMOVED'
7523: AND request_id = l_request_id
7524: AND batch_id = p_batch_id);
7525:
7526: UPDATE pos_fiscal_class_int supp
7527: SET status = 'REMOVED',
7528: request_id = l_request_id
7529: WHERE batch_id = p_batch_id
7530: AND nvl(status, 'ACTIVE') <> 'PROCESSED'

Line 7543: ' records from table pos_fiscal_class_int. Reason interface_status in hz_imp_parties_int = R');

7539:
7540: fnd_file.put_line(fnd_file.log,
7541: ' Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS' ||
7542: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
7543: ' records from table pos_fiscal_class_int. Reason interface_status in hz_imp_parties_int = R');
7544:
7545: INSERT INTO pos_supplier_int_rejections
7546: (SELECT p_batch_id,
7547: l_request_id,

Line 7556: FROM pos_fiscal_class_int

7552: SYSDATE,
7553: g_login_id,
7554: g_user_id,
7555: SYSDATE
7556: FROM pos_fiscal_class_int
7557: WHERE status = 'REMOVED'
7558: AND request_id = l_request_id
7559: AND batch_id = p_batch_id);
7560:

Line 7616: UPDATE pos_fiscal_class_int

7612: .tax_profile_interface_id
7613: AND batch_id = p_batch_id;
7614:
7615: -- Tax Profile Id in the Fiscal Classifications Interface table
7616: UPDATE pos_fiscal_class_int
7617: SET tax_profile_id = l_tax_profile_id
7618: WHERE tax_profile_interface_id = l_tax_profile_rec_tab(cntr)
7619: .tax_profile_interface_id
7620: AND batch_id = p_batch_id;

Line 7881: UPDATE pos_fiscal_class_int

7877:
7878: l_fiscal_class_rec_tab(cntr).tax_profile_id := l_tax_profile_id;
7879: EXCEPTION
7880: WHEN no_data_found THEN
7881: UPDATE pos_fiscal_class_int
7882: SET status = 'REJECTED'
7883: WHERE fiscal_class_interface_id = l_fiscal_class_rec_tab(cntr)
7884: .fiscal_class_interface_id
7885: AND batch_id = p_batch_id;

Line 7889: 'POS_FISCAL_CLASS_INT',

7885: AND batch_id = p_batch_id;
7886:
7887: IF (insert_rejections(p_batch_id,
7888: l_request_id,
7889: 'POS_FISCAL_CLASS_INT',
7890: l_fiscal_class_rec_tab(cntr)
7891: .fiscal_class_interface_id,
7892: 'POS_INVALID_TAX_PROFILE',
7893: g_user_id,

Line 7955: UPDATE pos_fiscal_class_int

7951: x_msg_count => x_msg_count,
7952: x_msg_data => x_msg_data);
7953:
7954: IF (x_return_status = 'S') THEN
7955: UPDATE pos_fiscal_class_int
7956: SET status = 'PROCESSED'
7957: WHERE fiscal_class_interface_id = l_fiscal_class_rec_tab(cntr)
7958: .fiscal_class_interface_id
7959: AND batch_id = p_batch_id;

Line 7975: UPDATE pos_fiscal_class_int

7971: x_return_status => x_return_status,
7972: x_msg_count => x_msg_count,
7973: x_msg_data => x_msg_data);
7974: IF (x_return_status = 'S') THEN
7975: UPDATE pos_fiscal_class_int
7976: SET status = 'PROCESSED'
7977: WHERE fiscal_class_interface_id = l_fiscal_class_rec_tab(cntr)
7978: .fiscal_class_interface_id
7979: AND batch_id = p_batch_id;

Line 7992: UPDATE pos_fiscal_class_int

7988:
7989: END IF;
7990:
7991: IF (x_return_status <> 'S') THEN
7992: UPDATE pos_fiscal_class_int
7993: SET status = 'REJECTED'
7994: WHERE fiscal_class_interface_id = l_fiscal_class_rec_tab(cntr)
7995: .fiscal_class_interface_id
7996: AND batch_id = p_batch_id;

Line 8002: 'POS_FISCAL_CLASS_INT',

7998: x_return_status := fnd_api.g_ret_sts_error;
7999:
8000: IF (insert_rejections(p_batch_id,
8001: l_request_id,
8002: 'POS_FISCAL_CLASS_INT',
8003: l_fiscal_class_rec_tab(cntr)
8004: .fiscal_class_interface_id,
8005: 'POS_FISCAL_CLASS_CREATION',
8006: g_user_id,

Line 10472: FROM pos_fiscal_class_int

10468: l_tot_err_count := l_tot_err_count + l_error_count;
10469:
10470: SELECT COUNT(1)
10471: INTO l_error_count
10472: FROM pos_fiscal_class_int
10473: WHERE batch_id = p_batch_id
10474: AND nvl(status, 'ACTIVE') = 'REJECTED'
10475: AND rownum = 1;
10476: