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.JTF_TAE_GEN_PVT dependencies on FND_GLOBAL

Line 84: G_NEWLINE VARCHAR2(30) := FND_GLOBAL.Local_Chr(10);

80: /* jdochert: 05/01/02 */
81: G_DYN_PKG_NAME VARCHAR2(30) := NULL;
82:
83: /* jdochert: 07/31/02 */
84: G_NEWLINE VARCHAR2(30) := FND_GLOBAL.Local_Chr(10);
85: G_INDENT VARCHAR2(30) := ' ';
86: G_INDENT1 VARCHAR2(30) := ' ';
87:
88: /* dblee: 08/20/03 - define global variable for holding select clause which differs

Line 923: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */

919: l_indent VARCHAR2(30);
920:
921: BEGIN
922:
923: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */
924: l_indent := ' ';
925: l_start := 1;
926: l_next_newline := 0;
927:

Line 1014: l_newline := FND_GLOBAL.Local_Chr(10);

1010: ORDER BY jtqf.qual_usg_id;
1011:
1012: BEGIN
1013:
1014: l_newline := FND_GLOBAL.Local_Chr(10);
1015:
1016: FOR JTF_csr IN c_rel_prod_detail LOOP
1017:
1018: --l_idx_hint := '/*+ INDEX(' || JTF_csr.alias_rule1 ||' JTF_TERR_QUAL_RULES_MV_N10) */';

Line 1197: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */

1193:
1194: --dbms_output.put_line('Inside build_rule_expression ');
1195: l_relation_product := p_relation_product/p_relation_factor;
1196:
1197: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */
1198: l_sysdate := SYSDATE;
1199:
1200: FOR JTF_csr IN c_rel_prod_detail LOOP
1201:

Line 1686: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */

1682: BEGIN
1683:
1684: --dbms_output.put_line('Inside build_rule_expression ');
1685:
1686: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */
1687: l_sysdate := SYSDATE;
1688:
1689: FOR JTF_csr IN c_rel_prod_detail LOOP
1690:

Line 3355: l_newline VARCHAR2(2) := FND_GLOBAL.Local_Chr(10); /* newline character */

3351: l_start NUMBER;
3352: l_get_nchar NUMBER;
3353: l_next_newline NUMBER;
3354: l_rule_str VARCHAR2(256);
3355: l_newline VARCHAR2(2) := FND_GLOBAL.Local_Chr(10); /* newline character */
3356: l_indent VARCHAR2(30);
3357: p_sql VARCHAR2(32767) := NULL;
3358: --l_input_table_name VARCHAR2(30) := 'jtf_tae_trans_objs';
3359: l_ilv2eq VARCHAR2(32767);

Line 3398: Add_To_PackageTable (' L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();');

3394: generate_object_definition( l_procedure_name, l_procedure_desc,
3395: l_parameter_list1, l_parameter_list2, 'P', 'BOOLEAN', 'PKB' );
3396:
3397: Add_To_PackageTable (' ');
3398: Add_To_PackageTable (' L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();');
3399: Add_To_PackageTable (' L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();');
3400: Add_To_PackageTable (' L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();');
3401: Add_To_PackageTable (' L_USER_ID NUMBER := FND_GLOBAL.USER_ID();');
3402: Add_To_PackageTable (' l_sysdate DATE := SYSDATE;');

Line 3399: Add_To_PackageTable (' L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();');

3395: l_parameter_list1, l_parameter_list2, 'P', 'BOOLEAN', 'PKB' );
3396:
3397: Add_To_PackageTable (' ');
3398: Add_To_PackageTable (' L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();');
3399: Add_To_PackageTable (' L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();');
3400: Add_To_PackageTable (' L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();');
3401: Add_To_PackageTable (' L_USER_ID NUMBER := FND_GLOBAL.USER_ID();');
3402: Add_To_PackageTable (' l_sysdate DATE := SYSDATE;');
3403: Add_To_PackageTable (' ');

Line 3400: Add_To_PackageTable (' L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();');

3396:
3397: Add_To_PackageTable (' ');
3398: Add_To_PackageTable (' L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();');
3399: Add_To_PackageTable (' L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();');
3400: Add_To_PackageTable (' L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();');
3401: Add_To_PackageTable (' L_USER_ID NUMBER := FND_GLOBAL.USER_ID();');
3402: Add_To_PackageTable (' l_sysdate DATE := SYSDATE;');
3403: Add_To_PackageTable (' ');
3404: Add_To_PackageTable (' l_cursor NUMBER;');

Line 3401: Add_To_PackageTable (' L_USER_ID NUMBER := FND_GLOBAL.USER_ID();');

3397: Add_To_PackageTable (' ');
3398: Add_To_PackageTable (' L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();');
3399: Add_To_PackageTable (' L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();');
3400: Add_To_PackageTable (' L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();');
3401: Add_To_PackageTable (' L_USER_ID NUMBER := FND_GLOBAL.USER_ID();');
3402: Add_To_PackageTable (' l_sysdate DATE := SYSDATE;');
3403: Add_To_PackageTable (' ');
3404: Add_To_PackageTable (' l_cursor NUMBER;');
3405: Add_To_PackageTable (' l_dyn_str VARCHAR2(32767);');

Line 3611: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */

3607: Add_To_PackageTable (' FROM ');
3608: END IF;
3609: END IF; -- p_new_mode_fetch = 'Y'
3610:
3611: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */
3612: l_indent := ' ';
3613: l_start := 1;
3614: l_next_newline := 0;
3615: