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

Line 25: l_as_of_date DATE := pnp_util_func.get_as_of_date(fnd_date.canonical_to_date(p_as_of_date));

21: p_as_of_date VARCHAR2 DEFAULT NULL
22: )
23:
24: IS
25: l_as_of_date DATE := pnp_util_func.get_as_of_date(fnd_date.canonical_to_date(p_as_of_date));
26: BEGIN
27:
28: IF (locn_or_spc_flag = 'LOCATION') THEN
29:

Line 97: l_last_update_from DATE := fnd_date.canonical_to_date(NVL(p_last_update_from,'0001/01/01:00:00:00'));

93:
94:
95: IS
96:
97: l_last_update_from DATE := fnd_date.canonical_to_date(NVL(p_last_update_from,'0001/01/01:00:00:00'));
98: l_last_update_to DATE := fnd_date.canonical_to_date(NVL(p_last_update_to,'4712/12/31:00:00:00'));
99:
100: /* this is for a probable future use...
101: l_as_of_date DATE := NVL(p_as_of_date,

Line 98: l_last_update_to DATE := fnd_date.canonical_to_date(NVL(p_last_update_to,'4712/12/31:00:00:00'));

94:
95: IS
96:
97: l_last_update_from DATE := fnd_date.canonical_to_date(NVL(p_last_update_from,'0001/01/01:00:00:00'));
98: l_last_update_to DATE := fnd_date.canonical_to_date(NVL(p_last_update_to,'4712/12/31:00:00:00'));
99:
100: /* this is for a probable future use...
101: l_as_of_date DATE := NVL(p_as_of_date,
102: fnd_date.canonical_to_date('4712/12/31:00:00:00'));

Line 102: fnd_date.canonical_to_date('4712/12/31:00:00:00'));

98: l_last_update_to DATE := fnd_date.canonical_to_date(NVL(p_last_update_to,'4712/12/31:00:00:00'));
99:
100: /* this is for a probable future use...
101: l_as_of_date DATE := NVL(p_as_of_date,
102: fnd_date.canonical_to_date('4712/12/31:00:00:00'));
103: */
104: exists_in_itf NUMBER;
105: insert_update VARCHAR2(6);
106: FAIL_ON_UPDATE EXCEPTION;

Line 867: l_last_update_from DATE := NVL(fnd_date.canonical_to_date(p_last_update_from),

863: )
864:
865: IS
866:
867: l_last_update_from DATE := NVL(fnd_date.canonical_to_date(p_last_update_from),
868: fnd_date.canonical_to_date('0001/01/01:00:00:00'));
869: l_last_update_to DATE := NVL(fnd_date.canonical_to_date(p_last_update_to),
870: fnd_date.canonical_to_date('4712/12/31:00:00:00'));
871: l_as_of_date DATE := fnd_date.canonical_to_date(p_as_of_date);

Line 868: fnd_date.canonical_to_date('0001/01/01:00:00:00'));

864:
865: IS
866:
867: l_last_update_from DATE := NVL(fnd_date.canonical_to_date(p_last_update_from),
868: fnd_date.canonical_to_date('0001/01/01:00:00:00'));
869: l_last_update_to DATE := NVL(fnd_date.canonical_to_date(p_last_update_to),
870: fnd_date.canonical_to_date('4712/12/31:00:00:00'));
871: l_as_of_date DATE := fnd_date.canonical_to_date(p_as_of_date);
872:

Line 869: l_last_update_to DATE := NVL(fnd_date.canonical_to_date(p_last_update_to),

865: IS
866:
867: l_last_update_from DATE := NVL(fnd_date.canonical_to_date(p_last_update_from),
868: fnd_date.canonical_to_date('0001/01/01:00:00:00'));
869: l_last_update_to DATE := NVL(fnd_date.canonical_to_date(p_last_update_to),
870: fnd_date.canonical_to_date('4712/12/31:00:00:00'));
871: l_as_of_date DATE := fnd_date.canonical_to_date(p_as_of_date);
872:
873: exists_in_itf NUMBER;

Line 870: fnd_date.canonical_to_date('4712/12/31:00:00:00'));

866:
867: l_last_update_from DATE := NVL(fnd_date.canonical_to_date(p_last_update_from),
868: fnd_date.canonical_to_date('0001/01/01:00:00:00'));
869: l_last_update_to DATE := NVL(fnd_date.canonical_to_date(p_last_update_to),
870: fnd_date.canonical_to_date('4712/12/31:00:00:00'));
871: l_as_of_date DATE := fnd_date.canonical_to_date(p_as_of_date);
872:
873: exists_in_itf NUMBER;
874: Insert_Update VARCHAR2(6);

Line 871: l_as_of_date DATE := fnd_date.canonical_to_date(p_as_of_date);

867: l_last_update_from DATE := NVL(fnd_date.canonical_to_date(p_last_update_from),
868: fnd_date.canonical_to_date('0001/01/01:00:00:00'));
869: l_last_update_to DATE := NVL(fnd_date.canonical_to_date(p_last_update_to),
870: fnd_date.canonical_to_date('4712/12/31:00:00:00'));
871: l_as_of_date DATE := fnd_date.canonical_to_date(p_as_of_date);
872:
873: exists_in_itf NUMBER;
874: Insert_Update VARCHAR2(6);
875: FAIL_ON_UPDATE EXCEPTION;

Line 928: vl_date := NVL(vl_date, fnd_date.canonical_to_date('4712/12/31:00:00:00'));

924: v_TASK_ID NUMBER;
925:
926: BEGIN
927: pnp_debug_pkg.put_log_msg('inside exp_spc_to_cad_itf');
928: vl_date := NVL(vl_date, fnd_date.canonical_to_date('4712/12/31:00:00:00'));
929:
930: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');
931: fnd_message.set_token ('TYPE',p_locn_type);
932: pnp_debug_pkg.put_log_msg(fnd_message.get);