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_BUSINESS_CLASS_INT

Line 1717: UPDATE pos_business_class_int

1713: SET vendor_id = l_vendor_id
1714: WHERE vendor_interface_id = p_vendor_rec.vendor_interface_id
1715: AND sdh_batch_id = p_batch_id;
1716:
1717: UPDATE pos_business_class_int
1718: SET vendor_id = l_vendor_id
1719: WHERE vendor_interface_id = p_vendor_rec.vendor_interface_id
1720: AND sdh_batch_id = p_batch_id;
1721:

Line 5327: p_vendor_buss_class_rec IN pos_business_class_int%ROWTYPE,

5323:
5324: PROCEDURE validate_vendor_buss_class
5325: (
5326: p_batch_id IN NUMBER,
5327: p_vendor_buss_class_rec IN pos_business_class_int%ROWTYPE,
5328: p_party_id IN hz_parties.party_id%TYPE,
5329: x_return_status OUT NOCOPY VARCHAR2,
5330: x_msg_count OUT NOCOPY NUMBER,
5331: x_msg_data OUT NOCOPY VARCHAR2,

Line 5373: 'POS_BUSINESS_CLASS_INT',

5369: x_return_status := fnd_api.g_ret_sts_error;
5370: x_msg_data := 'POS_INVALID_LOOKUP_CODE';
5371: IF (insert_rejections(p_batch_id,
5372: l_request_id,
5373: 'POS_BUSINESS_CLASS_INT',
5374: p_vendor_buss_class_rec.business_class_interface_id,
5375: 'POS_INVALID_LOOKUP_CODE',
5376: g_user_id,
5377: g_login_id,

Line 5418: 'POS_BUSINESS_CLASS_INT',

5414: x_return_status := fnd_api.g_ret_sts_error;
5415: x_msg_data := 'POS_INVALID_MINOR_LOOKUP_CODE';
5416: IF (insert_rejections(p_batch_id,
5417: l_request_id,
5418: 'POS_BUSINESS_CLASS_INT',
5419: p_vendor_buss_class_rec.business_class_interface_id,
5420: 'POS_INVALID_MINOR_LOOKUP_CODE',
5421: g_user_id,
5422: g_login_id,

Line 5458: p_vendor_buss_class_rec IN pos_business_class_int%ROWTYPE,

5454:
5455: PROCEDURE create_vendor_buss_class
5456: (
5457: p_batch_id IN NUMBER,
5458: p_vendor_buss_class_rec IN pos_business_class_int%ROWTYPE,
5459: p_party_id IN hz_parties.party_id%TYPE,
5460: x_return_status OUT NOCOPY VARCHAR2,
5461: x_msg_count OUT NOCOPY NUMBER,
5462: x_msg_data OUT NOCOPY VARCHAR2

Line 5567: FROM pos_business_class_int supp

5563: l_out_buss_class_req_id NUMBER;
5564:
5565: CURSOR vendor_int_buss_class_cur IS
5566: SELECT *
5567: FROM pos_business_class_int supp
5568: WHERE import_request_id = l_request_id
5569: AND business_class_interface_id IS NOT NULL
5570: AND sdh_batch_id = p_batch_id
5571: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')

Line 5583: vendor_buss_class_rec pos_business_class_int%ROWTYPE;

5579: party.party_orig_system_reference
5580: AND party.interface_status = 'R');
5581:
5582: vendor_int_buss_class_rec vendor_int_buss_class_cur%ROWTYPE;
5583: vendor_buss_class_rec pos_business_class_int%ROWTYPE;
5584: BEGIN
5585: -- Initialize API return status to success
5586: x_return_status := fnd_api.g_ret_sts_success;
5587:

Line 5595: UPDATE pos_business_class_int api

5591: ' request_id: ' || l_request_id);
5592:
5593: -- This update statement resets the unprocessed rows so
5594: -- that they get picked in the current run.
5595: UPDATE pos_business_class_int api
5596: SET import_request_id = NULL
5597: WHERE import_request_id IS NOT NULL
5598: AND sdh_batch_id = p_batch_id
5599: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')

Line 5607: UPDATE pos_business_class_int

5603: AND fcr.phase_code = 'C');
5604:
5605: -- Updating Interface Record with request id
5606:
5607: UPDATE pos_business_class_int
5608: SET import_request_id = l_request_id
5609: WHERE import_request_id IS NULL
5610: AND sdh_batch_id = p_batch_id
5611: AND nvl(status, 'ACTIVE') <> 'PROCESSED';

Line 5613: UPDATE pos_business_class_int supp

5609: WHERE import_request_id IS NULL
5610: AND sdh_batch_id = p_batch_id
5611: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
5612:
5613: UPDATE pos_business_class_int supp
5614: SET status = 'REMOVED',
5615: import_request_id = l_request_id
5616: WHERE sdh_batch_id = p_batch_id
5617: AND nvl(status, 'ACTIVE') <> 'PROCESSED'

Line 5635: 'POS_BUSINESS_CLASS_INT',

5631:
5632: INSERT INTO pos_supplier_int_rejections
5633: (SELECT p_batch_id,
5634: l_request_id,
5635: 'POS_BUSINESS_CLASS_INT',
5636: business_class_interface_id,
5637: 'POS_INVALID_PARTY_ORIG_SYSTEM',
5638: g_user_id,
5639: SYSDATE,

Line 5643: FROM pos_business_class_int

5639: SYSDATE,
5640: g_login_id,
5641: g_user_id,
5642: SYSDATE
5643: FROM pos_business_class_int
5644: WHERE status = 'REMOVED'
5645: AND import_request_id = l_request_id
5646: AND sdh_batch_id = p_batch_id);
5647:

Line 5698: UPDATE pos_business_class_int

5694: WHERE supp.party_id = l_party_id;
5695:
5696: EXCEPTION
5697: WHEN OTHERS THEN
5698: UPDATE pos_business_class_int
5699: SET status = 'REJECTED'
5700: WHERE business_class_interface_id =
5701: vendor_int_buss_class_rec.business_class_interface_id
5702: AND sdh_batch_id = p_batch_id;

Line 5706: 'POS_BUSINESS_CLASS_INT',

5702: AND sdh_batch_id = p_batch_id;
5703:
5704: IF (insert_rejections(p_batch_id,
5705: l_request_id,
5706: 'POS_BUSINESS_CLASS_INT',
5707: vendor_int_buss_class_rec.business_class_interface_id,
5708: 'AP_VENDOR_ID_NULL',
5709: g_user_id,
5710: g_login_id,

Line 5801: UPDATE pos_business_class_int

5797: x_msg_count => l_msg_count,
5798: x_msg_data => l_msg_data);
5799:
5800: IF l_return_status = fnd_api.g_ret_sts_success THEN
5801: UPDATE pos_business_class_int
5802: SET status = 'PROCESSED'
5803: WHERE business_class_interface_id =
5804: vendor_int_buss_class_rec.business_class_interface_id
5805: AND sdh_batch_id = p_batch_id;

Line 5815: UPDATE pos_business_class_int

5811: buss_class_imported = buss_class_imported + 1
5812: WHERE batch_id = p_batch_id;
5813:
5814: ELSE
5815: UPDATE pos_business_class_int
5816: SET status = 'REJECTED'
5817: WHERE business_class_interface_id =
5818: vendor_int_buss_class_rec.business_class_interface_id
5819: AND sdh_batch_id = p_batch_id;

Line 5825: 'POS_BUSINESS_CLASS_INT',

5821: x_return_status := l_return_status;
5822:
5823: IF (insert_rejections(p_batch_id,
5824: l_request_id,
5825: 'POS_BUSINESS_CLASS_INT',
5826: vendor_int_buss_class_rec.business_class_interface_id,
5827: 'POS_BUSS_CLASS_CREATION',
5828: g_user_id,
5829: g_login_id,

Line 5874: UPDATE pos_business_class_int

5870: vendor_buss_class_rec.vendor_id);
5871: END;
5872:
5873: IF l_return_status = fnd_api.g_ret_sts_success THEN
5874: UPDATE pos_business_class_int
5875: SET status = 'PROCESSED'
5876: WHERE business_class_interface_id =
5877: vendor_int_buss_class_rec.business_class_interface_id
5878: AND sdh_batch_id = p_batch_id;

Line 5888: UPDATE pos_business_class_int

5884: buss_class_imported = buss_class_imported + 1
5885: WHERE batch_id = p_batch_id;
5886:
5887: ELSE
5888: UPDATE pos_business_class_int
5889: SET status = 'REJECTED'
5890: WHERE business_class_interface_id =
5891: vendor_int_buss_class_rec.business_class_interface_id
5892: AND sdh_batch_id = p_batch_id;

Line 5898: 'POS_BUSINESS_CLASS_INT',

5894: x_return_status := l_return_status;
5895:
5896: IF (insert_rejections(p_batch_id,
5897: l_request_id,
5898: 'POS_BUSINESS_CLASS_INT',
5899: vendor_int_buss_class_rec.business_class_interface_id,
5900: 'POS_BUSS_CLASS_UPDATION',
5901: g_user_id,
5902: g_login_id,

Line 10430: FROM pos_business_class_int

10426: retcode := 1;
10427: ELSE
10428: SELECT COUNT(1)
10429: INTO l_error_count
10430: FROM pos_business_class_int
10431: WHERE sdh_batch_id = p_batch_id
10432: AND nvl(status, 'ACTIVE') = 'REJECTED'
10433: AND rownum = 1;
10434: