APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_VARCHAR2_240_TBL_TYPE

Line 1056: l_ntf_recipient_name_tbl system.pa_varchar2_240_tbl_type;

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

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

1190: ----------------------------------------------------------------------
1191: PROCEDURE Start_Adv_Notification_WF (
1192: p_action_code IN pa_action_set_lines.action_code%TYPE
1193: , p_ntf_recipient_person_id_tbl IN system.pa_num_tbl_type := NULL
1194: , p_ntf_recipient_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1195: , p_wf_user_name IN VARCHAR2 := NULL
1196: , p_wf_process IN VARCHAR2
1197: , p_wf_item_type IN VARCHAR2 := 'PARADVWF'
1198: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE