APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_NOTIFICATION_CTRL_DRAFT

Line 1150: l_change_status_tbl PO_TBL_VARCHAR30;-- used po_ga_org_assign_draft,po_notification_ctrl_draft

1146: l_draft_id_tbl PO_TBL_NUMBER;
1147: l_delete_flag_tbl PO_TBL_VARCHAR1;
1148: l_record_already_exist_tbl PO_TBL_VARCHAR1;
1149: l_change_status VARCHAR2(30);
1150: l_change_status_tbl PO_TBL_VARCHAR30;-- used po_ga_org_assign_draft,po_notification_ctrl_draft
1151: BEGIN
1152:
1153: l_org_assignment_id_tbl:= Po_Tbl_Number();
1154: l_notification_id_tbl:= Po_Tbl_Number();

Line 1404: --delete the recored from po_notification_ctrl_draft for the given header_id and draft_id

1400: PO_LOG.stmt(d_module,d_position ,'PO_GA_ORG_ASSIGN_DRAFT_PKG.sync_draft_from_txn');
1401: END IF;
1402:
1403: /* Sync records coresponding to po_notification_controls */
1404: --delete the recored from po_notification_ctrl_draft for the given header_id and draft_id
1405: -- and then insert the data from the base table
1406: l_draft_id_tbl.DELETE;
1407: l_delete_flag_tbl.DELETE;
1408: l_change_status_tbl.DELETE;

Line 1418: FROM po_notification_ctrl_draft

1414: BULK COLLECT INTO l_notification_id_tbl,
1415: l_draft_id_tbl,
1416: l_delete_flag_tbl,
1417: l_change_status_tbl
1418: FROM po_notification_ctrl_draft
1419: WHERE po_header_id=l_po_header_id
1420: AND draft_id = p_draft_id ;
1421:
1422: FORALL i in 1 .. l_notification_id_tbl.COUNT

Line 1423: DELETE FROM po_notification_ctrl_draft pncd

1419: WHERE po_header_id=l_po_header_id
1420: AND draft_id = p_draft_id ;
1421:
1422: FORALL i in 1 .. l_notification_id_tbl.COUNT
1423: DELETE FROM po_notification_ctrl_draft pncd
1424: WHERE pncd.notification_id=l_notification_id_tbl(i)
1425: AND pncd.draft_id = p_draft_id ;
1426:
1427:

Line 1428: PO_NOTIFICATION_CTRL_DRAFT_PKG.sync_draft_from_txn

1424: WHERE pncd.notification_id=l_notification_id_tbl(i)
1425: AND pncd.draft_id = p_draft_id ;
1426:
1427:
1428: PO_NOTIFICATION_CTRL_DRAFT_PKG.sync_draft_from_txn
1429: ( p_notification_id_tbl => l_notification_id_tbl,
1430: p_draft_id_tbl => l_draft_id_tbl,
1431: p_delete_flag_tbl => l_delete_flag_tbl,
1432: x_record_already_exist_tbl => l_record_already_exist_tbl

Line 1436: UPDATE po_notification_ctrl_draft pncd

1432: x_record_already_exist_tbl => l_record_already_exist_tbl
1433: );
1434:
1435: FORALL i in 1 .. l_notification_id_tbl.COUNT
1436: UPDATE po_notification_ctrl_draft pncd
1437: SET pncd.change_status = l_change_status_tbl(i)
1438: WHERE pncd.notification_id=l_notification_id_tbl(i)
1439: AND pncd.draft_id = p_draft_id ;
1440:

Line 1443: PO_LOG.stmt(d_module,d_position ,'PO_NOTIFICATION_CTRL_DRAFT_PKG.sync_draft_from_txn');

1439: AND pncd.draft_id = p_draft_id ;
1440:
1441: d_position := 70;
1442: IF (PO_LOG.d_stmt) THEN
1443: PO_LOG.stmt(d_module,d_position ,'PO_NOTIFICATION_CTRL_DRAFT_PKG.sync_draft_from_txn');
1444: END IF;
1445:
1446: END IF; --IF( p_ignore_rev_number = 'Y' OR ( l_lock_type = 'S' OR l_lock_type IS NULL))
1447: