APPS.CSP_PACKLIST_SERIAL_LOTS_PKG dependencies on FND_API

Line 33: If (px_PACKLIST_SERIAL_LOT_ID IS NULL) OR (px_PACKLIST_SERIAL_LOT_ID = FND_API.G_MISS_NUM) then

29:
30: IS
31: CURSOR C2 IS SELECT CSP_PACKLIST_SERIAL_LOTS_S1.nextval FROM sys.dual;
32: BEGIN
33: If (px_PACKLIST_SERIAL_LOT_ID IS NULL) OR (px_PACKLIST_SERIAL_LOT_ID = FND_API.G_MISS_NUM) then
34: OPEN C2;
35: FETCH C2 INTO px_PACKLIST_SERIAL_LOT_ID;
36: CLOSE C2;
37: End If;

Line 54: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),

50: SERIAL_NUMBER
51: ) VALUES (
52: px_PACKLIST_SERIAL_LOT_ID,
53: G_USER_ID,
54: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),
55: G_USER_ID,
56: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),
57: G_LOGIN_ID,
58: decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PACKLIST_LINE_ID),

Line 56: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),

52: px_PACKLIST_SERIAL_LOT_ID,
53: G_USER_ID,
54: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),
55: G_USER_ID,
56: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),
57: G_LOGIN_ID,
58: decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PACKLIST_LINE_ID),
59: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
60: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),

Line 58: decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PACKLIST_LINE_ID),

54: decode(p_CREATION_DATE,fnd_api.g_miss_date,to_date(null),p_creation_date),
55: G_USER_ID,
56: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),
57: G_LOGIN_ID,
58: decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PACKLIST_LINE_ID),
59: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
60: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
61: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
62: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),

Line 59: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),

55: G_USER_ID,
56: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),
57: G_LOGIN_ID,
58: decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PACKLIST_LINE_ID),
59: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
60: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
61: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
62: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
63: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER));

Line 60: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),

56: decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),p_last_update_date),
57: G_LOGIN_ID,
58: decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PACKLIST_LINE_ID),
59: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
60: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
61: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
62: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
63: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER));
64: End Insert_Row;

Line 61: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),

57: G_LOGIN_ID,
58: decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PACKLIST_LINE_ID),
59: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
60: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
61: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
62: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
63: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER));
64: End Insert_Row;
65:

Line 62: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),

58: decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PACKLIST_LINE_ID),
59: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
60: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
61: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
62: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
63: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER));
64: End Insert_Row;
65:
66: PROCEDURE Update_Row(

Line 63: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER));

59: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
60: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
61: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
62: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
63: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER));
64: End Insert_Row;
65:
66: PROCEDURE Update_Row(
67: p_PACKLIST_SERIAL_LOT_ID NUMBER,

Line 84: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

80: IS
81: BEGIN
82: Update CSP_PACKLIST_SERIAL_LOTS
83: SET
84: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
85: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
86: LAST_UPDATED_BY = G_USER_ID,
87: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
88: LAST_UPDATE_LOGIN = G_LOGIN_ID,

Line 85: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),

81: BEGIN
82: Update CSP_PACKLIST_SERIAL_LOTS
83: SET
84: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
85: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
86: LAST_UPDATED_BY = G_USER_ID,
87: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
88: LAST_UPDATE_LOGIN = G_LOGIN_ID,
89: PACKLIST_LINE_ID = decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, PACKLIST_LINE_ID, p_PACKLIST_LINE_ID),

Line 87: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),

83: SET
84: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
85: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
86: LAST_UPDATED_BY = G_USER_ID,
87: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
88: LAST_UPDATE_LOGIN = G_LOGIN_ID,
89: PACKLIST_LINE_ID = decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, PACKLIST_LINE_ID, p_PACKLIST_LINE_ID),
90: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
91: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),

Line 89: PACKLIST_LINE_ID = decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, PACKLIST_LINE_ID, p_PACKLIST_LINE_ID),

85: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
86: LAST_UPDATED_BY = G_USER_ID,
87: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
88: LAST_UPDATE_LOGIN = G_LOGIN_ID,
89: PACKLIST_LINE_ID = decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, PACKLIST_LINE_ID, p_PACKLIST_LINE_ID),
90: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
91: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
92: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
93: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),

Line 90: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),

86: LAST_UPDATED_BY = G_USER_ID,
87: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
88: LAST_UPDATE_LOGIN = G_LOGIN_ID,
89: PACKLIST_LINE_ID = decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, PACKLIST_LINE_ID, p_PACKLIST_LINE_ID),
90: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
91: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
92: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
93: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
94: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER)

Line 91: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),

87: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
88: LAST_UPDATE_LOGIN = G_LOGIN_ID,
89: PACKLIST_LINE_ID = decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, PACKLIST_LINE_ID, p_PACKLIST_LINE_ID),
90: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
91: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
92: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
93: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
94: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER)
95: where PACKLIST_SERIAL_LOT_ID = p_PACKLIST_SERIAL_LOT_ID;

Line 92: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),

88: LAST_UPDATE_LOGIN = G_LOGIN_ID,
89: PACKLIST_LINE_ID = decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, PACKLIST_LINE_ID, p_PACKLIST_LINE_ID),
90: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
91: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
92: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
93: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
94: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER)
95: where PACKLIST_SERIAL_LOT_ID = p_PACKLIST_SERIAL_LOT_ID;
96:

Line 93: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),

89: PACKLIST_LINE_ID = decode( p_PACKLIST_LINE_ID, FND_API.G_MISS_NUM, PACKLIST_LINE_ID, p_PACKLIST_LINE_ID),
90: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
91: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
92: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
93: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
94: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER)
95: where PACKLIST_SERIAL_LOT_ID = p_PACKLIST_SERIAL_LOT_ID;
96:
97: If (SQL%NOTFOUND) then

Line 94: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER)

90: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
91: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
92: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
93: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
94: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER)
95: where PACKLIST_SERIAL_LOT_ID = p_PACKLIST_SERIAL_LOT_ID;
96:
97: If (SQL%NOTFOUND) then
98: RAISE NO_DATA_FOUND;