DBA Data[Home] [Help]

APPS.JTF_AMV_ITEMS_PKG dependencies on FND_API

Line 670: ATTRIBUTE_CATEGORY = decode(X_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,

666: ITEM_DESTINATION_TYPE = X_ITEM_DESTINATION_TYPE,
667: ACCESS_NAME = X_ACCESS_NAME,
668: DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE,
669: APPLICABLE_TO_CODE = X_APPLICABLE_TO_CODE,
670: ATTRIBUTE_CATEGORY = decode(X_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,
671: ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
672: ATTRIBUTE1 =decode(X_ATTRIBUTE1,FND_API.G_MISS_CHAR,ATTRIBUTE1,X_ATTRIBUTE1),
673: ATTRIBUTE2 =decode(X_ATTRIBUTE2,FND_API.G_MISS_CHAR,ATTRIBUTE2,X_ATTRIBUTE2),
674: ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),

Line 672: ATTRIBUTE1 =decode(X_ATTRIBUTE1,FND_API.G_MISS_CHAR,ATTRIBUTE1,X_ATTRIBUTE1),

668: DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE,
669: APPLICABLE_TO_CODE = X_APPLICABLE_TO_CODE,
670: ATTRIBUTE_CATEGORY = decode(X_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,
671: ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
672: ATTRIBUTE1 =decode(X_ATTRIBUTE1,FND_API.G_MISS_CHAR,ATTRIBUTE1,X_ATTRIBUTE1),
673: ATTRIBUTE2 =decode(X_ATTRIBUTE2,FND_API.G_MISS_CHAR,ATTRIBUTE2,X_ATTRIBUTE2),
674: ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),
675: ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),
676: ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),

Line 673: ATTRIBUTE2 =decode(X_ATTRIBUTE2,FND_API.G_MISS_CHAR,ATTRIBUTE2,X_ATTRIBUTE2),

669: APPLICABLE_TO_CODE = X_APPLICABLE_TO_CODE,
670: ATTRIBUTE_CATEGORY = decode(X_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,
671: ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
672: ATTRIBUTE1 =decode(X_ATTRIBUTE1,FND_API.G_MISS_CHAR,ATTRIBUTE1,X_ATTRIBUTE1),
673: ATTRIBUTE2 =decode(X_ATTRIBUTE2,FND_API.G_MISS_CHAR,ATTRIBUTE2,X_ATTRIBUTE2),
674: ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),
675: ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),
676: ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),
677: ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),

Line 674: ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),

670: ATTRIBUTE_CATEGORY = decode(X_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,
671: ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
672: ATTRIBUTE1 =decode(X_ATTRIBUTE1,FND_API.G_MISS_CHAR,ATTRIBUTE1,X_ATTRIBUTE1),
673: ATTRIBUTE2 =decode(X_ATTRIBUTE2,FND_API.G_MISS_CHAR,ATTRIBUTE2,X_ATTRIBUTE2),
674: ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),
675: ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),
676: ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),
677: ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),
678: ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),

Line 675: ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),

671: ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
672: ATTRIBUTE1 =decode(X_ATTRIBUTE1,FND_API.G_MISS_CHAR,ATTRIBUTE1,X_ATTRIBUTE1),
673: ATTRIBUTE2 =decode(X_ATTRIBUTE2,FND_API.G_MISS_CHAR,ATTRIBUTE2,X_ATTRIBUTE2),
674: ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),
675: ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),
676: ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),
677: ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),
678: ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),
679: ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),

Line 676: ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),

672: ATTRIBUTE1 =decode(X_ATTRIBUTE1,FND_API.G_MISS_CHAR,ATTRIBUTE1,X_ATTRIBUTE1),
673: ATTRIBUTE2 =decode(X_ATTRIBUTE2,FND_API.G_MISS_CHAR,ATTRIBUTE2,X_ATTRIBUTE2),
674: ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),
675: ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),
676: ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),
677: ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),
678: ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),
679: ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),
680: ATTRIBUTE9 =decode(X_ATTRIBUTE9,FND_API.G_MISS_CHAR,ATTRIBUTE9,X_ATTRIBUTE9),

Line 677: ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),

673: ATTRIBUTE2 =decode(X_ATTRIBUTE2,FND_API.G_MISS_CHAR,ATTRIBUTE2,X_ATTRIBUTE2),
674: ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),
675: ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),
676: ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),
677: ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),
678: ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),
679: ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),
680: ATTRIBUTE9 =decode(X_ATTRIBUTE9,FND_API.G_MISS_CHAR,ATTRIBUTE9,X_ATTRIBUTE9),
681: ATTRIBUTE10 = decode(X_ATTRIBUTE10,FND_API.G_MISS_CHAR,

Line 678: ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),

674: ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),
675: ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),
676: ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),
677: ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),
678: ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),
679: ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),
680: ATTRIBUTE9 =decode(X_ATTRIBUTE9,FND_API.G_MISS_CHAR,ATTRIBUTE9,X_ATTRIBUTE9),
681: ATTRIBUTE10 = decode(X_ATTRIBUTE10,FND_API.G_MISS_CHAR,
682: ATTRIBUTE10, X_ATTRIBUTE10),

Line 679: ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),

675: ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),
676: ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),
677: ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),
678: ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),
679: ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),
680: ATTRIBUTE9 =decode(X_ATTRIBUTE9,FND_API.G_MISS_CHAR,ATTRIBUTE9,X_ATTRIBUTE9),
681: ATTRIBUTE10 = decode(X_ATTRIBUTE10,FND_API.G_MISS_CHAR,
682: ATTRIBUTE10, X_ATTRIBUTE10),
683: ATTRIBUTE11 = decode(X_ATTRIBUTE11,FND_API.G_MISS_CHAR,

Line 680: ATTRIBUTE9 =decode(X_ATTRIBUTE9,FND_API.G_MISS_CHAR,ATTRIBUTE9,X_ATTRIBUTE9),

676: ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),
677: ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),
678: ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),
679: ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),
680: ATTRIBUTE9 =decode(X_ATTRIBUTE9,FND_API.G_MISS_CHAR,ATTRIBUTE9,X_ATTRIBUTE9),
681: ATTRIBUTE10 = decode(X_ATTRIBUTE10,FND_API.G_MISS_CHAR,
682: ATTRIBUTE10, X_ATTRIBUTE10),
683: ATTRIBUTE11 = decode(X_ATTRIBUTE11,FND_API.G_MISS_CHAR,
684: ATTRIBUTE11, X_ATTRIBUTE11),

Line 681: ATTRIBUTE10 = decode(X_ATTRIBUTE10,FND_API.G_MISS_CHAR,

677: ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),
678: ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),
679: ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),
680: ATTRIBUTE9 =decode(X_ATTRIBUTE9,FND_API.G_MISS_CHAR,ATTRIBUTE9,X_ATTRIBUTE9),
681: ATTRIBUTE10 = decode(X_ATTRIBUTE10,FND_API.G_MISS_CHAR,
682: ATTRIBUTE10, X_ATTRIBUTE10),
683: ATTRIBUTE11 = decode(X_ATTRIBUTE11,FND_API.G_MISS_CHAR,
684: ATTRIBUTE11, X_ATTRIBUTE11),
685: ATTRIBUTE12 = decode(X_ATTRIBUTE12,FND_API.G_MISS_CHAR,

Line 683: ATTRIBUTE11 = decode(X_ATTRIBUTE11,FND_API.G_MISS_CHAR,

679: ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),
680: ATTRIBUTE9 =decode(X_ATTRIBUTE9,FND_API.G_MISS_CHAR,ATTRIBUTE9,X_ATTRIBUTE9),
681: ATTRIBUTE10 = decode(X_ATTRIBUTE10,FND_API.G_MISS_CHAR,
682: ATTRIBUTE10, X_ATTRIBUTE10),
683: ATTRIBUTE11 = decode(X_ATTRIBUTE11,FND_API.G_MISS_CHAR,
684: ATTRIBUTE11, X_ATTRIBUTE11),
685: ATTRIBUTE12 = decode(X_ATTRIBUTE12,FND_API.G_MISS_CHAR,
686: ATTRIBUTE12, X_ATTRIBUTE12),
687: ATTRIBUTE13 = decode(X_ATTRIBUTE13,FND_API.G_MISS_CHAR,

Line 685: ATTRIBUTE12 = decode(X_ATTRIBUTE12,FND_API.G_MISS_CHAR,

681: ATTRIBUTE10 = decode(X_ATTRIBUTE10,FND_API.G_MISS_CHAR,
682: ATTRIBUTE10, X_ATTRIBUTE10),
683: ATTRIBUTE11 = decode(X_ATTRIBUTE11,FND_API.G_MISS_CHAR,
684: ATTRIBUTE11, X_ATTRIBUTE11),
685: ATTRIBUTE12 = decode(X_ATTRIBUTE12,FND_API.G_MISS_CHAR,
686: ATTRIBUTE12, X_ATTRIBUTE12),
687: ATTRIBUTE13 = decode(X_ATTRIBUTE13,FND_API.G_MISS_CHAR,
688: ATTRIBUTE13, X_ATTRIBUTE13),
689: ATTRIBUTE14 = decode(X_ATTRIBUTE14,FND_API.G_MISS_CHAR,

Line 687: ATTRIBUTE13 = decode(X_ATTRIBUTE13,FND_API.G_MISS_CHAR,

683: ATTRIBUTE11 = decode(X_ATTRIBUTE11,FND_API.G_MISS_CHAR,
684: ATTRIBUTE11, X_ATTRIBUTE11),
685: ATTRIBUTE12 = decode(X_ATTRIBUTE12,FND_API.G_MISS_CHAR,
686: ATTRIBUTE12, X_ATTRIBUTE12),
687: ATTRIBUTE13 = decode(X_ATTRIBUTE13,FND_API.G_MISS_CHAR,
688: ATTRIBUTE13, X_ATTRIBUTE13),
689: ATTRIBUTE14 = decode(X_ATTRIBUTE14,FND_API.G_MISS_CHAR,
690: ATTRIBUTE14, X_ATTRIBUTE14),
691: ATTRIBUTE15 = decode(X_ATTRIBUTE15,FND_API.G_MISS_CHAR,

Line 689: ATTRIBUTE14 = decode(X_ATTRIBUTE14,FND_API.G_MISS_CHAR,

685: ATTRIBUTE12 = decode(X_ATTRIBUTE12,FND_API.G_MISS_CHAR,
686: ATTRIBUTE12, X_ATTRIBUTE12),
687: ATTRIBUTE13 = decode(X_ATTRIBUTE13,FND_API.G_MISS_CHAR,
688: ATTRIBUTE13, X_ATTRIBUTE13),
689: ATTRIBUTE14 = decode(X_ATTRIBUTE14,FND_API.G_MISS_CHAR,
690: ATTRIBUTE14, X_ATTRIBUTE14),
691: ATTRIBUTE15 = decode(X_ATTRIBUTE15,FND_API.G_MISS_CHAR,
692: ATTRIBUTE15, X_ATTRIBUTE15)
693: where ITEM_ID = X_ITEM_ID;

Line 691: ATTRIBUTE15 = decode(X_ATTRIBUTE15,FND_API.G_MISS_CHAR,

687: ATTRIBUTE13 = decode(X_ATTRIBUTE13,FND_API.G_MISS_CHAR,
688: ATTRIBUTE13, X_ATTRIBUTE13),
689: ATTRIBUTE14 = decode(X_ATTRIBUTE14,FND_API.G_MISS_CHAR,
690: ATTRIBUTE14, X_ATTRIBUTE14),
691: ATTRIBUTE15 = decode(X_ATTRIBUTE15,FND_API.G_MISS_CHAR,
692: ATTRIBUTE15, X_ATTRIBUTE15)
693: where ITEM_ID = X_ITEM_ID;
694:
695: if (sql%notfound) then

Line 701: FND_API.G_MISS_CHAR, ITEM_NAME, X_ITEM_NAME),

697: end if;
698:
699: update JTF_AMV_ITEMS_TL set
700: ITEM_NAME = decode( X_ITEM_NAME,
701: FND_API.G_MISS_CHAR, ITEM_NAME, X_ITEM_NAME),
702: DESCRIPTION = decode( X_DESCRIPTION,
703: FND_API.G_MISS_CHAR, DESCRIPTION, X_DESCRIPTION),
704: TEXT_STRING = decode (X_TEXT_STRING,
705: FND_API.G_MISS_CHAR, TEXT_STRING, X_TEXT_STRING),

Line 703: FND_API.G_MISS_CHAR, DESCRIPTION, X_DESCRIPTION),

699: update JTF_AMV_ITEMS_TL set
700: ITEM_NAME = decode( X_ITEM_NAME,
701: FND_API.G_MISS_CHAR, ITEM_NAME, X_ITEM_NAME),
702: DESCRIPTION = decode( X_DESCRIPTION,
703: FND_API.G_MISS_CHAR, DESCRIPTION, X_DESCRIPTION),
704: TEXT_STRING = decode (X_TEXT_STRING,
705: FND_API.G_MISS_CHAR, TEXT_STRING, X_TEXT_STRING),
706: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
707: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 705: FND_API.G_MISS_CHAR, TEXT_STRING, X_TEXT_STRING),

701: FND_API.G_MISS_CHAR, ITEM_NAME, X_ITEM_NAME),
702: DESCRIPTION = decode( X_DESCRIPTION,
703: FND_API.G_MISS_CHAR, DESCRIPTION, X_DESCRIPTION),
704: TEXT_STRING = decode (X_TEXT_STRING,
705: FND_API.G_MISS_CHAR, TEXT_STRING, X_TEXT_STRING),
706: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
707: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
708: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
709: SOURCE_LANG = userenv('LANG')