APPS.AMS_IMP_SOURCE_LINES_PKG dependencies on AMS_IMP_SOURCE_LINES

Line 1: PACKAGE BODY AMS_IMP_SOURCE_LINES_PKG as

1: PACKAGE BODY AMS_IMP_SOURCE_LINES_PKG as
2: /* $Header: amstislb.pls 115.9 2004/01/22 01:13:53 sranka ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_IMP_SOURCE_LINES_PKG

2: /* $Header: amstislb.pls 115.9 2004/01/22 01:13:53 sranka ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_IMP_SOURCE_LINES_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_IMP_SOURCE_LINES_PKG';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_IMP_SOURCE_LINES_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstislb.pls';
19:
20:
21: ----------------------------------------------------------

Line 349: INSERT INTO AMS_IMP_SOURCE_LINES(

345:
346: px_object_version_number := 1;
347:
348:
349: INSERT INTO AMS_IMP_SOURCE_LINES(
350: import_source_line_id,
351: object_version_number,
352: last_update_date,
353: last_updated_by,

Line 1267: Update AMS_IMP_SOURCE_LINES

1263:
1264:
1265: IS
1266: BEGIN
1267: Update AMS_IMP_SOURCE_LINES
1268: SET
1269: import_source_line_id = DECODE( p_import_source_line_id, FND_API.g_miss_num, import_source_line_id, p_import_source_line_id),
1270: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
1271: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 1595: DELETE FROM AMS_IMP_SOURCE_LINES

1591: PROCEDURE Delete_Row(
1592: p_IMPORT_SOURCE_LINE_ID NUMBER)
1593: IS
1594: BEGIN
1595: DELETE FROM AMS_IMP_SOURCE_LINES
1596: WHERE IMPORT_SOURCE_LINE_ID = p_IMPORT_SOURCE_LINE_ID;
1597: If (SQL%NOTFOUND) then
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: End If;

Line 1923: FROM AMS_IMP_SOURCE_LINES

1919:
1920: IS
1921: CURSOR C IS
1922: SELECT *
1923: FROM AMS_IMP_SOURCE_LINES
1924: WHERE IMPORT_SOURCE_LINE_ID = p_IMPORT_SOURCE_LINE_ID
1925: FOR UPDATE of IMPORT_SOURCE_LINE_ID NOWAIT;
1926: Recinfo C%ROWTYPE;
1927: BEGIN

Line 2831: END AMS_IMP_SOURCE_LINES_PKG;

2827: APP_EXCEPTION.RAISE_EXCEPTION;
2828: END IF;
2829: END Lock_Row;
2830:
2831: END AMS_IMP_SOURCE_LINES_PKG;