APPS.HR_WPM_MASS_APR_PUSH dependencies on FND_DATE

Line 2171: := fnd_date.date_to_canonical (NVL (p_effective_date,

2167: l_status_code per_perf_mgmt_plans.status_code%TYPE;
2168: l_dummy BOOLEAN;
2169: l_request_id NUMBER;
2170: l_effective_date VARCHAR2 (30)
2171: := fnd_date.date_to_canonical (NVL (p_effective_date,
2172: TRUNC (SYSDATE))
2173: );
2174: --
2175: BEGIN

Line 2220: := fnd_date.canonical_to_date (NVL (p_effective_date,

2216: WHERE plan_id = p_plan_id;
2217:
2218: l_object_version_number NUMBER;
2219: l_effective_date DATE
2220: := fnd_date.canonical_to_date (NVL (p_effective_date,
2221: TRUNC (SYSDATE))
2222: );
2223:
2224: CURSOR csr_pend_trans (p_plan_id IN NUMBER)

Line 3070: := fnd_date.date_to_canonical (NVL (p_effective_date,

3066: --
3067: l_proc VARCHAR2 (80) := g_package || 'submit_ma_change_cp';
3068: l_request_id NUMBER := -1;
3069: l_effective_date VARCHAR2 (30)
3070: := fnd_date.date_to_canonical (NVL (p_effective_date,
3071: TRUNC (SYSDATE))
3072: );
3073: --
3074: BEGIN

Line 3178: DEFAULT fnd_date.canonical_to_date (NVL (p_effective_date,

3174: l_full_name per_all_people_f.full_name%TYPE;
3175: l_item_type VARCHAR2 (30);
3176: l_item_key VARCHAR2 (80);
3177: l_effective_date DATE
3178: DEFAULT fnd_date.canonical_to_date (NVL (p_effective_date,
3179: TRUNC (SYSDATE)
3180: )
3181: );
3182: l_no_of_errors NUMBER DEFAULT 0;