APPS.AS_IMPORT_INTERFACE_PKG dependencies on AS_IMPORT_INTERFACE

Line 1: PACKAGE BODY AS_IMPORT_INTERFACE_PKG as

1: PACKAGE BODY AS_IMPORT_INTERFACE_PKG as
2: /* $Header: asxtlimb.pls 115.8 2004/01/19 11:30:22 rramakri ship $ */
3: -- Start of Comments
4: -- Package name : AS_IMPORT_INTERFACE_PKG
5: -- Purpose :

Line 4: -- Package name : AS_IMPORT_INTERFACE_PKG

1: PACKAGE BODY AS_IMPORT_INTERFACE_PKG as
2: /* $Header: asxtlimb.pls 115.8 2004/01/19 11:30:22 rramakri ship $ */
3: -- Start of Comments
4: -- Package name : AS_IMPORT_INTERFACE_PKG
5: -- Purpose :
6: -- History : added 7 new columns manually
7: -- NOTE : Due to bug in JDBC, The G_MISS_DATE value
8: -- passed from UI is not matching with

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_IMPORT_INTERFACE_PKG';

15: -- similar variable needs to be applied again.
16: -- End of Comments
17:
18:
19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_IMPORT_INTERFACE_PKG';
20: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtlimb.pls';
21:
22: PROCEDURE Insert_Row(
23: px_IMPORT_INTERFACE_ID IN OUT NOCOPY NUMBER,

Line 256: CURSOR C2 IS SELECT AS_IMPORT_INTERFACE_S.nextval FROM sys.dual;

252: p_PRIMARY_PER_TYPE VARCHAR2,
253: p_DEPARTMENT_CODE VARCHAR2)
254:
255: IS
256: CURSOR C2 IS SELECT AS_IMPORT_INTERFACE_S.nextval FROM sys.dual;
257: BEGIN
258: If (px_IMPORT_INTERFACE_ID IS NULL) OR (px_IMPORT_INTERFACE_ID = FND_API.G_MISS_NUM) then
259: OPEN C2;
260: FETCH C2 INTO px_IMPORT_INTERFACE_ID;

Line 263: INSERT INTO AS_IMPORT_INTERFACE(

259: OPEN C2;
260: FETCH C2 INTO px_IMPORT_INTERFACE_ID;
261: CLOSE C2;
262: End If;
263: INSERT INTO AS_IMPORT_INTERFACE(
264: IMPORT_INTERFACE_ID,
265: LAST_UPDATE_DATE,
266: LAST_UPDATED_BY,
267: CREATION_DATE,

Line 1438: Update AS_IMPORT_INTERFACE

1434: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
1435:
1436:
1437: BEGIN
1438: Update AS_IMPORT_INTERFACE
1439: SET
1440: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, rosetta_g_mistake_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
1441: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
1442: CREATION_DATE = decode( p_CREATION_DATE, rosetta_g_mistake_date, CREATION_DATE, p_CREATION_DATE),

Line 1691: DELETE FROM AS_IMPORT_INTERFACE

1687: PROCEDURE Delete_Row(
1688: p_IMPORT_INTERFACE_ID NUMBER)
1689: IS
1690: BEGIN
1691: DELETE FROM AS_IMPORT_INTERFACE
1692: WHERE IMPORT_INTERFACE_ID = p_IMPORT_INTERFACE_ID;
1693: If (SQL%NOTFOUND) then
1694: RAISE NO_DATA_FOUND;
1695: End If;

Line 1934: FROM AS_IMPORT_INTERFACE

1930:
1931: IS
1932: CURSOR C IS
1933: SELECT *
1934: FROM AS_IMPORT_INTERFACE
1935: WHERE IMPORT_INTERFACE_ID = p_IMPORT_INTERFACE_ID
1936: FOR UPDATE of IMPORT_INTERFACE_ID NOWAIT;
1937: Recinfo C%ROWTYPE;
1938: BEGIN

Line 2626: End AS_IMPORT_INTERFACE_PKG;

2622: APP_EXCEPTION.RAISE_EXCEPTION;
2623: End If;
2624: END Lock_Row;
2625:
2626: End AS_IMPORT_INTERFACE_PKG;