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 2881: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));

2877: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2878: END IF;
2879: IF p_sch_dt_low IS NOT NULL AND
2880: p_sch_dt_high IS NOT NULL THEN
2881: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2882: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2883: ELSIF p_sch_dt_low IS NULL AND
2884: p_sch_dt_high IS NOT NULL THEN
2885: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));

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

2878: END IF;
2879: IF p_sch_dt_low IS NOT NULL AND
2880: p_sch_dt_high IS NOT NULL THEN
2881: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2882: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2883: ELSIF p_sch_dt_low IS NULL AND
2884: p_sch_dt_high IS NOT NULL THEN
2885: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2886: ELSIF p_sch_dt_low IS NOT NULL AND

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

2881: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2882: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2883: ELSIF p_sch_dt_low IS NULL AND
2884: p_sch_dt_high IS NOT NULL THEN
2885: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2886: ELSIF p_sch_dt_low IS NOT NULL AND
2887: p_sch_dt_high IS NULL THEN
2888: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2889: END IF;

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

2884: p_sch_dt_high IS NOT NULL THEN
2885: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2886: ELSIF p_sch_dt_low IS NOT NULL AND
2887: p_sch_dt_high IS NULL THEN
2888: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2889: END IF;
2890: IF p_due_dt_low IS NOT NULL AND
2891: p_due_dt_high IS NOT NULL THEN
2892: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));

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

2888: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2889: END IF;
2890: IF p_due_dt_low IS NOT NULL AND
2891: p_due_dt_high IS NOT NULL THEN
2892: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2893: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2894: ELSIF p_due_dt_low IS NULL AND
2895: p_due_dt_high IS NOT NULL THEN
2896: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));

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

2889: END IF;
2890: IF p_due_dt_low IS NOT NULL AND
2891: p_due_dt_high IS NOT NULL THEN
2892: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2893: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2894: ELSIF p_due_dt_low IS NULL AND
2895: p_due_dt_high IS NOT NULL THEN
2896: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2897: ELSIF p_due_dt_low IS NOT NULL AND

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

2892: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2893: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2894: ELSIF p_due_dt_low IS NULL AND
2895: p_due_dt_high IS NOT NULL THEN
2896: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2897: ELSIF p_due_dt_low IS NOT NULL AND
2898: p_due_dt_high IS NULL THEN
2899: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2900: END IF;

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

2895: p_due_dt_high IS NOT NULL THEN
2896: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2897: ELSIF p_due_dt_low IS NOT NULL AND
2898: p_due_dt_high IS NULL THEN
2899: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2900: END IF;
2901: IF p_pay_prps_code IS NOT NULL THEN
2902: dbms_sql.bind_variable(p_cursor,'l_pay_prps_code',p_pay_prps_code);
2903: END IF;