DBA Data[Home] [Help]

APPS.HR_PAY_RATE_SS dependencies on WF_ITEMS

Line 2694: p_item_type IN wf_items.item_type%type ,

2690:
2691:
2692:
2693: PROCEDURE validate_salary_ins_api_java (
2694: p_item_type IN wf_items.item_type%type ,
2695: p_item_key IN wf_items.item_key%TYPE ,
2696: p_Act_id IN NUMBER,
2697: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ ,
2698: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ,

Line 2695: p_item_key IN wf_items.item_key%TYPE ,

2691:
2692:
2693: PROCEDURE validate_salary_ins_api_java (
2694: p_item_type IN wf_items.item_type%type ,
2695: p_item_key IN wf_items.item_key%TYPE ,
2696: p_Act_id IN NUMBER,
2697: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ ,
2698: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ,
2699: p_validate IN BOOLEAN DEFAULT FALSE ,

Line 2932: p_item_type IN wf_items.item_type%type

2928: -- Procedure: maintain_txn_java
2929: -- Procedure to store data into txn table
2930: ----------------------------------------------------------*/
2931: PROCEDURE maintain_txn_java (
2932: p_item_type IN wf_items.item_type%type
2933: ,p_item_key IN wf_items.item_key%TYPE
2934: ,p_Act_id IN NUMBER
2935: ,p_ltt_salary_data in sshr_sal_prop_tab_typ
2936: ,p_ltt_component in sshr_sal_comp_tab_typ

Line 2933: ,p_item_key IN wf_items.item_key%TYPE

2929: -- Procedure to store data into txn table
2930: ----------------------------------------------------------*/
2931: PROCEDURE maintain_txn_java (
2932: p_item_type IN wf_items.item_type%type
2933: ,p_item_key IN wf_items.item_key%TYPE
2934: ,p_Act_id IN NUMBER
2935: ,p_ltt_salary_data in sshr_sal_prop_tab_typ
2936: ,p_ltt_component in sshr_sal_comp_tab_typ
2937: ,p_review_proc_call in VARCHAR2

Line 2964: c_item_type in wf_items.item_type%type

2960: ln_creator_person_id NUMBER;
2961: result VARCHAR2(100);
2962:
2963: cursor get_transaction_step_id(
2964: c_item_type in wf_items.item_type%type
2965: ,c_item_key in wf_items.item_key%type
2966: ) IS
2967: SELECT transaction_step_id
2968: FROM hr_api_transaction_steps

Line 2965: ,c_item_key in wf_items.item_key%type

2961: result VARCHAR2(100);
2962:
2963: cursor get_transaction_step_id(
2964: c_item_type in wf_items.item_type%type
2965: ,c_item_key in wf_items.item_key%type
2966: ) IS
2967: SELECT transaction_step_id
2968: FROM hr_api_transaction_steps
2969: WHERE item_type = c_item_type

Line 4403: p_item_type IN wf_items.item_type%type ,

4399: -- ---------------------------------------------------------
4400: -- Procedure to get salary details from transaction tables
4401: -- --------------------------------------------------------------
4402: PROCEDURE get_transaction_details (
4403: p_item_type IN wf_items.item_type%type ,
4404: p_item_key IN wf_items.item_key%TYPE ,
4405: p_Act_id IN VARCHAR2,
4406: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ,
4407: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS

Line 4404: p_item_key IN wf_items.item_key%TYPE ,

4400: -- Procedure to get salary details from transaction tables
4401: -- --------------------------------------------------------------
4402: PROCEDURE get_transaction_details (
4403: p_item_type IN wf_items.item_type%type ,
4404: p_item_key IN wf_items.item_key%TYPE ,
4405: p_Act_id IN VARCHAR2,
4406: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ,
4407: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS
4408:

Line 5121: p_item_type IN wf_items.item_type%type ,

5117: -- ---------------------------------------------------------
5118: -- Procedure to get salary details from transaction tables
5119: -- --------------------------------------------------------------
5120: PROCEDURE get_txn_details_for_review (
5121: p_item_type IN wf_items.item_type%type ,
5122: p_item_key IN wf_items.item_key%TYPE ,
5123: p_transaction_step_id IN VARCHAR2,
5124: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ,
5125: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS

Line 5122: p_item_key IN wf_items.item_key%TYPE ,

5118: -- Procedure to get salary details from transaction tables
5119: -- --------------------------------------------------------------
5120: PROCEDURE get_txn_details_for_review (
5121: p_item_type IN wf_items.item_type%type ,
5122: p_item_key IN wf_items.item_key%TYPE ,
5123: p_transaction_step_id IN VARCHAR2,
5124: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ,
5125: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS
5126: