APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_NUM_TBL_TYPE

Line 1056: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;

1052: AND trunc(sysdate) BETWEEN per.effective_start_date
1053: AND per.effective_end_date;
1054: -- End of Performance Fix 4898314 SQL ID 14906422
1055:
1056: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;
1057: l_ntf_recipient_name_tbl system.pa_varchar2_240_tbl_type;
1058: l_return_status VARCHAR2(1);
1059: l_wf_process VARCHAR2(30);
1060: l_encoded_message_text VARCHAR2(2000);

Line 1194: , p_ntf_recipient_person_id_tbl IN system.pa_num_tbl_type := NULL

1190: -- Start Workflow process to send advertisement notification
1191: ----------------------------------------------------------------------
1192: PROCEDURE Start_Adv_Notification_WF (
1193: p_action_code IN pa_action_set_lines.action_code%TYPE
1194: , p_ntf_recipient_person_id_tbl IN system.pa_num_tbl_type := NULL
1195: , p_ntf_recipient_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1196: , p_wf_user_name IN VARCHAR2 := NULL
1197: , p_wf_process IN VARCHAR2
1198: , p_wf_item_type IN VARCHAR2 := 'PARADVWF'

Line 1205: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;

1201: , p_insert_audit_flag IN VARCHAR2 := 'T'
1202: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1203: ) IS
1204:
1205: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;
1206: l_wf_item_key NUMBER;
1207: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
1208: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
1209: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;