DBA Data[Home] [Help]

APPS.PAY_ASSG_COST_SS dependencies on HR_API_TRANSACTION_STEPS

Line 56: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

52: ) is
53: l_proc varchar2(100) := g_package||'CREATE_ASSG_COST';
54:
55: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
56: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
57: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
58: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
59: l_count NUMBER;
60: l_result VARCHAR2(100);

Line 57: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;

53: l_proc varchar2(100) := g_package||'CREATE_ASSG_COST';
54:
55: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
56: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
57: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
58: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
59: l_count NUMBER;
60: l_result VARCHAR2(100);
61: L_EFFECTIVE_DATE DATE;

Line 581: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

577: ) as
578: l_proc varchar2(100) := g_package||'UPDATE_ASSG_COST';
579:
580: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
581: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
582: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
583: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
584: l_count NUMBER;
585: l_effective_date date;

Line 582: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;

578: l_proc varchar2(100) := g_package||'UPDATE_ASSG_COST';
579:
580: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
581: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
582: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
583: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
584: l_count NUMBER;
585: l_effective_date date;
586: l_result varchar2(2000);

Line 1076: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

1072: ) is
1073: l_proc varchar2(100) := g_package||'DELETE_ASSG_COST';
1074:
1075: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
1076: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1077: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
1078: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
1079: l_count NUMBER;
1080: l_result VARCHAR2(100);

Line 1077: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;

1073: l_proc varchar2(100) := g_package||'DELETE_ASSG_COST';
1074:
1075: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
1076: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1077: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
1078: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
1079: l_count NUMBER;
1080: l_result VARCHAR2(100);
1081: L_EFFECTIVE_DATE DATE;