APPS.PO_GA_ORG_ASSIGN_DRAFT_PKG dependencies on PO_GA_ORG_ASSIGN_DRAFT

Line 1: PACKAGE BODY PO_GA_ORG_ASSIGN_DRAFT_PKG AS

1: PACKAGE BODY PO_GA_ORG_ASSIGN_DRAFT_PKG AS
2: /* $Header: PO_GA_ORG_ASSIGN_DRAFT_PKG.plb 120.6 2006/09/28 23:02:36 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_GA_ORG_ASSIGN_DRAFT_PKG');

Line 2: /* $Header: PO_GA_ORG_ASSIGN_DRAFT_PKG.plb 120.6 2006/09/28 23:02:36 bao noship $ */

1: PACKAGE BODY PO_GA_ORG_ASSIGN_DRAFT_PKG AS
2: /* $Header: PO_GA_ORG_ASSIGN_DRAFT_PKG.plb 120.6 2006/09/28 23:02:36 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_GA_ORG_ASSIGN_DRAFT_PKG');
6:

Line 5: PO_LOG.get_package_base('PO_GA_ORG_ASSIGN_DRAFT_PKG');

1: PACKAGE BODY PO_GA_ORG_ASSIGN_DRAFT_PKG AS
2: /* $Header: PO_GA_ORG_ASSIGN_DRAFT_PKG.plb 120.6 2006/09/28 23:02:36 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_GA_ORG_ASSIGN_DRAFT_PKG');
6:
7: -----------------------------------------------------------------------
8: --Start of Comments
9: --Name: delete_rows

Line 49: DELETE FROM po_ga_org_assign_draft

45: IF (PO_LOG.d_proc) THEN
46: PO_LOG.proc_begin(d_module);
47: END IF;
48:
49: DELETE FROM po_ga_org_assign_draft
50: WHERE draft_id = p_draft_id
51: AND org_assignment_id = NVL(p_org_assignment_id, org_assignment_id);
52:
53: EXCEPTION

Line 114: PO_GA_ORG_ASSIGN_DRAFT_PVT.draft_changes_exist

110: PO_LOG.proc_begin(d_module);
111: END IF;
112:
113: x_record_already_exist_tbl :=
114: PO_GA_ORG_ASSIGN_DRAFT_PVT.draft_changes_exist
115: ( p_draft_id_tbl => p_draft_id_tbl,
116: p_org_assignment_id_tbl => p_org_assignment_id_tbl
117: );
118:

Line 151: INSERT INTO po_ga_org_assign_draft

147: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
148: END IF;
149:
150: FORALL i IN 1..p_org_assignment_id_tbl.COUNT
151: INSERT INTO po_ga_org_assign_draft
152: (
153: draft_id,
154: delete_flag,
155: change_accepted_flag,

Line 194: UPDATE po_ga_org_assign_draft

190: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
191: END IF;
192:
193: FORALL i IN 1..p_org_assignment_id_tbl.COUNT
194: UPDATE po_ga_org_assign_draft
195: SET delete_flag = p_delete_flag_tbl(i)
196: WHERE org_assignment_id = p_org_assignment_id_tbl(i)
197: AND draft_id = p_draft_id_tbl(i)
198: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 344: FROM po_ga_org_assign_draft PGOAD

340:
341: DELETE FROM po_ga_org_assignments PGOA
342: WHERE PGOA.org_assignment_id IN
343: ( SELECT PGOAD.org_assignment_id
344: FROM po_ga_org_assign_draft PGOAD
345: WHERE PGOAD.draft_id = p_draft_id
346: AND PGOAD.delete_flag = 'Y'
347: AND NVL(PGOAD.change_accepted_flag, 'Y') = 'Y' );
348:

Line 371: FROM po_ga_org_assign_draft PGOAD

367: PGOAD.creation_date,
368: PGOAD.created_by,
369: PGOAD.last_update_login,
370: PGOAD.purchasing_org_id
371: FROM po_ga_org_assign_draft PGOAD
372: WHERE PGOAD.draft_id = p_draft_id
373: AND NVL(PGOAD.change_accepted_flag, 'Y') = 'Y'
374: ) PGOADV
375: ON (PGOA.org_assignment_id = PGOADV.org_assignment_id)

Line 461: FROM po_ga_org_assign_draft

457: END IF;
458:
459: SELECT 1
460: INTO l_dummy
461: FROM po_ga_org_assign_draft
462: WHERE org_assignment_id = p_org_assignment_id
463: AND draft_id = p_draft_id
464: FOR UPDATE NOWAIT;
465:

Line 518: END PO_GA_ORG_ASSIGN_DRAFT_PKG;

514: WHEN NO_DATA_FOUND THEN
515: NULL;
516: END lock_transaction_record;
517:
518: END PO_GA_ORG_ASSIGN_DRAFT_PKG;