DBA Data[Home] [Help]

APPS.PA_MULTI_ORG dependencies on PA_FUNCTION_TRANSACTIONS

Line 21: x_stage := 'INSERT INTO PA_FUNCTION_TRANSACTIONS';

17: INTO x_org_id
18: FROM pa_implementations;
19:
20: -- Copy Function Transactions
21: x_stage := 'INSERT INTO PA_FUNCTION_TRANSACTIONS';
22: INSERT INTO pa_function_transactions(
23: application_id
24: , function_code
25: , function_transaction_code

Line 22: INSERT INTO pa_function_transactions(

18: FROM pa_implementations;
19:
20: -- Copy Function Transactions
21: x_stage := 'INSERT INTO PA_FUNCTION_TRANSACTIONS';
22: INSERT INTO pa_function_transactions(
23: application_id
24: , function_code
25: , function_transaction_code
26: , function_transaction_name

Line 48: FROM pa_function_transactions_all ft

44: , x_login
45: , ft.enabled_flag
46: , ft.description
47: , x_org_id
48: FROM pa_function_transactions_all ft
49: WHERE org_id = -3113
50: AND NOT EXISTS (
51: SELECT NULL
52: FROM pa_function_transactions

Line 52: FROM pa_function_transactions

48: FROM pa_function_transactions_all ft
49: WHERE org_id = -3113
50: AND NOT EXISTS (
51: SELECT NULL
52: FROM pa_function_transactions
53: WHERE org_id = x_org_id
54: AND application_id = ft.application_id
55: AND function_code = ft.function_code
56: AND function_transaction_code = ft.function_transaction_code );