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.CSP_PICKLIST_HEADER_PVT dependencies on FND_API

Line 55: picklist_header_id NUMBER := FND_API.G_MISS_NUM,

51: -- End of Comments
52:
53: TYPE PICK_HEADER_Rec_Type IS RECORD
54: (
55: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
56: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE := FND_API.G_MISS_DATE,
58: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
59: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 56: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

52:
53: TYPE PICK_HEADER_Rec_Type IS RECORD
54: (
55: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
56: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE := FND_API.G_MISS_DATE,
58: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
59: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
60: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 57: CREATION_DATE DATE := FND_API.G_MISS_DATE,

53: TYPE PICK_HEADER_Rec_Type IS RECORD
54: (
55: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
56: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE := FND_API.G_MISS_DATE,
58: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
59: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
60: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
61: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 58: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

54: (
55: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
56: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE := FND_API.G_MISS_DATE,
58: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
59: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
60: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
61: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
62: PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 59: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

55: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
56: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE := FND_API.G_MISS_DATE,
58: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
59: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
60: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
61: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
62: PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 60: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

56: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE := FND_API.G_MISS_DATE,
58: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
59: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
60: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
61: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
62: PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: DATE_CREATED DATE := FND_API.G_MISS_DATE,

Line 61: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

57: CREATION_DATE DATE := FND_API.G_MISS_DATE,
58: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
59: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
60: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
61: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
62: PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: DATE_CREATED DATE := FND_API.G_MISS_DATE,
65: DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,

Line 62: PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

58: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
59: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
60: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
61: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
62: PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: DATE_CREATED DATE := FND_API.G_MISS_DATE,
65: DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,
66: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 63: PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

59: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
60: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
61: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
62: PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: DATE_CREATED DATE := FND_API.G_MISS_DATE,
65: DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,
66: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 64: DATE_CREATED DATE := FND_API.G_MISS_DATE,

60: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
61: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
62: PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: DATE_CREATED DATE := FND_API.G_MISS_DATE,
65: DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,
66: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 65: DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,

61: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
62: PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: DATE_CREATED DATE := FND_API.G_MISS_DATE,
65: DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,
66: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 66: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

62: PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: DATE_CREATED DATE := FND_API.G_MISS_DATE,
65: DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,
66: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 67: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

63: PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: DATE_CREATED DATE := FND_API.G_MISS_DATE,
65: DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,
66: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 68: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

64: DATE_CREATED DATE := FND_API.G_MISS_DATE,
65: DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,
66: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 69: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

65: DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,
66: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 70: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

66: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 71: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

67: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 72: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

68: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 73: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

69: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 74: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

70: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 75: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

71: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 76: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

72: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 77: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

73: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 78: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

74: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: );

Line 79: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

75: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: );
83:

Line 80: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

76: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: );
83:
84: G_MISS_PICK_HEADER_REC PICK_HEADER_Rec_Type;

Line 81: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR

77: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: );
83:
84: G_MISS_PICK_HEADER_REC PICK_HEADER_Rec_Type;
85: TYPE PICK_HEADER_Tbl_Type IS TABLE OF PICK_HEADER_Rec_Type

Line 98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

94: -- Pre-Req :
95: -- Parameters:
96: -- IN
97: -- p_api_version_number IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101: -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required
102: --

Line 99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

95: -- Parameters:
96: -- IN
97: -- p_api_version_number IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101: -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required
102: --
103: -- OUT:

Line 100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

96: -- IN
97: -- p_api_version_number IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101: -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required
102: --
103: -- OUT:
104: -- x_return_status OUT NOCOPY VARCHAR2

Line 115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

111: -- End of Comments
112: --
113: PROCEDURE Create_picklist_header(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type := G_MISS_PICK_HEADER_REC,
119: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

112: --
113: PROCEDURE Create_picklist_header(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type := G_MISS_PICK_HEADER_REC,
119: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
120: X_picklist_header_id OUT NOCOPY NUMBER,

Line 117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

113: PROCEDURE Create_picklist_header(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type := G_MISS_PICK_HEADER_REC,
119: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
120: X_picklist_header_id OUT NOCOPY NUMBER,
121: X_Return_Status OUT NOCOPY VARCHAR2,

Line 135: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

131: -- Pre-Req :
132: -- Parameters:
133: -- IN
134: -- p_api_version_number IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
139: -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required

Line 136: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

132: -- Parameters:
133: -- IN
134: -- p_api_version_number IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
139: -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required
140: --

Line 137: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

133: -- IN
134: -- p_api_version_number IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
139: -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required
140: --
141: -- OUT:

Line 154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

150: --
151: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
152: PROCEDURE Update_picklist_header(
153: P_Api_Version_Number IN NUMBER,
154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
155: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: --P_Identity_Salesforce_Id IN NUMBER := NULL,
158: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,

Line 155: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

151: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
152: PROCEDURE Update_picklist_header(
153: P_Api_Version_Number IN NUMBER,
154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
155: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: --P_Identity_Salesforce_Id IN NUMBER := NULL,
158: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
159: X_Return_Status OUT NOCOPY VARCHAR2,

Line 156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

152: PROCEDURE Update_picklist_header(
153: P_Api_Version_Number IN NUMBER,
154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
155: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: --P_Identity_Salesforce_Id IN NUMBER := NULL,
158: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
159: X_Return_Status OUT NOCOPY VARCHAR2,
160: X_Msg_Count OUT NOCOPY NUMBER,

Line 173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

169: -- Pre-Req :
170: -- Parameters:
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
177: -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required

Line 174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

170: -- Parameters:
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
177: -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required
178: --

Line 175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
177: -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required
178: --
179: -- OUT:

Line 193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

189: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
190: -- The Master delete procedure may not be needed depends on different business requirements.
191: PROCEDURE Delete_picklist_header(
192: P_Api_Version_Number IN NUMBER,
193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196: --P_identity_salesforce_id IN NUMBER := NULL,
197: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,

Line 194: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

190: -- The Master delete procedure may not be needed depends on different business requirements.
191: PROCEDURE Delete_picklist_header(
192: P_Api_Version_Number IN NUMBER,
193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196: --P_identity_salesforce_id IN NUMBER := NULL,
197: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
198: X_Return_Status OUT NOCOPY VARCHAR2,

Line 195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

191: PROCEDURE Delete_picklist_header(
192: P_Api_Version_Number IN NUMBER,
193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196: --P_identity_salesforce_id IN NUMBER := NULL,
197: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
198: X_Return_Status OUT NOCOPY VARCHAR2,
199: X_Msg_Count OUT NOCOPY NUMBER,

Line 217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

213: --
214: -- End of Comments
215:
216: PROCEDURE Validate_picklist_header_id (
217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218: P_Validation_mode IN VARCHAR2,
219: P_picklist_header_id IN NUMBER,
220: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
221: X_Return_Status OUT NOCOPY VARCHAR2,

Line 238: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

234: --
235: -- End of Comments
236:
237: PROCEDURE Validate_ORGANIZATION_ID (
238: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
239: P_Validation_mode IN VARCHAR2,
240: P_ORGANIZATION_ID IN NUMBER,
241: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
242: X_Return_Status OUT NOCOPY VARCHAR2,

Line 259: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

255: --
256: -- End of Comments
257:
258: PROCEDURE Validate_PICKLIST_NUMBER (
259: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
260: P_Validation_mode IN VARCHAR2,
261: P_PICKLIST_NUMBER IN VARCHAR2,
262: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
263: X_Return_Status OUT NOCOPY VARCHAR2,

Line 280: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

276: --
277: -- End of Comments
278:
279: PROCEDURE Validate_PICKLIST_STATUS (
280: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
281: P_Validation_mode IN VARCHAR2,
282: P_PICKLIST_STATUS IN VARCHAR2,
283: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
284: X_Return_Status OUT NOCOPY VARCHAR2,

Line 301: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

297: --
298: -- End of Comments
299:
300: PROCEDURE Validate_DATE_CREATED (
301: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
302: P_Validation_mode IN VARCHAR2,
303: P_DATE_CREATED IN DATE,
304: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
305: X_Return_Status OUT NOCOPY VARCHAR2,

Line 322: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

318: --
319: -- End of Comments
320:
321: PROCEDURE Validate_DATE_CONFIRMED (
322: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
323: P_Validation_mode IN VARCHAR2,
324: P_DATE_CONFIRMED IN DATE,
325: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
326: X_Return_Status OUT NOCOPY VARCHAR2,

Line 343: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

339: -- 2. Developer can manually added inter-field level validation.
340: -- End of Comments
341:
342: PROCEDURE Validate_PICK_HEADER_rec(
343: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
344: P_Validation_mode IN VARCHAR2,
345: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
346: X_Return_Status OUT NOCOPY VARCHAR2,
347: X_Msg_Count OUT NOCOPY NUMBER,

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

359: -- 2. We can also validate table instead of record. There will be an option for user to choose.
360: -- End of Comments
361:
362: PROCEDURE Validate_picklist_header(
363: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
364: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
365: P_Validation_mode IN VARCHAR2,
366: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
367: X_Return_Status OUT NOCOPY VARCHAR2,

Line 364: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

360: -- End of Comments
361:
362: PROCEDURE Validate_picklist_header(
363: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
364: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
365: P_Validation_mode IN VARCHAR2,
366: P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
367: X_Return_Status OUT NOCOPY VARCHAR2,
368: X_Msg_Count OUT NOCOPY NUMBER,