APPS.PAY_LINK_INPUT_VALUES_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 9: DELETE FROM PAY_LINK_INPUT_VALUES_F

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
10: WHERE rowid = X_Rowid;
11:
12: if (SQL%NOTFOUND) then
13: RAISE NO_DATA_FOUND;

Line 31: FROM PAY_LINK_INPUT_VALUES_F

27: X_Min_Value VARCHAR2,
28: X_Warning_Or_Error VARCHAR2) IS
29: CURSOR C IS
30: SELECT *
31: FROM PAY_LINK_INPUT_VALUES_F
32: WHERE rowid = X_Rowid
33: FOR UPDATE of Link_Input_Value_Id NOWAIT;
34: Recinfo C%ROWTYPE;
35: BEGIN

Line 94: UPDATE PAY_LINK_INPUT_VALUES_F

90: X_Max_Value VARCHAR2,
91: X_Min_Value VARCHAR2,
92: X_Warning_Or_Error VARCHAR2) IS
93: BEGIN
94: UPDATE PAY_LINK_INPUT_VALUES_F
95: SET
96:
97: link_input_value_id = X_Link_Input_Value_Id,
98: effective_start_date = X_Effective_Start_Date,

Line 242: insert into pay_link_input_values_f

238: --
239: v_input_value_id := fetched_input_value.input_value_id;
240: end if;
241: --
242: insert into pay_link_input_values_f
243: (link_input_value_id,
244: effective_start_date,
245: effective_end_date,
246: element_link_id,

Line 341: insert into pay_link_input_values_f

337: --
338: v_link_id := fetched_link.element_link_id;
339: end if;
340: --
341: insert into pay_link_input_values_f
342: (link_input_value_id,
343: effective_start_date,
344: effective_end_date,
345: element_link_id,

Line 382: pay_link_input_values_f LINK

378: --
379: cursor csr_defaults is
380: select 1
381: from pay_input_values_f TYPE,
382: pay_link_input_values_f LINK
383: where p_session_date between type.effective_start_date
384: and type.effective_end_date
385: and p_session_date between link.effective_start_date
386: and link.effective_end_date

Line 477: select rowid,pay_link_input_values_f.*

473: -- the parent being deleted. The parent name identifies foreign key column
474: -- to use, thus the procedure is generic to any parent deletion
475: --
476: cursor csr_rows_owned_by_parent is
477: select rowid,pay_link_input_values_f.*
478: from pay_link_input_values_f
479: where p_parent_id = decode (p_parent_name,
480: 'PAY_INPUT_VALUES_F',input_value_id,
481: 'PAY_ELEMENT_LINKS_F',element_link_id)

Line 478: from pay_link_input_values_f

474: -- to use, thus the procedure is generic to any parent deletion
475: --
476: cursor csr_rows_owned_by_parent is
477: select rowid,pay_link_input_values_f.*
478: from pay_link_input_values_f
479: where p_parent_id = decode (p_parent_name,
480: 'PAY_INPUT_VALUES_F',input_value_id,
481: 'PAY_ELEMENT_LINKS_F',element_link_id)
482: for update;

Line 504: delete from pay_link_input_values_f

500: if p_delete_mode = 'ZAP' -- ie delete all rows
501: or (p_delete_mode = 'DELETE' -- ie delete all future rows
502: and fetched_row.effective_start_date > p_session_date) then
503: --
504: delete from pay_link_input_values_f
505: where current of csr_rows_owned_by_parent;
506: --
507: elsif p_delete_mode = 'DELETE'
508: and p_session_date between fetched_row.effective_start_date

Line 511: update pay_link_input_values_f

507: elsif p_delete_mode = 'DELETE'
508: and p_session_date between fetched_row.effective_start_date
509: and fetched_row.effective_end_date then
510: --
511: update pay_link_input_values_f
512: set effective_end_date = p_session_date
513: where current of csr_rows_owned_by_parent;
514: --
515: -- For delete next changes when there are no future rows for the parent,

Line 522: update pay_link_input_values_f

518: --
519: elsif p_delete_mode = 'DELETE_NEXT_CHANGE'
520: and p_validation_end_date = c_end_of_time then
521: --
522: update pay_link_input_values_f
523: set effective_end_date = c_end_of_time
524: where current of csr_rows_owned_by_parent;
525: --
526: end if;