DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on PA_DISTRIBUTION_LIST_UTILS

Line 1053: l_user_names pa_distribution_list_utils.pa_vc_1000_150;

1049: AND trunc(sysdate) between papf.EFFECTIVE_START_DATE
1050: and Nvl(papf.effective_end_date, Sysdate + 1)
1051: and trunc(sysdate) between fu.START_DATE and nvl(fu.END_DATE, sysdate+1);
1052:
1053: l_user_names pa_distribution_list_utils.pa_vc_1000_150;
1054: l_full_names pa_distribution_list_utils.pa_vc_1000_150;
1055: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150;
1056: l_return_status VARCHAR2(1);
1057: l_msg_count NUMBER;

Line 1054: l_full_names pa_distribution_list_utils.pa_vc_1000_150;

1050: and Nvl(papf.effective_end_date, Sysdate + 1)
1051: and trunc(sysdate) between fu.START_DATE and nvl(fu.END_DATE, sysdate+1);
1052:
1053: l_user_names pa_distribution_list_utils.pa_vc_1000_150;
1054: l_full_names pa_distribution_list_utils.pa_vc_1000_150;
1055: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150;
1056: l_return_status VARCHAR2(1);
1057: l_msg_count NUMBER;
1058: l_msg_data VARCHAR2(2000);

Line 1055: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150;

1051: and trunc(sysdate) between fu.START_DATE and nvl(fu.END_DATE, sysdate+1);
1052:
1053: l_user_names pa_distribution_list_utils.pa_vc_1000_150;
1054: l_full_names pa_distribution_list_utils.pa_vc_1000_150;
1055: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150;
1056: l_return_status VARCHAR2(1);
1057: l_msg_count NUMBER;
1058: l_msg_data VARCHAR2(2000);
1059: i INTEGER;

Line 1130: PA_DISTRIBUTION_LIST_UTILS.get_dist_list

1126:
1127: l_INDEX := 1;
1128:
1129:
1130: PA_DISTRIBUTION_LIST_UTILS.get_dist_list
1131: (
1132: l_object_type,
1133: l_object_id,
1134:

Line 1357: l_user_names pa_distribution_list_utils.pa_vc_1000_150;

1353:
1354:
1355: L_INDEX NUMBER;
1356:
1357: l_user_names pa_distribution_list_utils.pa_vc_1000_150;
1358: l_full_names pa_distribution_list_utils.pa_vc_1000_150;
1359: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150;
1360: l_return_status VARCHAR2(1);
1361: l_msg_count NUMBER;

Line 1358: l_full_names pa_distribution_list_utils.pa_vc_1000_150;

1354:
1355: L_INDEX NUMBER;
1356:
1357: l_user_names pa_distribution_list_utils.pa_vc_1000_150;
1358: l_full_names pa_distribution_list_utils.pa_vc_1000_150;
1359: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150;
1360: l_return_status VARCHAR2(1);
1361: l_msg_count NUMBER;
1362: l_msg_data VARCHAR2(2000);

Line 1359: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150;

1355: L_INDEX NUMBER;
1356:
1357: l_user_names pa_distribution_list_utils.pa_vc_1000_150;
1358: l_full_names pa_distribution_list_utils.pa_vc_1000_150;
1359: l_email_addresses pa_distribution_list_utils.pa_vc_1000_150;
1360: l_return_status VARCHAR2(1);
1361: l_msg_count NUMBER;
1362: l_msg_data VARCHAR2(2000);
1363: i INTEGER;

Line 1435: PA_DISTRIBUTION_LIST_UTILS.get_dist_list

1431: /* add people with edit privilege first */
1432: l_INDEX := 1;
1433:
1434:
1435: PA_DISTRIBUTION_LIST_UTILS.get_dist_list
1436: (
1437:
1438: l_object_type,
1439: l_object_id,