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

Line 1: PACKAGE BODY FTE_PROCESS_REQUESTS AS

1: PACKAGE BODY FTE_PROCESS_REQUESTS AS
2: /* $Header: FTEPRREB.pls 120.4 2007/01/03 19:46:57 parkhj noship $ */
3:
4: Type TableVarchar2000 IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
5:

Line 7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_PROCESS_REQUESTS';

3:
4: Type TableVarchar2000 IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
5:
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_PROCESS_REQUESTS';
8: --
9:
10: g_object_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
11:

Line 19: -- FTE_PROCESS_REQUESTS.fte_source_line_tab --

15: -- TYPE: PROCEDURE --
16: -- --
17: -- PARAMETERS (IN): p_consolidation_id IN NUMBER --
18: -- p_source_line_tab IN --
19: -- FTE_PROCESS_REQUESTS.fte_source_line_tab --
20: -- x_customer_site_id OUT NOCOPY --
21: -- NUMBER --
22: -- x_return_status OUT NOCOPY VARCHAR2 --
23: -- --

Line 29: p_source_line_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,

25: -- given pseudo delivery(p_consolidation_id). --
26: -- -------------------------------------------------------------------------- --
27:
28: PROCEDURE get_customer_site( p_consolidation_id IN NUMBER,
29: p_source_line_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
30: x_customer_site_id OUT NOCOPY NUMBER,
31: x_return_status OUT NOCOPY VARCHAR2)
32: IS
33:

Line 236: -- FTE_PROCESS_REQUESTS.fte_source_header_tab --

232: -- NAME: FORMAT_CS_CALL --
233: -- TYPE: PROCEDURE --
234: -- --
235: -- PARAMETERS (IN): p_source_header_tab IN OUT NOCOPY --
236: -- FTE_PROCESS_REQUESTS.fte_source_header_tab --
237: -- p_source_line_tab IN OUT NOCOPY --
238: -- FTE_PROCESS_REQUESTS.fte_source_line_tab --
239: -- x_result_tab OUT NOCOPY --
240: -- FTE_ACS_PKG.fte_cs_result_rec_type --

Line 238: -- FTE_PROCESS_REQUESTS.fte_source_line_tab --

234: -- --
235: -- PARAMETERS (IN): p_source_header_tab IN OUT NOCOPY --
236: -- FTE_PROCESS_REQUESTS.fte_source_header_tab --
237: -- p_source_line_tab IN OUT NOCOPY --
238: -- FTE_PROCESS_REQUESTS.fte_source_line_tab --
239: -- x_result_tab OUT NOCOPY --
240: -- FTE_ACS_PKG.fte_cs_result_rec_type --
241: -- x_return_message OUT VARCHAR2 --
242: -- x_return_status OUT VARCHAR2 --

Line 261: PROCEDURE FORMAT_CS_CALL( p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,

257: -- ---------- ------- -------- ------- ---------------------------------- --
258: -- --
259: -- --
260: -- -------------------------------------------------------------------------- --
261: PROCEDURE FORMAT_CS_CALL( p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
262: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
263: x_result_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_result_tab_type,
264: x_return_message OUT NOCOPY VARCHAR2,
265: x_return_status OUT NOCOPY VARCHAR2) IS

Line 262: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,

258: -- --
259: -- --
260: -- -------------------------------------------------------------------------- --
261: PROCEDURE FORMAT_CS_CALL( p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
262: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
263: x_result_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_result_tab_type,
264: x_return_message OUT NOCOPY VARCHAR2,
265: x_return_status OUT NOCOPY VARCHAR2) IS
266:

Line 442: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_PROCESS_REQUESTS.FORMAT_CS_CALL IS ' ||L_ERROR_TEXT );

438: --
439: -- Debug Statements
440: --
441: IF l_debug_on THEN
442: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_PROCESS_REQUESTS.FORMAT_CS_CALL IS ' ||L_ERROR_TEXT );
443: END IF;
444: --
445:
446: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUESTS.FORMAT_CS_CALL');

Line 446: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUESTS.FORMAT_CS_CALL');

442: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_PROCESS_REQUESTS.FORMAT_CS_CALL IS ' ||L_ERROR_TEXT );
443: END IF;
444: --
445:
446: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUESTS.FORMAT_CS_CALL');
447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
448: x_return_message := l_error_text;
449: --
450: -- Debug Statements

Line 476: -- FTE_PROCESS_REQUESTS.fte_source_line_tab --

472: -- TYPE: PROCEDURE --
473: -- --
474: -- PARAMETERS (IN): --
475: -- p_source_line_tab IN OUT NOCOPY --
476: -- FTE_PROCESS_REQUESTS.fte_source_line_tab --
477: -- p_source_header_tab IN OUT NOCOPY --
478: -- FTE_PROCESS_REQUESTS.fte_source_header_tab --
479: -- p_source_type IN --
480: -- VARCHAR2 --

Line 478: -- FTE_PROCESS_REQUESTS.fte_source_header_tab --

474: -- PARAMETERS (IN): --
475: -- p_source_line_tab IN OUT NOCOPY --
476: -- FTE_PROCESS_REQUESTS.fte_source_line_tab --
477: -- p_source_header_tab IN OUT NOCOPY --
478: -- FTE_PROCESS_REQUESTS.fte_source_header_tab --
479: -- p_source_type IN --
480: -- VARCHAR2 --
481: -- p_action IN --
482: -- VARCHAR2 --

Line 484: -- FTE_PROCESS_REQUESTS.fte_source_line_rates_tab --

480: -- VARCHAR2 --
481: -- p_action IN --
482: -- VARCHAR2 --
483: -- x_source_line_rates_tab OUT NOCOPY --
484: -- FTE_PROCESS_REQUESTS.fte_source_line_rates_tab --
485: -- x_source_header_rates_tab OUT NOCOPY --
486: -- FTE_PROCESS_REQUESTS.fte_source_header_rates_tab--
487: -- x_return_status OUT NOCOPY --
488: -- VARCHAR2 --

Line 486: -- FTE_PROCESS_REQUESTS.fte_source_header_rates_tab--

482: -- VARCHAR2 --
483: -- x_source_line_rates_tab OUT NOCOPY --
484: -- FTE_PROCESS_REQUESTS.fte_source_line_rates_tab --
485: -- x_source_header_rates_tab OUT NOCOPY --
486: -- FTE_PROCESS_REQUESTS.fte_source_header_rates_tab--
487: -- x_return_status OUT NOCOPY --
488: -- VARCHAR2 --
489: -- x_msg_count OUT NOCOPY --
490: -- NUMBER --

Line 511: PROCEDURE Process_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,

507: -- 2003/06/01 Pack J, xizhang added action GET_GROUP and GET_RATE_CHOICE --
508: -- added OUT parameter x_source_header_rates_tab --
509: -- --
510: -- -------------------------------------------------------------------------- --
511: PROCEDURE Process_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
512: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
513: p_source_type IN VARCHAR2,
514: p_action IN VARCHAR2,
515: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

Line 512: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,

508: -- added OUT parameter x_source_header_rates_tab --
509: -- --
510: -- -------------------------------------------------------------------------- --
511: PROCEDURE Process_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
512: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
513: p_source_type IN VARCHAR2,
514: p_action IN VARCHAR2,
515: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
516: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

Line 515: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

511: PROCEDURE Process_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
512: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
513: p_source_type IN VARCHAR2,
514: p_action IN VARCHAR2,
515: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
516: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
519: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 516: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

512: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
513: p_source_type IN VARCHAR2,
514: p_action IN VARCHAR2,
515: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
516: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
519: x_msg_data OUT NOCOPY VARCHAR2) IS
520:

Line 533: l_source_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;

529:
530: l_con_id PLS_INTEGER;
531: l_no_results VARCHAR2(1) := 'Y';
532:
533: l_source_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
534: l_source_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
535: l_request_id NUMBER;
536:
537: l_status VARCHAR2(1);

Line 534: l_source_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;

530: l_con_id PLS_INTEGER;
531: l_no_results VARCHAR2(1) := 'Y';
532:
533: l_source_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
534: l_source_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
535: l_request_id NUMBER;
536:
537: l_status VARCHAR2(1);
538: l_msg_count NUMBER := 0;

Line 1499: PROCEDURE Process_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,

1495:
1496: -- FOR BACKWARD (I) COMPATIBILITY ONLY
1497: -- THE FOLLOWING BODY IS STUBBED OUT IN THIS BRANCH
1498:
1499: PROCEDURE Process_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1500: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1501: p_source_type IN VARCHAR2,
1502: p_action IN VARCHAR2,
1503: p_rating_parameters_tab IN FTE_PROCESS_REQUESTS.fte_rating_parameters_tab DEFAULT FTE_MISS_RATING_PARAMETERS_TAB,

Line 1500: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,

1496: -- FOR BACKWARD (I) COMPATIBILITY ONLY
1497: -- THE FOLLOWING BODY IS STUBBED OUT IN THIS BRANCH
1498:
1499: PROCEDURE Process_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1500: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1501: p_source_type IN VARCHAR2,
1502: p_action IN VARCHAR2,
1503: p_rating_parameters_tab IN FTE_PROCESS_REQUESTS.fte_rating_parameters_tab DEFAULT FTE_MISS_RATING_PARAMETERS_TAB,
1504: p_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

Line 1503: p_rating_parameters_tab IN FTE_PROCESS_REQUESTS.fte_rating_parameters_tab DEFAULT FTE_MISS_RATING_PARAMETERS_TAB,

1499: PROCEDURE Process_Lines(p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1500: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1501: p_source_type IN VARCHAR2,
1502: p_action IN VARCHAR2,
1503: p_rating_parameters_tab IN FTE_PROCESS_REQUESTS.fte_rating_parameters_tab DEFAULT FTE_MISS_RATING_PARAMETERS_TAB,
1504: p_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1505: x_return_status OUT NOCOPY VARCHAR2,
1506: x_msg_count OUT NOCOPY NUMBER,
1507: x_msg_data OUT NOCOPY VARCHAR2)

Line 1504: p_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

1500: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1501: p_source_type IN VARCHAR2,
1502: p_action IN VARCHAR2,
1503: p_rating_parameters_tab IN FTE_PROCESS_REQUESTS.fte_rating_parameters_tab DEFAULT FTE_MISS_RATING_PARAMETERS_TAB,
1504: p_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1505: x_return_status OUT NOCOPY VARCHAR2,
1506: x_msg_count OUT NOCOPY NUMBER,
1507: x_msg_data OUT NOCOPY VARCHAR2)
1508: IS

Line 1514: END FTE_PROCESS_REQUESTS;

1510: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1511: END Process_Lines;
1512:
1513:
1514: END FTE_PROCESS_REQUESTS;