APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on FND_DATE

Line 5105: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.birth_date) ;

5101: n := n + 1 ;
5102: lv_corr_tab.extend;
5103:
5104: lv_corr_tab(n).column_name := 'DATE_OF_BIRTH';
5105: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.birth_date) ;
5106: n := n + 1 ;
5107: lv_corr_tab.extend;
5108:
5109: lv_corr_tab(n).column_name := 'PHONE_NUMBER';

Line 5566: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.app_completed_date) ;

5562: n := n + 1 ;
5563: lv_corr_tab.extend;
5564:
5565: lv_corr_tab(n).column_name := 'DATE_APP_COMPLETED';
5566: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.app_completed_date) ;
5567: n := n + 1 ;
5568: lv_corr_tab.extend;
5569:
5570: lv_corr_tab(n).column_name := 'SIGNED_BY';

Line 5591: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.transaction_receipt_date) ;

5587: n := n + 1 ;
5588: lv_corr_tab.extend;
5589:
5590: lv_corr_tab(n).column_name := 'TRANSACTION_RECEIPT_DATE';
5591: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.transaction_receipt_date) ;
5592: n := n + 1 ;
5593: lv_corr_tab.extend;
5594:
5595: lv_corr_tab(n).column_name := 'DEPENDENCY_OVERRIDE_IND';

Line 5705: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.app_receipt_date) ;

5701: n := n + 1 ;
5702: lv_corr_tab.extend;
5703:
5704: lv_corr_tab(n).column_name := 'APP_RECEIPT_DATE';
5705: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.app_receipt_date) ;
5706: n := n + 1 ;
5707: lv_corr_tab.extend;
5708:
5709: lv_corr_tab(n).column_name := 'PROCESSED_REC_TYPE';

Line 5810: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.ssn_death_date) ;

5806: n := n + 1 ;
5807: lv_corr_tab.extend;
5808:
5809: lv_corr_tab(n).column_name := 'SSN_DATE_OF_DEATH';
5810: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.ssn_death_date) ;
5811: n := n + 1 ;
5812: lv_corr_tab.extend;
5813:
5814: lv_corr_tab(n).column_name := 'NSLDS_MATCH_FLAG';

Line 5855: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.tran_process_date) ;

5851: n := n + 1 ;
5852: lv_corr_tab.extend;
5853:
5854: lv_corr_tab(n).column_name := 'TRAN_PROCESS_DATE';
5855: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.tran_process_date) ;
5856: n := n + 1 ;
5857: lv_corr_tab.extend;
5858:
5859: lv_corr_tab(n).column_name := 'COMPUTER_BATCH_NUMBER';

Line 6373: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.duplicate_date) ;

6369: n := n + 1 ;
6370: lv_corr_tab.extend;
6371:
6372: lv_corr_tab(n).column_name := 'DUPLICATE_DATE';
6373: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.duplicate_date) ;
6374: n := n + 1 ;
6375: lv_corr_tab.extend;
6376:
6377: lv_corr_tab(n).column_name := 'ISIR_TRANSACTION_TYPE';

Line 6423: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.fathr_step_father_birth_date) ;

6419: n := n + 1 ;
6420: lv_corr_tab.extend;
6421:
6422: lv_corr_tab(n).column_name := 'FATHER_STEP_FATHER_BIRTH_DATE';
6423: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.fathr_step_father_birth_date) ;
6424: n := n + 1 ;
6425: lv_corr_tab.extend;
6426:
6427: lv_corr_tab(n).column_name := 'MOTHER_FIRST_NAME_INITIAL_TXT';

Line 6433: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.mothr_step_mother_birth_date) ;

6429: n := n + 1 ;
6430: lv_corr_tab.extend;
6431:
6432: lv_corr_tab(n).column_name := 'MOTHER_STEP_MOTHER_BIRTH_DATE';
6433: lv_corr_tab(n).column_value := fnd_date.date_to_chardate(g_isir_intrface_rec.mothr_step_mother_birth_date) ;
6434: n := n + 1 ;
6435: lv_corr_tab.extend;
6436:
6437: lv_corr_tab(n).column_name := 'DHS_VERIFICATION_NUM_TXT';

Line 6466: l_corrected_value := to_char(fnd_date.chardate_to_date(isir_corr_rec.corrected_value), 'YYYYMM');

6462: IF isir_corr_rec.column_name = lv_corr_tab(n).column_name THEN
6463:
6464: IF isir_corr_rec.column_name IN ('S_LEGAL_RESD_DATE', 'PARENT_MARITAL_STATUS_DATE', 'S_MARITAL_STATUS_DATE', 'P_LEGAL_RES_DATE') THEN
6465:
6466: l_corrected_value := to_char(fnd_date.chardate_to_date(isir_corr_rec.corrected_value), 'YYYYMM');
6467: l_column_value := lv_corr_tab(n).column_value ;
6468:
6469: ELSE
6470: l_corrected_value := NVL(isir_corr_rec.corrected_value,'##');

Line 7723: ld_date := FND_DATE.CHARDATE_TO_DATE( pv_org_date);

7719: */
7720: ld_date DATE;
7721: BEGIN
7722:
7723: ld_date := FND_DATE.CHARDATE_TO_DATE( pv_org_date);
7724: RETURN ld_date;
7725:
7726: EXCEPTION
7727: WHEN others THEN