DBA Data[Home] [Help]

APPS.IGC_CC_PO_LINE_LOCS_ALL_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 24: p_po_line_locs_rec IN po_line_locations_all%ROWTYPE

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

Line 52: INSERT INTO po_line_locations_all (

48:
49: x_return_status := FND_API.G_RET_STS_SUCCESS ;
50:
51:
52: INSERT INTO po_line_locations_all (
53: line_location_id,
54: last_update_date,
55: last_updated_by,
56: po_header_id,

Line 365: p_po_line_locs_rec IN po_line_locations_all%ROWTYPE

361: x_return_status OUT NOCOPY VARCHAR2,
362: x_msg_count OUT NOCOPY NUMBER,
363: x_msg_data OUT NOCOPY VARCHAR2,
364: ---------------------------------------------
365: p_po_line_locs_rec IN po_line_locations_all%ROWTYPE
366: )
367: IS
368:
369: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 393: UPDATE po_line_locations_all

389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS ;
391:
392: /* update */
393: UPDATE po_line_locations_all
394: SET
395: line_location_id = p_po_line_locs_rec.line_location_id ,
396: last_update_date = p_po_line_locs_rec.last_update_date,
397: last_updated_by = p_po_line_locs_rec.last_updated_by ,