APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_VARCHAR2_240_TBL_TYPE

Line 1057: l_ntf_recipient_name_tbl system.pa_varchar2_240_tbl_type;

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);
1061: l_msg_index_out NUMBER;

Line 1195: , p_ntf_recipient_name_tbl IN system.pa_varchar2_240_tbl_type := NULL

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'
1199: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE