DBA Data[Home] [Help]

APPS.BEN_CWB_STOCK_OPTN_DTLS_API dependencies on BEN_CWB_STOCK_OPTN_DTLS

Line 1: Package Body BEN_CWB_STOCK_OPTN_DTLS_API as

1: Package Body BEN_CWB_STOCK_OPTN_DTLS_API as
2: /* $Header: becsoapi.pkb 115.0 2003/03/17 13:42:00 csundar noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' ben_cwb_stock_optn_dtls_api.';

2: /* $Header: becsoapi.pkb 115.0 2003/03/17 13:42:00 csundar noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_cwb_stock_optn_dtls_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_cwb_stock_optn_dtls >------------------|
10: -- ----------------------------------------------------------------------------

Line 76: l_cwb_stock_optn_dtls_id ben_cwb_stock_optn_dtls.cwb_stock_optn_dtls_id%TYPE;

72: ) is
73: --
74: -- Declare cursors and local variables
75: --
76: l_cwb_stock_optn_dtls_id ben_cwb_stock_optn_dtls.cwb_stock_optn_dtls_id%TYPE;
77: l_object_version_number ben_cwb_stock_optn_dtls.object_version_number%TYPE;
78: l_proc varchar2(72) := g_package||'create_cwb_stock_optn_dtls';
79: begin
80: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 77: l_object_version_number ben_cwb_stock_optn_dtls.object_version_number%TYPE;

73: --
74: -- Declare cursors and local variables
75: --
76: l_cwb_stock_optn_dtls_id ben_cwb_stock_optn_dtls.cwb_stock_optn_dtls_id%TYPE;
77: l_object_version_number ben_cwb_stock_optn_dtls.object_version_number%TYPE;
78: l_proc varchar2(72) := g_package||'create_cwb_stock_optn_dtls';
79: begin
80: hr_utility.set_location('Entering:'|| l_proc, 10);
81: --

Line 93: ben_cwb_stock_optn_dtls_bk1.create_cwb_stock_optn_dtls_b

89: --
90: -- Call Before Process User Hook
91: --
92: begin
93: ben_cwb_stock_optn_dtls_bk1.create_cwb_stock_optn_dtls_b
94: (p_effective_date => p_effective_date
95: ,p_grant_id => p_grant_id
96: ,p_grant_number => p_grant_number
97: ,p_grant_name => p_grant_name

Line 233: ben_cwb_stock_optn_dtls_bk1.create_cwb_stock_optn_dtls_a

229: --
230: -- Call After Process User Hook
231: --
232: begin
233: ben_cwb_stock_optn_dtls_bk1.create_cwb_stock_optn_dtls_a
234: (p_effective_date => p_effective_date
235: ,p_grant_id => p_grant_id
236: ,p_grant_number => p_grant_number
237: ,p_grant_name => p_grant_name

Line 412: l_object_version_number ben_cwb_stock_optn_dtls.object_version_number%TYPE;

408: ) is
409: --
410: -- Declare cursors and local variables
411: --
412: l_object_version_number ben_cwb_stock_optn_dtls.object_version_number%TYPE;
413: l_proc varchar2(72) := g_package||'update_cwb_stock_optn_dtls';
414: begin
415: hr_utility.set_location('Entering:'|| l_proc, 10);
416: --

Line 430: ben_cwb_stock_optn_dtls_bk2.update_cwb_stock_optn_dtls_b

426: --
427: -- Call Before Process User Hook
428: --
429: begin
430: ben_cwb_stock_optn_dtls_bk2.update_cwb_stock_optn_dtls_b
431: (p_effective_date => p_effective_date
432: ,p_grant_id => p_grant_id
433: ,p_grant_number => p_grant_number
434: ,p_grant_name => p_grant_name

Line 572: ben_cwb_stock_optn_dtls_bk2.update_cwb_stock_optn_dtls_a

568: --
569: -- Call After Process User Hook
570: --
571: begin
572: ben_cwb_stock_optn_dtls_bk2.update_cwb_stock_optn_dtls_a
573: (p_effective_date => p_effective_date
574: ,p_grant_id => p_grant_id
575: ,p_grant_number => p_grant_number
576: ,p_grant_name => p_grant_name

Line 688: l_object_version_number ben_cwb_stock_optn_dtls.object_version_number%TYPE;

684: ) is
685: --
686: -- Declare cursors and local variables
687: --
688: l_object_version_number ben_cwb_stock_optn_dtls.object_version_number%TYPE;
689: l_proc varchar2(72) := g_package||'delete_cwb_stock_optn_dtls';
690: begin
691: hr_utility.set_location('Entering:'|| l_proc, 10);
692: --

Line 706: ben_cwb_stock_optn_dtls_bk3.delete_cwb_stock_optn_dtls_b

702: --
703: -- Call Before Process User Hook
704: --
705: begin
706: ben_cwb_stock_optn_dtls_bk3.delete_cwb_stock_optn_dtls_b
707: (p_effective_date => p_effective_date
708: ,p_cwb_stock_optn_dtls_id => p_cwb_stock_optn_dtls_id
709: ,p_object_version_number => p_object_version_number
710: );

Line 737: ben_cwb_stock_optn_dtls_bk3.delete_cwb_stock_optn_dtls_a

733: --
734: -- Call After Process User Hook
735: --
736: begin
737: ben_cwb_stock_optn_dtls_bk3.delete_cwb_stock_optn_dtls_a
738: (p_effective_date => p_effective_date
739: ,p_cwb_stock_optn_dtls_id => p_cwb_stock_optn_dtls_id
740: ,p_object_version_number => p_object_version_number
741: );

Line 808: end BEN_CWB_STOCK_OPTN_DTLS_API;

804: hr_utility.set_location(' Leaving:'||l_proc, 70);
805: --
806: end lck;
807: --
808: end BEN_CWB_STOCK_OPTN_DTLS_API;