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_RATE_CHART_PKG dependencies on STRINGARRAY

Line 160: l_faccodes STRINGARRAY;

156: CURSOR facility_codes IS
157: SELECT facility_code FROM fte_location_parameters
158: WHERE modifier_list = p_pricelist_id;
159:
160: l_faccodes STRINGARRAY;
161: i NUMBER;
162:
163: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.CHECK_FACILITIES';
164:

Line 184: p_tokens => STRINGARRAY('CODE'),

180: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RC_ASSIGNED_TO_FC');
181: FOR j IN 1..l_faccodes.COUNT LOOP
182: x_error_msg := x_error_msg || ' '||
183: FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_FACILITY_CODE',
184: p_tokens => STRINGARRAY('CODE'),
185: p_values => STRINGARRAY(l_faccodes(j)));
186: END LOOP;
187: x_status := 2;
188:

Line 185: p_values => STRINGARRAY(l_faccodes(j)));

181: FOR j IN 1..l_faccodes.COUNT LOOP
182: x_error_msg := x_error_msg || ' '||
183: FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_FACILITY_CODE',
184: p_tokens => STRINGARRAY('CODE'),
185: p_values => STRINGARRAY(l_faccodes(j)));
186: END LOOP;
187: x_status := 2;
188:
189: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 298: x_error_msg OUT NOCOPY VARCHAR2) RETURN STRINGARRAY IS

294:
295: FUNCTION GET_RATE_CHART_INFO(p_name IN VARCHAR2,
296: p_carrier_id IN NUMBER,
297: x_status OUT NOCOPY NUMBER,
298: x_error_msg OUT NOCOPY VARCHAR2) RETURN STRINGARRAY IS
299:
300: l_result STRINGARRAY;
301: l_list_header_id qp_list_headers_b.list_header_id%TYPE;
302: l_name qp_list_headers_tl.name%TYPE;

Line 300: l_result STRINGARRAY;

296: p_carrier_id IN NUMBER,
297: x_status OUT NOCOPY NUMBER,
298: x_error_msg OUT NOCOPY VARCHAR2) RETURN STRINGARRAY IS
299:
300: l_result STRINGARRAY;
301: l_list_header_id qp_list_headers_b.list_header_id%TYPE;
302: l_name qp_list_headers_tl.name%TYPE;
303: l_start_date VARCHAR2(50);
304: l_end_date VARCHAR2(50);

Line 331: l_result := STRINGARRAY(l_list_header_id, l_start_date, l_end_date);

327: OPEN GET_CHART_INFO(p_name, p_carrier_id);
328: FETCH GET_CHART_INFO INTO l_list_header_id, l_name, l_start_date, l_end_date;
329:
330: IF (GET_CHART_INFO%ROWCOUNT > 0) THEN
331: l_result := STRINGARRAY(l_list_header_id, l_start_date, l_end_date);
332: END IF;
333:
334: CLOSE GET_CHART_INFO;
335:

Line 387: l_tokens STRINGARRAY := STRINGARRAY();

383:
384: l_list_header_id NUMBER;
385: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.DELETE_FROM_QP';
386: l_attribute1 VARCHAR2(50);
387: l_tokens STRINGARRAY := STRINGARRAY();
388:
389: BEGIN
390: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
391:

Line 406: p_tokens => STRINGARRAY('NAME'),

402: p_carrier_id => NULL,
403: p_attribute1 => l_attribute1);
404: IF (l_list_header_id = -1) THEN
405: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
406: p_tokens => STRINGARRAY('NAME'),
407: p_values => STRINGARRAY(p_name));
408:
409: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
410: p_msg => x_error_msg,

Line 407: p_values => STRINGARRAY(p_name));

403: p_attribute1 => l_attribute1);
404: IF (l_list_header_id = -1) THEN
405: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
406: p_tokens => STRINGARRAY('NAME'),
407: p_values => STRINGARRAY(p_name));
408:
409: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
410: p_msg => x_error_msg,
411: p_category => 'C',

Line 465: p_tokens => STRINGARRAY('NAME', 'TYPE', 'ACTUAL'),

461: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_UNKNOWN_CHART');
462: END IF;
463:
464: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DELETE_TYPE_WRONG',
465: p_tokens => STRINGARRAY('NAME', 'TYPE', 'ACTUAL'),
466: p_values => l_tokens);
467:
468: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
469: p_msg => x_error_msg,

Line 484: p_tokens => STRINGARRAY('NAME'),

480: END IF;
481:
482: IF (l_list_header_id = -1) THEN
483: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
484: p_tokens => STRINGARRAY('NAME'),
485: p_values => STRINGARRAY(p_name));
486:
487: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
488: p_msg => x_error_msg,

Line 485: p_values => STRINGARRAY(p_name));

481:
482: IF (l_list_header_id = -1) THEN
483: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
484: p_tokens => STRINGARRAY('NAME'),
485: p_values => STRINGARRAY(p_name));
486:
487: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
488: p_msg => x_error_msg,
489: p_category => 'C',

Line 1154: p_tokens => STRINGARRAY('NAME'),

1150: x_error_msg => x_error_msg);
1151: ELSE
1152: x_status := 2;
1153: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_CAT_REGION_UNKNOWN',
1154: p_tokens => STRINGARRAY('NAME'),
1155: p_values => STRINGARRAY(g_region_flag));
1156:
1157: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name, --check
1158: p_msg => x_error_msg,

Line 1155: p_values => STRINGARRAY(g_region_flag));

1151: ELSE
1152: x_status := 2;
1153: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_CAT_REGION_UNKNOWN',
1154: p_tokens => STRINGARRAY('NAME'),
1155: p_values => STRINGARRAY(g_region_flag));
1156:
1157: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name, --check
1158: p_msg => x_error_msg,
1159: p_category => 'D');

Line 1330: -- 1. STRINGARRAY: A list of associated modifier IDs.

1326: -- 1. p_list_header_id:
1327: -- 2. p_pricelist_name:
1328: --
1329: -- RETURN
1330: -- 1. STRINGARRAY: A list of associated modifier IDs.
1331: -----------------------------------------------------------------------------
1332: FUNCTION Get_Assoc_Modifiers(p_list_header_id IN NUMBER,
1333: p_pricelist_name IN VARCHAR2)
1334: RETURN STRINGARRAY IS

Line 1334: RETURN STRINGARRAY IS

1330: -- 1. STRINGARRAY: A list of associated modifier IDs.
1331: -----------------------------------------------------------------------------
1332: FUNCTION Get_Assoc_Modifiers(p_list_header_id IN NUMBER,
1333: p_pricelist_name IN VARCHAR2)
1334: RETURN STRINGARRAY IS
1335:
1336: l_mod_ids STRINGARRAY;
1337: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_ASSOC_MODIFIERS';
1338:

Line 1336: l_mod_ids STRINGARRAY;

1332: FUNCTION Get_Assoc_Modifiers(p_list_header_id IN NUMBER,
1333: p_pricelist_name IN VARCHAR2)
1334: RETURN STRINGARRAY IS
1335:
1336: l_mod_ids STRINGARRAY;
1337: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_ASSOC_MODIFIERS';
1338:
1339: CURSOR Get_Modifiers_With_Name IS
1340: SELECT modc.list_header_id

Line 1416: -- 1. STRINGARRAY: A list of associated pricelist IDs.

1412: -- 1. p_list_header_id:
1413: -- 2. p_modifier_name:
1414: --
1415: -- RETURN
1416: -- 1. STRINGARRAY: A list of associated pricelist IDs.
1417: -----------------------------------------------------------------------------
1418: FUNCTION GET_ASSOC_PRICELISTS (p_list_header_id IN NUMBER,
1419: p_modifier_name IN VARCHAR2)
1420: RETURN STRINGARRAY IS

Line 1420: RETURN STRINGARRAY IS

1416: -- 1. STRINGARRAY: A list of associated pricelist IDs.
1417: -----------------------------------------------------------------------------
1418: FUNCTION GET_ASSOC_PRICELISTS (p_list_header_id IN NUMBER,
1419: p_modifier_name IN VARCHAR2)
1420: RETURN STRINGARRAY IS
1421:
1422: l_mod_ids STRINGARRAY;
1423: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_ASSOC_PRICELISTS';
1424:

Line 1422: l_mod_ids STRINGARRAY;

1418: FUNCTION GET_ASSOC_PRICELISTS (p_list_header_id IN NUMBER,
1419: p_modifier_name IN VARCHAR2)
1420: RETURN STRINGARRAY IS
1421:
1422: l_mod_ids STRINGARRAY;
1423: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_ASSOC_PRICELISTS';
1424:
1425: CURSOR Get_Pricelists_With_Name IS
1426: SELECT rc.list_header_id

Line 1520: l_list_header_ids STRINGARRAY := STRINGARRAY();

1516: l_status VARCHAR2(10);
1517: l_sql_errors VARCHAR2(8000);
1518: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.QP_API_CALL';
1519:
1520: l_list_header_ids STRINGARRAY := STRINGARRAY();
1521: l_return_status VARCHAR2(1);
1522: x_msg_count number;
1523: x_msg_data Varchar2(2000);
1524: x_msg_index number;

Line 1623: p_tokens => STRINGARRAY('STATUS', 'ERROR'),

1619:
1620: --check for errors
1621: IF (l_status <> 'COMPLETED') THEN
1622: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_QP_ERROR',
1623: p_tokens => STRINGARRAY('STATUS', 'ERROR'),
1624: p_values => STRINGARRAY(l_status, substr(l_sql_errors, 0, 700)));
1625:
1626: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1627: p_msg => x_error_msg,

Line 1624: p_values => STRINGARRAY(l_status, substr(l_sql_errors, 0, 700)));

1620: --check for errors
1621: IF (l_status <> 'COMPLETED') THEN
1622: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_QP_ERROR',
1623: p_tokens => STRINGARRAY('STATUS', 'ERROR'),
1624: p_values => STRINGARRAY(l_status, substr(l_sql_errors, 0, 700)));
1625:
1626: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1627: p_msg => x_error_msg,
1628: p_category => 'O');