1: package body PAY_LINK_INPUT_VALUES_PKG as
2: /* $Header: pyliv.pkb 120.0 2005/05/29 01:50:44 appldev noship $ */
3: --------------------------------------------------------------------------------
4: g_dummy number (1);
5: g_package constant varchar2 (72) := 'PAY_LINK_INPUT_VALUES_PKG';
1: package body PAY_LINK_INPUT_VALUES_PKG as
2: /* $Header: pyliv.pkb 120.0 2005/05/29 01:50:44 appldev noship $ */
3: --------------------------------------------------------------------------------
4: g_dummy number (1);
5: g_package constant varchar2 (72) := 'PAY_LINK_INPUT_VALUES_PKG';
6: --------------------------------------------------------------------------------
7: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
8: BEGIN
9: DELETE FROM PAY_LINK_INPUT_VALUES_F
396: Missing_required_default boolean := FALSE;
397: --
398: begin
399: --
400: hr_utility.set_location ('PAY_LINK_INPUT_VALUES_PKG.CHECK_REQUIRED_DEFAULTS',1);
401: --
402: open csr_defaults;
403: fetch csr_defaults into g_dummy;
404: Missing_required_default := csr_defaults%found;
483: --
484: c_end_of_time constant date := to_date('31/12/4712','DD/MM/YYYY');
485: --
486: begin
487: hr_utility.set_location ('pay_link_input_values_pkg.parent_deleted',1);
488: --
489: <
490: for fetched_row in csr_rows_owned_by_parent LOOP
491: --
547: close csr_link;
548: return v_link_end_date;
549: end link_end_date;
550: --------------------------------------------------------------------------------
551: end PAY_LINK_INPUT_VALUES_PKG;