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

Line 240: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);

236:
237: IF P_START_DATE IS NULL THEN
238: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
239: ELSE
240: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);
241: END IF;
242:
243: IF P_END_DATE IS NULL THEN
244: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');

Line 246: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);

242:
243: IF P_END_DATE IS NULL THEN
244: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');
245: ELSE
246: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);
247: END IF;
248:
249: IF P_LOW_LEASE_ID IS NULL THEN
250: l_low_lease_id := -1;

Line 516: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);

512:
513: IF P_START_DATE IS NULL THEN
514: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
515: ELSE
516: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);
517: END IF;
518:
519: IF P_END_DATE IS NULL THEN
520: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');

Line 522: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);

518:
519: IF P_END_DATE IS NULL THEN
520: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');
521: ELSE
522: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);
523: END IF;
524:
525: IF P_LOW_LEASE_ID IS NULL THEN
526: l_low_lease_id := -1;

Line 773: AND fnd_date.canonical_to_date(p_default_gl_date) BETWEEN start_date AND end_date;

769: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
770: pn_mo_cache_utils.get_current_org_id)
771: AND application_id = 101
772: AND adjustment_period_flag = 'N'
773: AND fnd_date.canonical_to_date(p_default_gl_date) BETWEEN start_date AND end_date;
774:
775: CURSOR c_min_max_date IS
776: SELECT min(accounting_date),
777: max(accounting_date)

Line 788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));

784: --Print all input parameters
785: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
786: fnd_message.set_token ('JC', P_journal_category);
787: fnd_message.set_token ('BATCH_NAME', p_batch_name);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);

Line 790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));

786: fnd_message.set_token ('JC', P_journal_category);
787: fnd_message.set_token ('BATCH_NAME', p_batch_name);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);

Line 791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));

787: fnd_message.set_token ('BATCH_NAME', p_batch_name);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);
795: fnd_message.set_token ('CUST_ID', p_customer_id);

Line 1223: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);

1219:
1220: if p_start_date is null then
1221: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
1222: else
1223: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);
1224: end if;
1225:
1226: if p_end_date is null then
1227: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');

Line 1229: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);

1225:
1226: if p_end_date is null then
1227: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');
1228: else
1229: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);
1230: end if;
1231:
1232: if p_low_lease_id is null then
1233: l_low_lease_id := -1;

Line 1349: l_start_date := fnd_date.canonical_to_date(p_default_gl_date);

1345:
1346: OPEN c_valid_period;
1347: FETCH c_valid_period INTO l_valid_period;
1348: IF c_valid_period%notfound THEN
1349: l_start_date := fnd_date.canonical_to_date(p_default_gl_date);
1350: l_period_name := p_default_period;
1351: ELSE
1352: l_start_date
1353: := PNP_UTIL_FUNC.Get_Start_Date

Line 1977: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);

1973:
1974: IF P_START_DATE IS NULL THEN
1975: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
1976: ELSE
1977: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);
1978: END IF;
1979:
1980: IF P_END_DATE IS NULL THEN
1981: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');

Line 1983: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);

1979:
1980: IF P_END_DATE IS NULL THEN
1981: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');
1982: ELSE
1983: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);
1984: END IF;
1985:
1986: IF P_LOW_LEASE_ID IS NULL THEN
1987: l_low_lease_id := -1;

Line 2102: l_start_date := fnd_date.canonical_to_date(p_default_gl_date);

2098:
2099: OPEN C_VALID_PERIOD;
2100: FETCH c_valid_period INTO l_valid_period;
2101: IF c_valid_period%NOTFOUND THEN
2102: l_start_date := fnd_date.canonical_to_date(p_default_gl_date);
2103: l_period_name := p_default_period;
2104: ELSE
2105: l_start_date
2106: := PNP_UTIL_FUNC.Get_Start_Date