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.OZF_SD_REQUEST_PUB dependencies on OZF_SD_REQUEST_PUB

Line 1: PACKAGE BODY OZF_SD_REQUEST_PUB AS

1: PACKAGE BODY OZF_SD_REQUEST_PUB AS
2: /* $Header: ozfpsdrb.pls 120.14.12010000.10 2009/02/04 09:22:57 bkunjan ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_SD_REQUEST_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(14) := 'ozfpsdrb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_SD_REQUEST_PUB';

1: PACKAGE BODY OZF_SD_REQUEST_PUB AS
2: /* $Header: ozfpsdrb.pls 120.14.12010000.10 2009/02/04 09:22:57 bkunjan ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_SD_REQUEST_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(14) := 'ozfpsdrb.pls';
6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7: G_ITEM_ORG_ID NUMBER;
8: G_REQUEST_HEADER_ID NUMBER;

Line 1034: l_old_product_lines OZF_SD_REQUEST_PUB.SDR_lines_rec_type;

1030: l_item_uom VARCHAR2(30);
1031: l_status_code VARCHAR2(30);
1032: l_external_code VARCHAR2(240);
1033: l_internal_code NUMBER;
1034: l_old_product_lines OZF_SD_REQUEST_PUB.SDR_lines_rec_type;
1035:
1036: CURSOR c_master_org_id(p_header_org_id IN NUMBER)IS
1037: SELECT master_organization_id
1038: FROM oe_system_parameters

Line 1828: l_old_cust_details OZF_SD_REQUEST_PUB.SDR_cust_rec_type;

1824: l_request_customer_id NUMBER;
1825: l_cust_account_id NUMBER;
1826: l_party_id NUMBER;
1827: l_site_use_id NUMBER;
1828: l_old_cust_details OZF_SD_REQUEST_PUB.SDR_cust_rec_type;
1829:
1830:
1831: CURSOR c_request_customer_id(p_request_customer_id IN NUMBER,p_request_header_id IN NUMBER)IS
1832: SELECT request_customer_id

Line 2139: l_SDR_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;

2135: ,x_request_header_id OUT NOCOPY NUMBER
2136: ,x_return_status OUT NOCOPY VARCHAR2)
2137: IS
2138:
2139: l_SDR_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;
2140: l_req_hdr_seq NUMBER;
2141: l_code_prefix VARCHAR2(3);
2142: l_request_class VARCHAR2(30):='SD_REQUEST';
2143: --l_request_source VARCHAR2(30) :='API';

Line 2857: l_SDR_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;

2853: IS
2854: l_api_name CONSTANT VARCHAR2(30) := 'Create_sd_request';
2855: l_api_version_number CONSTANT NUMBER := 1.0;
2856:
2857: l_SDR_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;
2858: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type := p_SDR_lines_tbl;
2859: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type := p_SDR_cust_tbl;
2860:
2861: l_line_rec_flag VARCHAR2(1):='N';

Line 2858: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type := p_SDR_lines_tbl;

2854: l_api_name CONSTANT VARCHAR2(30) := 'Create_sd_request';
2855: l_api_version_number CONSTANT NUMBER := 1.0;
2856:
2857: l_SDR_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;
2858: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type := p_SDR_lines_tbl;
2859: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type := p_SDR_cust_tbl;
2860:
2861: l_line_rec_flag VARCHAR2(1):='N';
2862: l_cust_rec_flag VARCHAR2(1):='N';

Line 2859: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type := p_SDR_cust_tbl;

2855: l_api_version_number CONSTANT NUMBER := 1.0;
2856:
2857: l_SDR_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;
2858: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type := p_SDR_lines_tbl;
2859: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type := p_SDR_cust_tbl;
2860:
2861: l_line_rec_flag VARCHAR2(1):='N';
2862: l_cust_rec_flag VARCHAR2(1):='N';
2863: l_user_id NUMBER;

Line 3293: l_new_sdr_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;

3289: IS
3290: l_api_name CONSTANT VARCHAR2(30) := 'Update_sd_request';
3291: l_api_version_number CONSTANT NUMBER := 1.0;
3292:
3293: l_new_sdr_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;
3294: l_old_sdr_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
3295: l_new_sdr_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type := p_SDR_lines_tbl;
3296: l_new_sdr_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type := p_SDR_cust_tbl;
3297:

Line 3294: l_old_sdr_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;

3290: l_api_name CONSTANT VARCHAR2(30) := 'Update_sd_request';
3291: l_api_version_number CONSTANT NUMBER := 1.0;
3292:
3293: l_new_sdr_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;
3294: l_old_sdr_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
3295: l_new_sdr_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type := p_SDR_lines_tbl;
3296: l_new_sdr_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type := p_SDR_cust_tbl;
3297:
3298: l_internal_flag VARCHAR2(1);

Line 3295: l_new_sdr_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type := p_SDR_lines_tbl;

3291: l_api_version_number CONSTANT NUMBER := 1.0;
3292:
3293: l_new_sdr_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;
3294: l_old_sdr_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
3295: l_new_sdr_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type := p_SDR_lines_tbl;
3296: l_new_sdr_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type := p_SDR_cust_tbl;
3297:
3298: l_internal_flag VARCHAR2(1);
3299: l_external_flag VARCHAR2(1);

Line 3296: l_new_sdr_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type := p_SDR_cust_tbl;

3292:
3293: l_new_sdr_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type := p_SDR_hdr_rec;
3294: l_old_sdr_hdr_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
3295: l_new_sdr_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type := p_SDR_lines_tbl;
3296: l_new_sdr_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type := p_SDR_cust_tbl;
3297:
3298: l_internal_flag VARCHAR2(1);
3299: l_external_flag VARCHAR2(1);
3300: l_admin_flag VARCHAR2(1);

Line 4404: l_sdr_source_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;

4400: IS
4401:
4402: l_api_name CONSTANT VARCHAR2(30) := 'copy_sd_request';
4403: l_api_version_number CONSTANT NUMBER := 1.0;
4404: l_sdr_source_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
4405: l_sd_access_rec OZF_APPROVAL_PVT.sd_access_rec_type;
4406: l_sdr_source_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
4407: l_sdr_source_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;
4408:

Line 4406: l_sdr_source_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;

4402: l_api_name CONSTANT VARCHAR2(30) := 'copy_sd_request';
4403: l_api_version_number CONSTANT NUMBER := 1.0;
4404: l_sdr_source_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
4405: l_sd_access_rec OZF_APPROVAL_PVT.sd_access_rec_type;
4406: l_sdr_source_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
4407: l_sdr_source_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;
4408:
4409: l_lookup_stat VARCHAR2(1); --To validate from lookups
4410: l_source_rid NUMBER;

Line 4407: l_sdr_source_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;

4403: l_api_version_number CONSTANT NUMBER := 1.0;
4404: l_sdr_source_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
4405: l_sd_access_rec OZF_APPROVAL_PVT.sd_access_rec_type;
4406: l_sdr_source_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
4407: l_sdr_source_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;
4408:
4409: l_lookup_stat VARCHAR2(1); --To validate from lookups
4410: l_source_rid NUMBER;
4411: l_new_req_no VARCHAR2(30);

Line 5177: END OZF_SD_REQUEST_PUB;

5173: p_count => x_msg_count,
5174: p_data => x_msg_data
5175: );
5176: END copy_sd_request;
5177: END OZF_SD_REQUEST_PUB;