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_AP dependencies on FND_DATE

Line 516: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );

512: END IF;
513:
514: IF p_sch_dt_low IS NOT NULL AND p_sch_dt_high IS NOT NULL THEN
515: dbms_sql.bind_variable
516: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );
517: dbms_sql.bind_variable
518: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );
519:
520: ELSIF p_sch_dt_low IS NULL AND p_sch_dt_high IS NOT NULL THEN

Line 518: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );

514: IF p_sch_dt_low IS NOT NULL AND p_sch_dt_high IS NOT NULL THEN
515: dbms_sql.bind_variable
516: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );
517: dbms_sql.bind_variable
518: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );
519:
520: ELSIF p_sch_dt_low IS NULL AND p_sch_dt_high IS NOT NULL THEN
521: dbms_sql.bind_variable
522: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );

Line 522: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );

518: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );
519:
520: ELSIF p_sch_dt_low IS NULL AND p_sch_dt_high IS NOT NULL THEN
521: dbms_sql.bind_variable
522: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );
523:
524: ELSIF p_sch_dt_low IS NOT NULL AND p_sch_dt_high IS NULL THEN
525: dbms_sql.bind_variable
526: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );

Line 526: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );

522: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );
523:
524: ELSIF p_sch_dt_low IS NOT NULL AND p_sch_dt_high IS NULL THEN
525: dbms_sql.bind_variable
526: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );
527: END IF;
528:
529: IF p_due_dt_low IS NOT NULL AND p_due_dt_high IS NOT NULL THEN
530: dbms_sql.bind_variable

Line 531: (p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low) );

527: END IF;
528:
529: IF p_due_dt_low IS NOT NULL AND p_due_dt_high IS NOT NULL THEN
530: dbms_sql.bind_variable
531: (p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low) );
532: dbms_sql.bind_variable
533: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );
534:
535: ELSIF p_due_dt_low IS NULL AND p_due_dt_high IS NOT NULL THEN

Line 533: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );

529: IF p_due_dt_low IS NOT NULL AND p_due_dt_high IS NOT NULL THEN
530: dbms_sql.bind_variable
531: (p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low) );
532: dbms_sql.bind_variable
533: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );
534:
535: ELSIF p_due_dt_low IS NULL AND p_due_dt_high IS NOT NULL THEN
536: dbms_sql.bind_variable
537: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );

Line 537: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );

533: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );
534:
535: ELSIF p_due_dt_low IS NULL AND p_due_dt_high IS NOT NULL THEN
536: dbms_sql.bind_variable
537: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );
538:
539: ELSIF p_due_dt_low IS NOT NULL AND p_due_dt_high IS NULL THEN
540: dbms_sql.bind_variable
541: (p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low) );

Line 541: (p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low) );

537: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );
538:
539: ELSIF p_due_dt_low IS NOT NULL AND p_due_dt_high IS NULL THEN
540: dbms_sql.bind_variable
541: (p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low) );
542: END IF;
543:
544: IF p_pay_prps_code IS NOT NULL THEN
545: dbms_sql.bind_variable