eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_TP_TEMPLATES_PVT dependencies on FND_API

Line 22: mTemplateID NUMBER:=FND_API.G_MISS_NUM,

18: -- mUniQuestionNoteFlag, mUniQuestionNoteType
19: -- End of Comments
20:
21: TYPE Template is RECORD (
22: mTemplateID NUMBER:=FND_API.G_MISS_NUM,
23: mTemplateName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
24: mStartDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
25: mEndDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
26: mDefaultFlag VARCHAR2(1):=FND_API.G_FALSE,

Line 23: mTemplateName VARCHAR2(1000):=FND_API.G_MISS_CHAR,

19: -- End of Comments
20:
21: TYPE Template is RECORD (
22: mTemplateID NUMBER:=FND_API.G_MISS_NUM,
23: mTemplateName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
24: mStartDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
25: mEndDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
26: mDefaultFlag VARCHAR2(1):=FND_API.G_FALSE,
27: mShortCode VARCHAR2(600):=FND_API.G_MISS_CHAR,

Line 24: mStartDate VARCHAR2(120):=FND_API.G_MISS_CHAR,

20:
21: TYPE Template is RECORD (
22: mTemplateID NUMBER:=FND_API.G_MISS_NUM,
23: mTemplateName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
24: mStartDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
25: mEndDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
26: mDefaultFlag VARCHAR2(1):=FND_API.G_FALSE,
27: mShortCode VARCHAR2(600):=FND_API.G_MISS_CHAR,
28: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR,

Line 25: mEndDate VARCHAR2(120):=FND_API.G_MISS_CHAR,

21: TYPE Template is RECORD (
22: mTemplateID NUMBER:=FND_API.G_MISS_NUM,
23: mTemplateName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
24: mStartDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
25: mEndDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
26: mDefaultFlag VARCHAR2(1):=FND_API.G_FALSE,
27: mShortCode VARCHAR2(600):=FND_API.G_MISS_CHAR,
28: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR,
29: mUniQuestionNoteFlag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 26: mDefaultFlag VARCHAR2(1):=FND_API.G_FALSE,

22: mTemplateID NUMBER:=FND_API.G_MISS_NUM,
23: mTemplateName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
24: mStartDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
25: mEndDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
26: mDefaultFlag VARCHAR2(1):=FND_API.G_FALSE,
27: mShortCode VARCHAR2(600):=FND_API.G_MISS_CHAR,
28: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR,
29: mUniQuestionNoteFlag VARCHAR2(1) := FND_API.G_MISS_CHAR,
30: mUniQuestionNoteType VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 27: mShortCode VARCHAR2(600):=FND_API.G_MISS_CHAR,

23: mTemplateName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
24: mStartDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
25: mEndDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
26: mDefaultFlag VARCHAR2(1):=FND_API.G_FALSE,
27: mShortCode VARCHAR2(600):=FND_API.G_MISS_CHAR,
28: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR,
29: mUniQuestionNoteFlag VARCHAR2(1) := FND_API.G_MISS_CHAR,
30: mUniQuestionNoteType VARCHAR2(30) := FND_API.G_MISS_CHAR
31: );

Line 28: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR,

24: mStartDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
25: mEndDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
26: mDefaultFlag VARCHAR2(1):=FND_API.G_FALSE,
27: mShortCode VARCHAR2(600):=FND_API.G_MISS_CHAR,
28: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR,
29: mUniQuestionNoteFlag VARCHAR2(1) := FND_API.G_MISS_CHAR,
30: mUniQuestionNoteType VARCHAR2(30) := FND_API.G_MISS_CHAR
31: );
32:

Line 29: mUniQuestionNoteFlag VARCHAR2(1) := FND_API.G_MISS_CHAR,

25: mEndDate VARCHAR2(120):=FND_API.G_MISS_CHAR,
26: mDefaultFlag VARCHAR2(1):=FND_API.G_FALSE,
27: mShortCode VARCHAR2(600):=FND_API.G_MISS_CHAR,
28: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR,
29: mUniQuestionNoteFlag VARCHAR2(1) := FND_API.G_MISS_CHAR,
30: mUniQuestionNoteType VARCHAR2(30) := FND_API.G_MISS_CHAR
31: );
32:
33: -- *****************************************************************************

Line 30: mUniQuestionNoteType VARCHAR2(30) := FND_API.G_MISS_CHAR

26: mDefaultFlag VARCHAR2(1):=FND_API.G_FALSE,
27: mShortCode VARCHAR2(600):=FND_API.G_MISS_CHAR,
28: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR,
29: mUniQuestionNoteFlag VARCHAR2(1) := FND_API.G_MISS_CHAR,
30: mUniQuestionNoteType VARCHAR2(30) := FND_API.G_MISS_CHAR
31: );
32:
33: -- *****************************************************************************
34: -- Start of Comments

Line 62: mAttributeID NUMBER :=FND_API.G_MISS_NUM,

58:
59: -- End of Comments
60:
61: TYPE Template_Attribute is RECORD (
62: mAttributeID NUMBER :=FND_API.G_MISS_NUM,
63: mAttributeName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
64: mStartThreshold NUMBER:=FND_API.G_MISS_NUM,
65: mEndThreshold NUMBER:=FND_API.G_MISS_NUM,
66: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,

Line 63: mAttributeName VARCHAR2(1000):=FND_API.G_MISS_CHAR,

59: -- End of Comments
60:
61: TYPE Template_Attribute is RECORD (
62: mAttributeID NUMBER :=FND_API.G_MISS_NUM,
63: mAttributeName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
64: mStartThreshold NUMBER:=FND_API.G_MISS_NUM,
65: mEndThreshold NUMBER:=FND_API.G_MISS_NUM,
66: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
67: mOther_ID NUMBER:=FND_API.G_MISS_NUM,

Line 64: mStartThreshold NUMBER:=FND_API.G_MISS_NUM,

60:
61: TYPE Template_Attribute is RECORD (
62: mAttributeID NUMBER :=FND_API.G_MISS_NUM,
63: mAttributeName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
64: mStartThreshold NUMBER:=FND_API.G_MISS_NUM,
65: mEndThreshold NUMBER:=FND_API.G_MISS_NUM,
66: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
67: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
68: mDefaultFlag VARCHAR2(200):=FND_API.G_FALSE,

Line 65: mEndThreshold NUMBER:=FND_API.G_MISS_NUM,

61: TYPE Template_Attribute is RECORD (
62: mAttributeID NUMBER :=FND_API.G_MISS_NUM,
63: mAttributeName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
64: mStartThreshold NUMBER:=FND_API.G_MISS_NUM,
65: mEndThreshold NUMBER:=FND_API.G_MISS_NUM,
66: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
67: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
68: mDefaultFlag VARCHAR2(200):=FND_API.G_FALSE,
69: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR

Line 66: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,

62: mAttributeID NUMBER :=FND_API.G_MISS_NUM,
63: mAttributeName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
64: mStartThreshold NUMBER:=FND_API.G_MISS_NUM,
65: mEndThreshold NUMBER:=FND_API.G_MISS_NUM,
66: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
67: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
68: mDefaultFlag VARCHAR2(200):=FND_API.G_FALSE,
69: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR
70: );

Line 67: mOther_ID NUMBER:=FND_API.G_MISS_NUM,

63: mAttributeName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
64: mStartThreshold NUMBER:=FND_API.G_MISS_NUM,
65: mEndThreshold NUMBER:=FND_API.G_MISS_NUM,
66: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
67: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
68: mDefaultFlag VARCHAR2(200):=FND_API.G_FALSE,
69: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR
70: );
71:

Line 68: mDefaultFlag VARCHAR2(200):=FND_API.G_FALSE,

64: mStartThreshold NUMBER:=FND_API.G_MISS_NUM,
65: mEndThreshold NUMBER:=FND_API.G_MISS_NUM,
66: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
67: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
68: mDefaultFlag VARCHAR2(200):=FND_API.G_FALSE,
69: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR
70: );
71:
72: -- *****************************************************************************

Line 69: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR

65: mEndThreshold NUMBER:=FND_API.G_MISS_NUM,
66: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
67: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
68: mDefaultFlag VARCHAR2(200):=FND_API.G_FALSE,
69: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR
70: );
71:
72: -- *****************************************************************************
73: -- Start of Comments

Line 99: mLinkID NUMBER :=FND_API.G_MISS_NUM,

95:
96: -- End of Comments
97:
98: TYPE Template_Link is RECORD (
99: mLinkID NUMBER :=FND_API.G_MISS_NUM,
100: mLinkName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
101: mLinkDesc VARCHAR2(1000):=FND_API.G_MISS_CHAR,
102: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
103: mOther_ID NUMBER:=FND_API.G_MISS_NUM,

Line 100: mLinkName VARCHAR2(1000):=FND_API.G_MISS_CHAR,

96: -- End of Comments
97:
98: TYPE Template_Link is RECORD (
99: mLinkID NUMBER :=FND_API.G_MISS_NUM,
100: mLinkName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
101: mLinkDesc VARCHAR2(1000):=FND_API.G_MISS_CHAR,
102: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
103: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
104: lookup_Code VARCHAR2(30):= FND_API.G_MISS_CHAR,

Line 101: mLinkDesc VARCHAR2(1000):=FND_API.G_MISS_CHAR,

97:
98: TYPE Template_Link is RECORD (
99: mLinkID NUMBER :=FND_API.G_MISS_NUM,
100: mLinkName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
101: mLinkDesc VARCHAR2(1000):=FND_API.G_MISS_CHAR,
102: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
103: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
104: lookup_Code VARCHAR2(30):= FND_API.G_MISS_CHAR,
105: lookup_Type VARCHAR2(30):=FND_API.G_MISS_CHAR,

Line 102: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,

98: TYPE Template_Link is RECORD (
99: mLinkID NUMBER :=FND_API.G_MISS_NUM,
100: mLinkName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
101: mLinkDesc VARCHAR2(1000):=FND_API.G_MISS_CHAR,
102: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
103: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
104: lookup_Code VARCHAR2(30):= FND_API.G_MISS_CHAR,
105: lookup_Type VARCHAR2(30):=FND_API.G_MISS_CHAR,
106: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR

Line 103: mOther_ID NUMBER:=FND_API.G_MISS_NUM,

99: mLinkID NUMBER :=FND_API.G_MISS_NUM,
100: mLinkName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
101: mLinkDesc VARCHAR2(1000):=FND_API.G_MISS_CHAR,
102: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
103: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
104: lookup_Code VARCHAR2(30):= FND_API.G_MISS_CHAR,
105: lookup_Type VARCHAR2(30):=FND_API.G_MISS_CHAR,
106: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR
107: );

Line 104: lookup_Code VARCHAR2(30):= FND_API.G_MISS_CHAR,

100: mLinkName VARCHAR2(1000):=FND_API.G_MISS_CHAR,
101: mLinkDesc VARCHAR2(1000):=FND_API.G_MISS_CHAR,
102: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
103: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
104: lookup_Code VARCHAR2(30):= FND_API.G_MISS_CHAR,
105: lookup_Type VARCHAR2(30):=FND_API.G_MISS_CHAR,
106: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR
107: );
108:

Line 105: lookup_Type VARCHAR2(30):=FND_API.G_MISS_CHAR,

101: mLinkDesc VARCHAR2(1000):=FND_API.G_MISS_CHAR,
102: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
103: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
104: lookup_Code VARCHAR2(30):= FND_API.G_MISS_CHAR,
105: lookup_Type VARCHAR2(30):=FND_API.G_MISS_CHAR,
106: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR
107: );
108:
109: -- *****************************************************************************

Line 106: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR

102: mJTF_OBJECT_CODE VARCHAR2(200):=FND_API.G_MISS_CHAR,
103: mOther_ID NUMBER:=FND_API.G_MISS_NUM,
104: lookup_Code VARCHAR2(30):= FND_API.G_MISS_CHAR,
105: lookup_Type VARCHAR2(30):=FND_API.G_MISS_CHAR,
106: mLast_Updated_Date VARCHAR2(120):=FND_API.G_MISS_CHAR
107: );
108:
109: -- *****************************************************************************
110: -- Start of Comments

Line 128: mOBJECT_CODE VARCHAR2(1000):=FND_API.G_MISS_CHAR,

124: -- mName VARCHAR2(1000)
125: -- End of Comments
126: -- *****************************************************************************
127: TYPE ID_NAME_PAIR is RECORD (
128: mOBJECT_CODE VARCHAR2(1000):=FND_API.G_MISS_CHAR,
129: mName VARCHAR2(1000):=FND_API.G_MISS_CHAR);
130:
131:
132: -- *****************************************************************************

Line 129: mName VARCHAR2(1000):=FND_API.G_MISS_CHAR);

125: -- End of Comments
126: -- *****************************************************************************
127: TYPE ID_NAME_PAIR is RECORD (
128: mOBJECT_CODE VARCHAR2(1000):=FND_API.G_MISS_CHAR,
129: mName VARCHAR2(1000):=FND_API.G_MISS_CHAR);
130:
131:
132: -- *****************************************************************************
133: -- Start of Comments

Line 195: DEBUG CONSTANT VARCHAR2(100):=FND_API.G_TRUE;

191: -- These two constants define JTF_OBJECTS_TL, _B object function for the link and attribute
192: G_JTF_LINK CONSTANT VARCHAR2(200) :='IBU_LINK';
193: G_JTF_ATTRIBUTE CONSTANT VARCHAR2(200) :='IBU_ATTRIBUTE';
194:
195: DEBUG CONSTANT VARCHAR2(100):=FND_API.G_TRUE;
196: -- *****************************************************************************
197: -- Start of Comments
198: -- This procedure Add_Template Add an additional template to the CS_TP_Templates_B Table
199: -- The user needs to pass in a template record which holds the template attribu

Line 218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

214: -- End of Comments
215:
216: procedure Add_Template (
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR := FND_API.G_FALSE,
220: P_One_Template IN Template,
221: X_Msg_Count OUT NOCOPY NUMBER,
222: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 219: p_commit IN VARCHAR := FND_API.G_FALSE,

215:
216: procedure Add_Template (
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR := FND_API.G_FALSE,
220: P_One_Template IN Template,
221: X_Msg_Count OUT NOCOPY NUMBER,
222: X_Msg_Data OUT NOCOPY VARCHAR2,
223: X_Return_Status OUT NOCOPY VARCHAR2,

Line 243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

239: --
240: -- End of Comments
241: procedure Delete_Template (
242: p_api_version_number IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR := FND_API.G_FALSE,
245: P_Template_ID IN NUMBER,
246: X_Msg_Count OUT NOCOPY NUMBER,
247: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 244: p_commit IN VARCHAR := FND_API.G_FALSE,

240: -- End of Comments
241: procedure Delete_Template (
242: p_api_version_number IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR := FND_API.G_FALSE,
245: P_Template_ID IN NUMBER,
246: X_Msg_Count OUT NOCOPY NUMBER,
247: X_Msg_Data OUT NOCOPY VARCHAR2,
248: X_Return_Status OUT NOCOPY VARCHAR2

Line 270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

266: -- End of Comments
267:
268: procedure Update_Template (
269: p_api_version_number IN NUMBER,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_commit IN VARCHAR := FND_API.G_FALSE,
272: P_One_Template IN Template,
273: X_Msg_Count OUT NOCOPY NUMBER,
274: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 271: p_commit IN VARCHAR := FND_API.G_FALSE,

267:
268: procedure Update_Template (
269: p_api_version_number IN NUMBER,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_commit IN VARCHAR := FND_API.G_FALSE,
272: P_One_Template IN Template,
273: X_Msg_Count OUT NOCOPY NUMBER,
274: X_Msg_Data OUT NOCOPY VARCHAR2,
275: X_Return_Status OUT NOCOPY VARCHAR2);

Line 302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

298: -- End of Comments
299:
300: procedure Update_Template_Attributes (
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR := FND_API.G_FALSE,
304: P_Template_ID IN NUMBER,
305: P_Template_Attributes IN Template_Attribute_List,
306: X_Msg_Count OUT NOCOPY NUMBER,

Line 303: p_commit IN VARCHAR := FND_API.G_FALSE,

299:
300: procedure Update_Template_Attributes (
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR := FND_API.G_FALSE,
304: P_Template_ID IN NUMBER,
305: P_Template_Attributes IN Template_Attribute_List,
306: X_Msg_Count OUT NOCOPY NUMBER,
307: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

327:
328: -- End of Comments
329: procedure Update_Template_Links (
330: p_api_version_number IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332: p_commit IN VARCHAR := FND_API.G_FALSE,
333: P_Template_ID IN NUMBER,
334: P_JTF_OBJECT_CODE IN VARCHAR2,
335: P_Template_Links IN Template_Link_List,

Line 332: p_commit IN VARCHAR := FND_API.G_FALSE,

328: -- End of Comments
329: procedure Update_Template_Links (
330: p_api_version_number IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332: p_commit IN VARCHAR := FND_API.G_FALSE,
333: P_Template_ID IN NUMBER,
334: P_JTF_OBJECT_CODE IN VARCHAR2,
335: P_Template_Links IN Template_Link_List,
336: X_Msg_Count OUT NOCOPY NUMBER,

Line 363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

359: -- End of Comments
360:
361: procedure Show_Templates (
362: p_api_version_number IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
365: P_Template_Name IN VARCHAR2,
366: P_Start_Template IN NUMBER,
367: P_End_Template IN NUMBER,

Line 364: p_commit IN VARCHAR2 := FND_API.G_FALSE,

360:
361: procedure Show_Templates (
362: p_api_version_number IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
365: P_Template_Name IN VARCHAR2,
366: P_Start_Template IN NUMBER,
367: P_End_Template IN NUMBER,
368: P_Display_Order IN VARCHAR2,

Line 393: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

389: -- End of Comments
390:
391: procedure Show_Template (
392: p_api_version_number IN NUMBER,
393: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
394: p_commit IN VARCHAR := FND_API.G_FALSE,
395: P_Template_ID IN NUMBER,
396: X_Msg_Count OUT NOCOPY NUMBER,
397: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 394: p_commit IN VARCHAR := FND_API.G_FALSE,

390:
391: procedure Show_Template (
392: p_api_version_number IN NUMBER,
393: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
394: p_commit IN VARCHAR := FND_API.G_FALSE,
395: P_Template_ID IN NUMBER,
396: X_Msg_Count OUT NOCOPY NUMBER,
397: X_Msg_Data OUT NOCOPY VARCHAR2,
398: X_Return_Status OUT NOCOPY VARCHAR2,

Line 420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

416: -- End of Comments
417:
418: procedure Show_Templates_With_Link (
419: p_api_version_number IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR := FND_API.G_FALSE,
422: p_Object_Other_list IN OBJECT_OTHER_ID_PAIRS,
423: X_Msg_Count OUT NOCOPY NUMBER,
424: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 421: p_commit IN VARCHAR := FND_API.G_FALSE,

417:
418: procedure Show_Templates_With_Link (
419: p_api_version_number IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR := FND_API.G_FALSE,
422: p_Object_Other_list IN OBJECT_OTHER_ID_PAIRS,
423: X_Msg_Count OUT NOCOPY NUMBER,
424: X_Msg_Data OUT NOCOPY VARCHAR2,
425: X_Return_Status OUT NOCOPY VARCHAR2,

Line 449: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

445:
446: procedure Show_Template_Attributes
447: (
448: p_api_version_number IN NUMBER,
449: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
450: p_commit IN VARCHAR := FND_API.G_FALSE,
451: P_Template_ID IN NUMBER,
452: P_JTF_OBJECT_CODE IN VARCHAR2,
453: X_Msg_Count OUT NOCOPY NUMBER,

Line 450: p_commit IN VARCHAR := FND_API.G_FALSE,

446: procedure Show_Template_Attributes
447: (
448: p_api_version_number IN NUMBER,
449: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
450: p_commit IN VARCHAR := FND_API.G_FALSE,
451: P_Template_ID IN NUMBER,
452: P_JTF_OBJECT_CODE IN VARCHAR2,
453: X_Msg_Count OUT NOCOPY NUMBER,
454: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

473: -- End of Comments
474: procedure Show_Template_Links
475: (
476: p_api_version_number IN NUMBER,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR := FND_API.G_FALSE,
479: P_Template_ID IN NUMBER,
480: P_JTF_OBJECT_CODE IN VARCHAR2,
481: X_Msg_Count OUT NOCOPY NUMBER,

Line 478: p_commit IN VARCHAR := FND_API.G_FALSE,

474: procedure Show_Template_Links
475: (
476: p_api_version_number IN NUMBER,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR := FND_API.G_FALSE,
479: P_Template_ID IN NUMBER,
480: P_JTF_OBJECT_CODE IN VARCHAR2,
481: X_Msg_Count OUT NOCOPY NUMBER,
482: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 505: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

501:
502: procedure Show_Non_Asso_Links
503: (
504: p_api_version_number IN NUMBER,
505: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
506: p_commit IN VARCHAR := FND_API.G_FALSE,
507: P_Template_ID IN NUMBER,
508: P_JTF_OBJECT_CODE IN VARCHAR2,
509: X_Msg_Count OUT NOCOPY NUMBER,

Line 506: p_commit IN VARCHAR := FND_API.G_FALSE,

502: procedure Show_Non_Asso_Links
503: (
504: p_api_version_number IN NUMBER,
505: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
506: p_commit IN VARCHAR := FND_API.G_FALSE,
507: P_Template_ID IN NUMBER,
508: P_JTF_OBJECT_CODE IN VARCHAR2,
509: X_Msg_Count OUT NOCOPY NUMBER,
510: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 517: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

513:
514:
515: procedure Show_Link_Attribute_List (
516: p_api_version_number IN NUMBER,
517: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
518: p_commit IN VARCHAR2 := FND_API.G_FALSE,
519: P_Identify IN VARCHAR2,
520: X_Msg_Count OUT NOCOPY NUMBER,
521: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 518: p_commit IN VARCHAR2 := FND_API.G_FALSE,

514:
515: procedure Show_Link_Attribute_List (
516: p_api_version_number IN NUMBER,
517: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
518: p_commit IN VARCHAR2 := FND_API.G_FALSE,
519: P_Identify IN VARCHAR2,
520: X_Msg_Count OUT NOCOPY NUMBER,
521: X_Msg_Data OUT NOCOPY VARCHAR2,
522: X_Return_Status OUT NOCOPY VARCHAR2,

Line 528: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

524: );
525:
526: procedure Retrieve_Constants (
527: p_api_version_number IN NUMBER,
528: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
529: p_commit IN VARCHAR2 := FND_API.G_FALSE,
530: X_Msg_Count OUT NOCOPY NUMBER,
531: X_Msg_Data OUT NOCOPY VARCHAR2,
532: X_Return_Status OUT NOCOPY VARCHAR2,

Line 529: p_commit IN VARCHAR2 := FND_API.G_FALSE,

525:
526: procedure Retrieve_Constants (
527: p_api_version_number IN NUMBER,
528: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
529: p_commit IN VARCHAR2 := FND_API.G_FALSE,
530: X_Msg_Count OUT NOCOPY NUMBER,
531: X_Msg_Data OUT NOCOPY VARCHAR2,
532: X_Return_Status OUT NOCOPY VARCHAR2,
533: X_IDName_Pairs OUT NOCOPY ID_NAME_PAIRS

Line 538: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

534: );
535:
536: procedure Show_Default_Template (
537: p_api_version_number IN NUMBER,
538: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
539: p_commit IN VARCHAR2 := FND_API.G_FALSE,
540: X_Msg_Count OUT NOCOPY NUMBER,
541: X_Msg_Data OUT NOCOPY VARCHAR2,
542: X_Return_Status OUT NOCOPY VARCHAR2,

Line 539: p_commit IN VARCHAR2 := FND_API.G_FALSE,

535:
536: procedure Show_Default_Template (
537: p_api_version_number IN NUMBER,
538: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
539: p_commit IN VARCHAR2 := FND_API.G_FALSE,
540: X_Msg_Count OUT NOCOPY NUMBER,
541: X_Msg_Data OUT NOCOPY VARCHAR2,
542: X_Return_Status OUT NOCOPY VARCHAR2,
543: X_Default_Template OUT NOCOPY Template

Line 563: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

559: procedure Copy_Template(
560: p_api_version_number IN NUMBER,
561: B_Template_ID IN NUMBER,
562: X_Template_Name IN VARCHAR2,
563: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
564: p_commit IN VARCHAR := FND_API.G_FALSE,
565: X_Msg_Count OUT NOCOPY NUMBER,
566: X_Msg_Data OUT NOCOPY VARCHAR2,
567: X_Return_Status OUT NOCOPY VARCHAR2,

Line 564: p_commit IN VARCHAR := FND_API.G_FALSE,

560: p_api_version_number IN NUMBER,
561: B_Template_ID IN NUMBER,
562: X_Template_Name IN VARCHAR2,
563: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
564: p_commit IN VARCHAR := FND_API.G_FALSE,
565: X_Msg_Count OUT NOCOPY NUMBER,
566: X_Msg_Data OUT NOCOPY VARCHAR2,
567: X_Return_Status OUT NOCOPY VARCHAR2,
568: X_Template_ID OUT NOCOPY NUMBER);

Line 577: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

573:
574: procedure Test_Template_Obsolete(
575: p_api_version_number IN NUMBER,
576: B_Template_ID IN NUMBER,
577: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
578: p_commit IN VARCHAR := FND_API.G_FALSE,
579: X_Msg_Count OUT NOCOPY NUMBER,
580: X_Msg_Data OUT NOCOPY VARCHAR2,
581: X_Return_Status OUT NOCOPY VARCHAR2,

Line 578: p_commit IN VARCHAR := FND_API.G_FALSE,

574: procedure Test_Template_Obsolete(
575: p_api_version_number IN NUMBER,
576: B_Template_ID IN NUMBER,
577: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
578: p_commit IN VARCHAR := FND_API.G_FALSE,
579: X_Msg_Count OUT NOCOPY NUMBER,
580: X_Msg_Data OUT NOCOPY VARCHAR2,
581: X_Return_Status OUT NOCOPY VARCHAR2,
582: B_Obsolete OUT NOCOPY VARCHAR2);

Line 608: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

604: -- End of Comments
605: procedure Show_Template_Links_Two
606: (
607: p_api_version_number IN NUMBER,
608: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
609: p_commit IN VARCHAR := FND_API.G_FALSE,
610: P_Template_ID IN NUMBER,
611: P_JTF_OBJECT_CODE IN VARCHAR2,
612: p_start_link IN NUMBER,

Line 609: p_commit IN VARCHAR := FND_API.G_FALSE,

605: procedure Show_Template_Links_Two
606: (
607: p_api_version_number IN NUMBER,
608: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
609: p_commit IN VARCHAR := FND_API.G_FALSE,
610: P_Template_ID IN NUMBER,
611: P_JTF_OBJECT_CODE IN VARCHAR2,
612: p_start_link IN NUMBER,
613: p_end_link IN NUMBER,

Line 629: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

625:
626: procedure Show_Non_Asso_Links_Two
627: (
628: p_api_version_number IN NUMBER,
629: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
630: p_commit IN VARCHAR := FND_API.G_FALSE,
631: P_Template_ID IN NUMBER,
632: P_JTF_OBJECT_CODE IN VARCHAR2,
633: p_start_link IN NUMBER,

Line 630: p_commit IN VARCHAR := FND_API.G_FALSE,

626: procedure Show_Non_Asso_Links_Two
627: (
628: p_api_version_number IN NUMBER,
629: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
630: p_commit IN VARCHAR := FND_API.G_FALSE,
631: P_Template_ID IN NUMBER,
632: P_JTF_OBJECT_CODE IN VARCHAR2,
633: p_start_link IN NUMBER,
634: p_end_link IN NUMBER,

Line 649: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

645: -- Delete the template links
646:
647: PROCEDURE Delete_Template_Links (
648: p_api_version_number IN NUMBER,
649: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
650: p_commit IN VARCHAR := FND_API.G_FALSE,
651: p_template_id IN NUMBER,
652: p_jtf_object_code IN VARCHAR2,
653: p_template_links IN Template_Link_List,

Line 650: p_commit IN VARCHAR := FND_API.G_FALSE,

646:
647: PROCEDURE Delete_Template_Links (
648: p_api_version_number IN NUMBER,
649: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
650: p_commit IN VARCHAR := FND_API.G_FALSE,
651: p_template_id IN NUMBER,
652: p_jtf_object_code IN VARCHAR2,
653: p_template_links IN Template_Link_List,
654: x_msg_count OUT NOCOPY NUMBER,

Line 664: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

660: -- Add the template links
661:
662: PROCEDURE Add_Template_Links (
663: p_api_version_number IN NUMBER,
664: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
665: p_commit IN VARCHAR := FND_API.G_FALSE,
666: p_template_id IN NUMBER,
667: p_jtf_object_code IN VARCHAR2,
668: p_template_links IN Template_Link_List,

Line 665: p_commit IN VARCHAR := FND_API.G_FALSE,

661:
662: PROCEDURE Add_Template_Links (
663: p_api_version_number IN NUMBER,
664: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
665: p_commit IN VARCHAR := FND_API.G_FALSE,
666: p_template_id IN NUMBER,
667: p_jtf_object_code IN VARCHAR2,
668: p_template_links IN Template_Link_List,
669: x_msg_count OUT NOCOPY NUMBER,