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.PN_EXP_TO_AR dependencies on FND_DATE

Line 2965: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));

2961: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2962: END IF;
2963: IF p_sch_dt_low IS NOT NULL AND
2964: p_sch_dt_high IS NOT NULL THEN
2965: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2966: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2967: ELSIF p_sch_dt_low IS NULL AND
2968: p_sch_dt_high IS NOT NULL THEN
2969: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));

Line 2966: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));

2962: END IF;
2963: IF p_sch_dt_low IS NOT NULL AND
2964: p_sch_dt_high IS NOT NULL THEN
2965: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2966: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2967: ELSIF p_sch_dt_low IS NULL AND
2968: p_sch_dt_high IS NOT NULL THEN
2969: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2970: ELSIF p_sch_dt_low IS NOT NULL AND

Line 2969: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));

2965: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2966: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2967: ELSIF p_sch_dt_low IS NULL AND
2968: p_sch_dt_high IS NOT NULL THEN
2969: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2970: ELSIF p_sch_dt_low IS NOT NULL AND
2971: p_sch_dt_high IS NULL THEN
2972: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2973: END IF;

Line 2972: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));

2968: p_sch_dt_high IS NOT NULL THEN
2969: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2970: ELSIF p_sch_dt_low IS NOT NULL AND
2971: p_sch_dt_high IS NULL THEN
2972: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2973: END IF;
2974: IF p_due_dt_low IS NOT NULL AND
2975: p_due_dt_high IS NOT NULL THEN
2976: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));

Line 2976: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));

2972: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2973: END IF;
2974: IF p_due_dt_low IS NOT NULL AND
2975: p_due_dt_high IS NOT NULL THEN
2976: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2977: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2978: ELSIF p_due_dt_low IS NULL AND
2979: p_due_dt_high IS NOT NULL THEN
2980: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));

Line 2977: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));

2973: END IF;
2974: IF p_due_dt_low IS NOT NULL AND
2975: p_due_dt_high IS NOT NULL THEN
2976: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2977: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2978: ELSIF p_due_dt_low IS NULL AND
2979: p_due_dt_high IS NOT NULL THEN
2980: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2981: ELSIF p_due_dt_low IS NOT NULL AND

Line 2980: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));

2976: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2977: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2978: ELSIF p_due_dt_low IS NULL AND
2979: p_due_dt_high IS NOT NULL THEN
2980: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2981: ELSIF p_due_dt_low IS NOT NULL AND
2982: p_due_dt_high IS NULL THEN
2983: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2984: END IF;

Line 2983: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));

2979: p_due_dt_high IS NOT NULL THEN
2980: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2981: ELSIF p_due_dt_low IS NOT NULL AND
2982: p_due_dt_high IS NULL THEN
2983: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2984: END IF;
2985: IF p_pay_prps_code IS NOT NULL THEN
2986: dbms_sql.bind_variable(p_cursor,'l_pay_prps_code',p_pay_prps_code);
2987: END IF;