APPS.PA_DISTRIBUTION_LISTS_PVT dependencies on PA_DIST_LIST_ITEMS

Line 217: Delete from PA_DIST_LIST_ITEMS

213: AND p_validate_only <> fnd_api.g_true) then
214: PA_DISTRIBUTION_LISTS_PKG.DELETE_ROW (
215: P_LIST_ID => P_LIST_ID) ;
216: IF (P_DELETE_LIST_ITEM_FLAG = 'Y') then
217: Delete from PA_DIST_LIST_ITEMS
218: where list_id = p_list_id;
219: End if;
220: End if;
221: -- Commit the changes if requested

Line 328: PA_DIST_LIST_ITEMS_PKG.INSERT_ROW (

324: END IF;
325:
326: If (x_return_status = fnd_api.g_ret_sts_success
327: AND p_validate_only <> fnd_api.g_true) then
328: PA_DIST_LIST_ITEMS_PKG.INSERT_ROW (
329: P_LIST_ITEM_ID => P_LIST_ITEM_ID,
330: P_LIST_ID => P_LIST_ID ,
331: P_RECIPIENT_TYPE => P_RECIPIENT_TYPE ,
332: P_RECIPIENT_ID => P_RECIPIENT_ID,

Line 394: from pa_dist_list_items

390: IS
391: l_error_msg_code varchar2(30);
392: Cursor check_record_changed IS
393: select rowid
394: from pa_dist_list_items
395: where list_item_id = p_list_item_id
396: and record_version_number = p_record_version_number
397: for update ;
398:

Line 465: PA_DIST_LIST_ITEMS_PKG.UPDATE_ROW (

461: CLOSE check_record_changed;
462: end if;
463: If (x_return_status = fnd_api.g_ret_sts_success
464: AND p_validate_only <> fnd_api.g_true) then
465: PA_DIST_LIST_ITEMS_PKG.UPDATE_ROW (
466: P_LIST_ITEM_ID => P_LIST_ITEM_ID,
467: P_LIST_ID => P_LIST_ID ,
468: P_RECIPIENT_TYPE => P_RECIPIENT_TYPE ,
469: P_RECIPIENT_ID => P_RECIPIENT_ID,

Line 519: from pa_dist_list_items

515: )
516: IS
517: Cursor check_record_changed IS
518: select rowid
519: from pa_dist_list_items
520: where list_item_id = p_list_item_id
521: and record_version_number = p_record_version_number
522: for update ;
523:

Line 553: PA_DIST_LIST_ITEMS_PKG.DELETE_ROW (

549: -- Delete row
550: If (x_return_status = FND_API.G_RET_STS_SUCCESS
551: AND p_validate_only <> fnd_api.g_true
552: AND pa_distribution_list_utils.Check_valid_dist_list_item_id(p_list_item_id) = 'T') then
553: PA_DIST_LIST_ITEMS_PKG.DELETE_ROW (
554: P_LIST_ITEM_ID => P_LIST_ITEM_ID) ;
555: End if;
556: -- Commit the changes if requested
557: if (p_commit = FND_API.G_TRUE