DBA Data[Home] [Help]

APPS.PER_CONTACT_RELATIONSHIPS_PKG dependencies on BEN_CON_LER

Line 74: table to ben_con_ler.ler_chk procedure

70: 24-Oct-01 adhunter 115.23 1931258 added ben_person_delete calls in delete_row
71: 15-Nov-01 adhunter 115.24 2073795 added validation for X_Contact_Person_Id.
72: 16-Nov-01 adhunter 115.25 added dbdrv line
73: 14-Feb-02 hnarayan 115.27 1772037 added code to pass dff attributes of per_contact_relationships
74: table to ben_con_ler.ler_chk procedure
75: Makiko Iwamoto 2002/03/05 115.28 2225930 Added procedure chk_dates to validate
76: if new date_start is earlier than the
77: effective_start_date of child contact extra
78: information records and if new date_end is

Line 557: l_old ben_con_ler.g_con_ler_rec;

553: SELECT per_contact_relationships_s.NEXTVAL FROM sys.dual;
554: --
555: -- Start of Fix for WWBUG 1408379
556: --
557: l_old ben_con_ler.g_con_ler_rec;
558: l_new ben_con_ler.g_con_ler_rec;
559: --
560: -- End of Fix for WWBUG 1408379
561: --

Line 558: l_new ben_con_ler.g_con_ler_rec;

554: --
555: -- Start of Fix for WWBUG 1408379
556: --
557: l_old ben_con_ler.g_con_ler_rec;
558: l_new ben_con_ler.g_con_ler_rec;
559: --
560: -- End of Fix for WWBUG 1408379
561: --
562: BEGIN

Line 759: ben_con_ler.ler_chk(p_old => l_old,

755: l_new.cont_attribute20 := x_cont_attribute20 ;
756: --
757: -- End fix 1772037
758: --
759: ben_con_ler.ler_chk(p_old => l_old,
760: p_new => l_new,
761: p_effective_date => NVL(x_date_start,SYSDATE));
762: --
763: -- End of Fix for 1408379

Line 1881: l_old ben_con_ler.g_con_ler_rec;

1877: WHERE ROWID = x_rowid;
1878: --
1879: l_c1 c1%ROWTYPE;
1880: l_rows_found BOOLEAN := FALSE;
1881: l_old ben_con_ler.g_con_ler_rec;
1882: l_new ben_con_ler.g_con_ler_rec;
1883: --
1884: -- End of Fix for WWBUG 1408379
1885: --

Line 1882: l_new ben_con_ler.g_con_ler_rec;

1878: --
1879: l_c1 c1%ROWTYPE;
1880: l_rows_found BOOLEAN := FALSE;
1881: l_old ben_con_ler.g_con_ler_rec;
1882: l_new ben_con_ler.g_con_ler_rec;
1883: --
1884: -- End of Fix for WWBUG 1408379
1885: --
1886: ---------------------------------------------

Line 2053: ben_con_ler.ler_chk(p_old => l_old,

2049: l_new.cont_attribute19 := x_cont_attribute19 ;
2050: l_new.cont_attribute20 := x_cont_attribute20 ;
2051: -- End fix 1772037
2052: --
2053: ben_con_ler.ler_chk(p_old => l_old,
2054: p_new => l_new,
2055: p_effective_date => NVL(x_date_start,SYSDATE));
2056: --
2057: END IF;

Line 2222: ben_con_ler.ler_chk(p_old => l_old,

2218: l_new.cont_attribute19 := x_cont_attribute19 ;
2219: l_new.cont_attribute20 := x_cont_attribute20 ;
2220: -- End fix 1772037
2221: --
2222: ben_con_ler.ler_chk(p_old => l_old,
2223: p_new => l_new,
2224: p_effective_date => NVL(x_date_start,SYSDATE));
2225: --
2226: END IF;