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 664: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);

660:
661: IF P_START_DATE IS NULL THEN
662: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
663: ELSE
664: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);
665: END IF;
666:
667: IF P_END_DATE IS NULL THEN
668: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');

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

666:
667: IF P_END_DATE IS NULL THEN
668: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');
669: ELSE
670: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);
671: END IF;
672:
673: IF P_LOW_LEASE_ID IS NULL THEN
674: l_low_lease_id := -1;

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

959:
960: IF P_START_DATE IS NULL THEN
961: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
962: ELSE
963: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);
964: END IF;
965:
966: IF P_END_DATE IS NULL THEN
967: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');

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

965:
966: IF P_END_DATE IS NULL THEN
967: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');
968: ELSE
969: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);
970: END IF;
971:
972: IF P_LOW_LEASE_ID IS NULL THEN
973: l_low_lease_id := -1;

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

1237: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1238: pn_mo_cache_utils.get_current_org_id)
1239: AND application_id = 101
1240: AND adjustment_period_flag = 'N'
1241: AND fnd_date.canonical_to_date(p_default_gl_date) BETWEEN start_date AND end_date;
1242:
1243: CURSOR c_min_max_date IS
1244: SELECT min(accounting_date),
1245: max(accounting_date)

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

1252: --Print all input parameters
1253: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
1254: fnd_message.set_token ('JC', P_journal_category);
1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);
1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);

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

1254: fnd_message.set_token ('JC', P_journal_category);
1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);
1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
1262: fnd_message.set_token ('VEND_ID', p_vendor_id);

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

1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);
1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
1262: fnd_message.set_token ('VEND_ID', p_vendor_id);
1263: fnd_message.set_token ('CUST_ID', p_customer_id);

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

1687:
1688: if p_start_date is null then
1689: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
1690: else
1691: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);
1692: end if;
1693:
1694: if p_end_date is null then
1695: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');

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

1693:
1694: if p_end_date is null then
1695: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');
1696: else
1697: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);
1698: end if;
1699:
1700: if p_low_lease_id is null then
1701: l_low_lease_id := -1;

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

1813:
1814: OPEN c_valid_period;
1815: FETCH c_valid_period INTO l_valid_period;
1816: IF c_valid_period%notfound THEN
1817: l_start_date := fnd_date.canonical_to_date(p_default_gl_date);
1818: l_period_name := p_default_period;
1819: ELSE
1820: l_start_date
1821: := PNP_UTIL_FUNC.Get_Start_Date

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

2441:
2442: IF P_START_DATE IS NULL THEN
2443: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
2444: ELSE
2445: l_sch_start_date := fnd_date.canonical_to_date(p_start_date);
2446: END IF;
2447:
2448: IF P_END_DATE IS NULL THEN
2449: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');

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

2447:
2448: IF P_END_DATE IS NULL THEN
2449: l_sch_end_date := to_date('12/31/4712','mm/dd/yyyy');
2450: ELSE
2451: l_sch_end_date := fnd_date.canonical_to_date(p_end_date);
2452: END IF;
2453:
2454: IF P_LOW_LEASE_ID IS NULL THEN
2455: l_low_lease_id := -1;

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

2566:
2567: OPEN C_VALID_PERIOD;
2568: FETCH c_valid_period INTO l_valid_period;
2569: IF c_valid_period%NOTFOUND THEN
2570: l_start_date := fnd_date.canonical_to_date(p_default_gl_date);
2571: l_period_name := p_default_period;
2572: ELSE
2573: l_start_date
2574: := PNP_UTIL_FUNC.Get_Start_Date