DBA Data[Home] [Help]

APPS.HR_PAY_RATE_SS dependencies on WF_ITEMS

Line 2794: p_item_type IN wf_items.item_type%type ,

2790:
2791:
2792:
2793: PROCEDURE validate_salary_ins_api_java (
2794: p_item_type IN wf_items.item_type%type ,
2795: p_item_key IN wf_items.item_key%TYPE ,
2796: p_Act_id IN NUMBER,
2797: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ ,
2798: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ,

Line 2795: p_item_key IN wf_items.item_key%TYPE ,

2791:
2792:
2793: PROCEDURE validate_salary_ins_api_java (
2794: p_item_type IN wf_items.item_type%type ,
2795: p_item_key IN wf_items.item_key%TYPE ,
2796: p_Act_id IN NUMBER,
2797: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ ,
2798: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ,
2799: p_validate IN BOOLEAN DEFAULT FALSE ,

Line 3089: p_item_type IN wf_items.item_type%type

3085: -- Procedure: maintain_txn_java
3086: -- Procedure to store data into txn table
3087: ----------------------------------------------------------*/
3088: PROCEDURE maintain_txn_java (
3089: p_item_type IN wf_items.item_type%type
3090: ,p_item_key IN wf_items.item_key%TYPE
3091: ,p_Act_id IN NUMBER
3092: ,p_ltt_salary_data in sshr_sal_prop_tab_typ
3093: ,p_ltt_component in sshr_sal_comp_tab_typ

Line 3090: ,p_item_key IN wf_items.item_key%TYPE

3086: -- Procedure to store data into txn table
3087: ----------------------------------------------------------*/
3088: PROCEDURE maintain_txn_java (
3089: p_item_type IN wf_items.item_type%type
3090: ,p_item_key IN wf_items.item_key%TYPE
3091: ,p_Act_id IN NUMBER
3092: ,p_ltt_salary_data in sshr_sal_prop_tab_typ
3093: ,p_ltt_component in sshr_sal_comp_tab_typ
3094: ,p_review_proc_call in VARCHAR2

Line 3121: c_item_type in wf_items.item_type%type

3117: ln_creator_person_id NUMBER;
3118: result VARCHAR2(100);
3119:
3120: cursor get_transaction_step_id(
3121: c_item_type in wf_items.item_type%type
3122: ,c_item_key in wf_items.item_key%type
3123: ) IS
3124: SELECT transaction_step_id
3125: FROM hr_api_transaction_steps

Line 3122: ,c_item_key in wf_items.item_key%type

3118: result VARCHAR2(100);
3119:
3120: cursor get_transaction_step_id(
3121: c_item_type in wf_items.item_type%type
3122: ,c_item_key in wf_items.item_key%type
3123: ) IS
3124: SELECT transaction_step_id
3125: FROM hr_api_transaction_steps
3126: WHERE item_type = c_item_type

Line 4564: p_item_type IN wf_items.item_type%type ,

4560: -- ---------------------------------------------------------
4561: -- Procedure to get salary details from transaction tables
4562: -- --------------------------------------------------------------
4563: PROCEDURE get_transaction_details (
4564: p_item_type IN wf_items.item_type%type ,
4565: p_item_key IN wf_items.item_key%TYPE ,
4566: p_Act_id IN VARCHAR2,
4567: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ,
4568: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS

Line 4565: p_item_key IN wf_items.item_key%TYPE ,

4561: -- Procedure to get salary details from transaction tables
4562: -- --------------------------------------------------------------
4563: PROCEDURE get_transaction_details (
4564: p_item_type IN wf_items.item_type%type ,
4565: p_item_key IN wf_items.item_key%TYPE ,
4566: p_Act_id IN VARCHAR2,
4567: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ,
4568: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS
4569:

Line 5282: p_item_type IN wf_items.item_type%type ,

5278: -- ---------------------------------------------------------
5279: -- Procedure to get salary details from transaction tables
5280: -- --------------------------------------------------------------
5281: PROCEDURE get_txn_details_for_review (
5282: p_item_type IN wf_items.item_type%type ,
5283: p_item_key IN wf_items.item_key%TYPE ,
5284: p_transaction_step_id IN VARCHAR2,
5285: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ,
5286: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS

Line 5283: p_item_key IN wf_items.item_key%TYPE ,

5279: -- Procedure to get salary details from transaction tables
5280: -- --------------------------------------------------------------
5281: PROCEDURE get_txn_details_for_review (
5282: p_item_type IN wf_items.item_type%type ,
5283: p_item_key IN wf_items.item_key%TYPE ,
5284: p_transaction_step_id IN VARCHAR2,
5285: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ,
5286: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS
5287: