APPS.PAY_OPM_INS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 90: from pay_org_payment_methods_f t

86: --
87: Cursor C_Sel1 Is
88: select t.created_by,
89: t.creation_date
90: from pay_org_payment_methods_f t
91: where t.org_payment_method_id = p_rec.org_payment_method_id
92: and t.effective_start_date =
93: pay_opm_shd.g_old_rec.effective_start_date
94: and t.effective_end_date = (p_validation_start_date - 1);

Line 97: l_created_by pay_org_payment_methods_f.created_by%TYPE;

93: pay_opm_shd.g_old_rec.effective_start_date
94: and t.effective_end_date = (p_validation_start_date - 1);
95: --
96: l_proc varchar2(72) := g_package||'dt_insert_dml';
97: l_created_by pay_org_payment_methods_f.created_by%TYPE;
98: l_creation_date pay_org_payment_methods_f.creation_date%TYPE;
99: l_last_update_date pay_org_payment_methods_f.last_update_date%TYPE;
100: l_last_updated_by pay_org_payment_methods_f.last_updated_by%TYPE;
101: l_last_update_login pay_org_payment_methods_f.last_update_login%TYPE;

Line 98: l_creation_date pay_org_payment_methods_f.creation_date%TYPE;

94: and t.effective_end_date = (p_validation_start_date - 1);
95: --
96: l_proc varchar2(72) := g_package||'dt_insert_dml';
97: l_created_by pay_org_payment_methods_f.created_by%TYPE;
98: l_creation_date pay_org_payment_methods_f.creation_date%TYPE;
99: l_last_update_date pay_org_payment_methods_f.last_update_date%TYPE;
100: l_last_updated_by pay_org_payment_methods_f.last_updated_by%TYPE;
101: l_last_update_login pay_org_payment_methods_f.last_update_login%TYPE;
102: --

Line 99: l_last_update_date pay_org_payment_methods_f.last_update_date%TYPE;

95: --
96: l_proc varchar2(72) := g_package||'dt_insert_dml';
97: l_created_by pay_org_payment_methods_f.created_by%TYPE;
98: l_creation_date pay_org_payment_methods_f.creation_date%TYPE;
99: l_last_update_date pay_org_payment_methods_f.last_update_date%TYPE;
100: l_last_updated_by pay_org_payment_methods_f.last_updated_by%TYPE;
101: l_last_update_login pay_org_payment_methods_f.last_update_login%TYPE;
102: --
103: Begin

Line 100: l_last_updated_by pay_org_payment_methods_f.last_updated_by%TYPE;

96: l_proc varchar2(72) := g_package||'dt_insert_dml';
97: l_created_by pay_org_payment_methods_f.created_by%TYPE;
98: l_creation_date pay_org_payment_methods_f.creation_date%TYPE;
99: l_last_update_date pay_org_payment_methods_f.last_update_date%TYPE;
100: l_last_updated_by pay_org_payment_methods_f.last_updated_by%TYPE;
101: l_last_update_login pay_org_payment_methods_f.last_update_login%TYPE;
102: --
103: Begin
104: hr_utility.set_location('Entering:'||l_proc, 5);

Line 101: l_last_update_login pay_org_payment_methods_f.last_update_login%TYPE;

97: l_created_by pay_org_payment_methods_f.created_by%TYPE;
98: l_creation_date pay_org_payment_methods_f.creation_date%TYPE;
99: l_last_update_date pay_org_payment_methods_f.last_update_date%TYPE;
100: l_last_updated_by pay_org_payment_methods_f.last_updated_by%TYPE;
101: l_last_update_login pay_org_payment_methods_f.last_update_login%TYPE;
102: --
103: Begin
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: --

Line 110: (p_base_table_name => 'pay_org_payment_methods_f'

106: -- Get the object version number for the insert
107: --
108: p_rec.object_version_number :=
109: dt_api.get_object_version_number
110: (p_base_table_name => 'pay_org_payment_methods_f'
111: ,p_base_key_column => 'org_payment_method_id'
112: ,p_base_key_value => p_rec.org_payment_method_id
113: );
114: --

Line 153: -- Insert the row into: pay_org_payment_methods_f

149: End If;
150: --
151: pay_opm_shd.g_api_dml := true; -- Set the api dml status
152: --
153: -- Insert the row into: pay_org_payment_methods_f
154: --
155: insert into pay_org_payment_methods_f
156: (org_payment_method_id
157: ,effective_start_date

Line 155: insert into pay_org_payment_methods_f

151: pay_opm_shd.g_api_dml := true; -- Set the api dml status
152: --
153: -- Insert the row into: pay_org_payment_methods_f
154: --
155: insert into pay_org_payment_methods_f
156: (org_payment_method_id
157: ,effective_start_date
158: ,effective_end_date
159: ,business_group_id

Line 383: from pay_org_payment_methods_f

379: Cursor C_Sel1 is select pay_org_payment_methods_s.nextval from sys.dual;
380: --
381: Cursor C_Sel2 is
382: Select null
383: from pay_org_payment_methods_f
384: where org_payment_method_id =
385: pay_opm_ins.g_org_payment_method_id_i;
386: --
387: l_proc varchar2(72) := g_package||'pre_insert';

Line 405: fnd_message.set_token('TABLE_NAME','pay_org_payment_methods_f');

401: --
402: -- The primary key values are already in use.
403: --
404: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
405: fnd_message.set_token('TABLE_NAME','pay_org_payment_methods_f');
406: fnd_message.raise_error;
407: End If;
408: Close C_Sel2;
409: --

Line 432: ,p_source_table_name => 'PAY_ORG_PAYMENT_METHODS_F'

428: --
429: If (p_rec.comments is not null) then
430: hr_comm_api.ins
431: (p_comment_id => p_rec.comment_id
432: ,p_source_table_name => 'PAY_ORG_PAYMENT_METHODS_F'
433: ,p_comment_text => p_rec.comments
434: );
435: End If;
436: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 617: (p_module_name => 'PAY_ORG_PAYMENT_METHODS_F'

613: --
614: when hr_api.cannot_find_prog_unit then
615: --
616: hr_api.cannot_find_prog_unit_error
617: (p_module_name => 'PAY_ORG_PAYMENT_METHODS_F'
618: ,p_hook_type => 'AI');
619: --
620: end;
621: --

Line 682: ,p_base_table_name => 'pay_org_payment_methods_f'

678: --
679: dt_api.validate_dt_mode
680: (p_effective_date => p_effective_date
681: ,p_datetrack_mode => p_datetrack_mode
682: ,p_base_table_name => 'pay_org_payment_methods_f'
683: ,p_base_key_column => 'org_payment_method_id'
684: ,p_base_key_value => p_rec.org_payment_method_id
685: ,p_enforce_foreign_locking => true
686: ,p_validation_start_date => l_validation_start_date