DBA Data[Home] [Help]

APPS.PAY_PPMV4_UTILS_SS dependencies on PAY_PSS_TRANSACTION_STEPS

Line 34: (transaction_id pay_pss_transaction_steps.transaction_id%type

30: --
31: -- T_PPM
32: --
33: type t_ppmv4 is record
34: (transaction_id pay_pss_transaction_steps.transaction_id%type
35: ,transaction_step_id pay_pss_transaction_steps.transaction_step_id%type
36: ,source_table pay_pss_transaction_steps.source_table%type
37: ,state pay_pss_transaction_steps.state%type
38: ,personal_payment_method_id

Line 35: ,transaction_step_id pay_pss_transaction_steps.transaction_step_id%type

31: -- T_PPM
32: --
33: type t_ppmv4 is record
34: (transaction_id pay_pss_transaction_steps.transaction_id%type
35: ,transaction_step_id pay_pss_transaction_steps.transaction_step_id%type
36: ,source_table pay_pss_transaction_steps.source_table%type
37: ,state pay_pss_transaction_steps.state%type
38: ,personal_payment_method_id
39: pay_personal_payment_methods_f.personal_payment_method_id%type

Line 36: ,source_table pay_pss_transaction_steps.source_table%type

32: --
33: type t_ppmv4 is record
34: (transaction_id pay_pss_transaction_steps.transaction_id%type
35: ,transaction_step_id pay_pss_transaction_steps.transaction_step_id%type
36: ,source_table pay_pss_transaction_steps.source_table%type
37: ,state pay_pss_transaction_steps.state%type
38: ,personal_payment_method_id
39: pay_personal_payment_methods_f.personal_payment_method_id%type
40: ,update_ovn

Line 37: ,state pay_pss_transaction_steps.state%type

33: type t_ppmv4 is record
34: (transaction_id pay_pss_transaction_steps.transaction_id%type
35: ,transaction_step_id pay_pss_transaction_steps.transaction_step_id%type
36: ,source_table pay_pss_transaction_steps.source_table%type
37: ,state pay_pss_transaction_steps.state%type
38: ,personal_payment_method_id
39: pay_personal_payment_methods_f.personal_payment_method_id%type
40: ,update_ovn
41: pay_personal_payment_methods_f.object_version_number%type

Line 44: ,update_datetrack_mode pay_pss_transaction_steps.update_datetrack_mode%type

40: ,update_ovn
41: pay_personal_payment_methods_f.object_version_number%type
42: ,delete_ovn
43: pay_personal_payment_methods_f.object_version_number%type
44: ,update_datetrack_mode pay_pss_transaction_steps.update_datetrack_mode%type
45: ,delete_datetrack_mode pay_pss_transaction_steps.delete_datetrack_mode%type
46: ,delete_disabled pay_pss_transaction_steps.delete_disabled%type
47: ,effective_date date
48: ,org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type

Line 45: ,delete_datetrack_mode pay_pss_transaction_steps.delete_datetrack_mode%type

41: pay_personal_payment_methods_f.object_version_number%type
42: ,delete_ovn
43: pay_personal_payment_methods_f.object_version_number%type
44: ,update_datetrack_mode pay_pss_transaction_steps.update_datetrack_mode%type
45: ,delete_datetrack_mode pay_pss_transaction_steps.delete_datetrack_mode%type
46: ,delete_disabled pay_pss_transaction_steps.delete_disabled%type
47: ,effective_date date
48: ,org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type
49: ,assignment_id pay_personal_payment_methods_f.assignment_id%type

Line 46: ,delete_disabled pay_pss_transaction_steps.delete_disabled%type

42: ,delete_ovn
43: pay_personal_payment_methods_f.object_version_number%type
44: ,update_datetrack_mode pay_pss_transaction_steps.update_datetrack_mode%type
45: ,delete_datetrack_mode pay_pss_transaction_steps.delete_datetrack_mode%type
46: ,delete_disabled pay_pss_transaction_steps.delete_disabled%type
47: ,effective_date date
48: ,org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type
49: ,assignment_id pay_personal_payment_methods_f.assignment_id%type
50: ,payment_type pay_pss_transaction_steps.payment_type%type

Line 50: ,payment_type pay_pss_transaction_steps.payment_type%type

46: ,delete_disabled pay_pss_transaction_steps.delete_disabled%type
47: ,effective_date date
48: ,org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type
49: ,assignment_id pay_personal_payment_methods_f.assignment_id%type
50: ,payment_type pay_pss_transaction_steps.payment_type%type
51: ,currency_code pay_pss_transaction_steps.currency_code%type
52: ,territory_code pay_pss_transaction_steps.territory_code%type
53: --
54: -- Current data values.

Line 51: ,currency_code pay_pss_transaction_steps.currency_code%type

47: ,effective_date date
48: ,org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type
49: ,assignment_id pay_personal_payment_methods_f.assignment_id%type
50: ,payment_type pay_pss_transaction_steps.payment_type%type
51: ,currency_code pay_pss_transaction_steps.currency_code%type
52: ,territory_code pay_pss_transaction_steps.territory_code%type
53: --
54: -- Current data values.
55: --

Line 52: ,territory_code pay_pss_transaction_steps.territory_code%type

48: ,org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type
49: ,assignment_id pay_personal_payment_methods_f.assignment_id%type
50: ,payment_type pay_pss_transaction_steps.payment_type%type
51: ,currency_code pay_pss_transaction_steps.currency_code%type
52: ,territory_code pay_pss_transaction_steps.territory_code%type
53: --
54: -- Current data values.
55: --
56: ,real_priority pay_personal_payment_methods_f.priority%type

Line 58: ,amount_type pay_pss_transaction_steps.amount_type%type

54: -- Current data values.
55: --
56: ,real_priority pay_personal_payment_methods_f.priority%type
57: ,logical_priority pay_personal_payment_methods_f.priority%type
58: ,amount_type pay_pss_transaction_steps.amount_type%type
59: ,amount pay_personal_payment_methods_f.amount%type
60: ,external_account_id pay_external_accounts.external_account_id%type
61: ,attribute_category pay_personal_payment_methods_f.attribute_category%type
62: ,attribute1 pay_personal_payment_methods_f.attribute1%type

Line 87: ,o_amount_type pay_pss_transaction_steps.o_amount_type%type

83: -- Original data values.
84: --
85: ,o_real_priority pay_personal_payment_methods_f.priority%type
86: ,o_logical_priority pay_personal_payment_methods_f.priority%type
87: ,o_amount_type pay_pss_transaction_steps.o_amount_type%type
88: ,o_amount pay_personal_payment_methods_f.amount%type
89: ,o_external_account_id pay_external_accounts.external_account_id%type
90: ,o_attribute_category pay_personal_payment_methods_f.attribute_category%type
91: ,o_attribute1 pay_personal_payment_methods_f.attribute1%type

Line 159: -- P_TRANSACTION_STEP_ID is from PAY_PSS_TRANSACTION_STEPS.

155: -- {Start Of Comments}
156: --
157: -- Description:
158: -- Writes PPM information to HR transaction tables.
159: -- P_TRANSACTION_STEP_ID is from PAY_PSS_TRANSACTION_STEPS.
160: -- P_FORCE_NEW_TRANSACTION forces a new transaction to be created.
161: --
162: -- Prerequisites:
163: -- None.