APPS.IGC_CC_PO_DIST_ALL_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 23: p_po_dist_rec IN po_distributions_all%ROWTYPE

19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2,
22: ---------------------------------------------
23: p_po_dist_rec IN po_distributions_all%ROWTYPE
24: )
25: IS
26:
27: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';

Line 52: -- po_distributions_all. This as as part of the

48: x_return_status := FND_API.G_RET_STS_SUCCESS ;
49:
50:
51: -- Added column distribution_type when inserting in
52: -- po_distributions_all. This as as part of the
53: -- changes PO have done in PRC.FP.J (3173178)
54: -- PO Standalone patch 3205071 is a pre-req for this change
55: -- Bidisha S, 23 Oct 2003
56: INSERT INTO po_distributions_all (

Line 56: INSERT INTO po_distributions_all (

52: -- po_distributions_all. This as as part of the
53: -- changes PO have done in PRC.FP.J (3173178)
54: -- PO Standalone patch 3205071 is a pre-req for this change
55: -- Bidisha S, 23 Oct 2003
56: INSERT INTO po_distributions_all (
57: po_distribution_id,
58: last_update_date,
59: last_updated_by,
60: po_header_id,

Line 306: p_po_dist_rec IN po_distributions_all%ROWTYPE

302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: ---------------------------------------------
306: p_po_dist_rec IN po_distributions_all%ROWTYPE
307:
308: )
309: IS
310:

Line 335: UPDATE po_distributions_all

331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS ;
333:
334: /* update */
335: UPDATE po_distributions_all
336: SET
337: last_update_date = p_po_dist_rec.last_update_date,
338: last_updated_by = p_po_dist_rec.last_updated_by,
339: po_header_id = p_po_dist_rec.po_header_id,

Line 498: p_po_distribution_id IN po_distributions_all.po_distribution_id%TYPE

494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_count OUT NOCOPY NUMBER,
496: x_msg_data OUT NOCOPY VARCHAR2,
497: ---------------------------------------------
498: p_po_distribution_id IN po_distributions_all.po_distribution_id%TYPE
499: )
500: IS
501:
502: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';

Line 525: DELETE FROM po_distributions_all

521: END IF;
522:
523: x_return_status := FND_API.G_RET_STS_SUCCESS ;
524:
525: DELETE FROM po_distributions_all
526: WHERE
527: po_distribution_id = p_po_distribution_id;
528:
529: