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_ORDERLINES_PVT dependencies on FND_API

Line 56: LINE_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

53:
54: TYPE mol_Rec_Type IS RECORD
55: (
56: LINE_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 58: CREATION_DATE DATE := FND_API.G_MISS_DATE,

54: TYPE mol_Rec_Type IS RECORD
55: (
56: LINE_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,

Line 59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

55: (
56: LINE_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CUSTOMER_PO VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

56: LINE_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CUSTOMER_PO VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,

Line 61: LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,

57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CUSTOMER_PO VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
65: TASK_ID NUMBER := FND_API.G_MISS_NUM,

Line 62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,

58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CUSTOMER_PO VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
65: TASK_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

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

59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CUSTOMER_PO VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
65: TASK_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
67: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 64: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,

60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CUSTOMER_PO VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
65: TASK_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
67: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 65: TASK_ID NUMBER := FND_API.G_MISS_NUM,

61: LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CUSTOMER_PO VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
65: TASK_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
67: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 66: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CUSTOMER_PO VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
65: TASK_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
67: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

63: CUSTOMER_PO VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
65: TASK_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
67: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

64: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
65: TASK_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
67: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 69: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

65: TASK_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
67: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 70: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

66: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
67: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 71: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 72: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 73: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 74: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 75: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 76: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 77: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 78: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 79: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 80: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 81: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

Line 82: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

78: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: );
85:
86: G_MISS_mol_REC mol_Rec_Type;

Line 83: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR

79: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: );
85:
86: G_MISS_mol_REC mol_Rec_Type;
87: TYPE mol_Tbl_Type IS TABLE OF mol_Rec_Type

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

96: -- Pre-Req :
97: -- Parameters:
98: -- IN
99: -- p_api_version_number IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103: -- P_mol_Rec IN mol_Rec_Type Required
104: --

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

97: -- Parameters:
98: -- IN
99: -- p_api_version_number IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103: -- P_mol_Rec IN mol_Rec_Type Required
104: --
105: -- OUT:

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

98: -- IN
99: -- p_api_version_number IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103: -- P_mol_Rec IN mol_Rec_Type Required
104: --
105: -- OUT:
106: -- x_return_status OUT NOCOPY VARCHAR2

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

113: -- End of Comments
114: --
115: PROCEDURE Create_orderlines(
116: P_Api_Version_Number IN NUMBER,
117: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: P_mol_Rec IN mol_Rec_Type := G_MISS_mol_REC,
121: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

114: --
115: PROCEDURE Create_orderlines(
116: P_Api_Version_Number IN NUMBER,
117: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: P_mol_Rec IN mol_Rec_Type := G_MISS_mol_REC,
121: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
122: X_LINE_ID OUT NOCOPY NUMBER,

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

115: PROCEDURE Create_orderlines(
116: P_Api_Version_Number IN NUMBER,
117: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: P_mol_Rec IN mol_Rec_Type := G_MISS_mol_REC,
121: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
122: X_LINE_ID OUT NOCOPY NUMBER,
123: X_Return_Status OUT NOCOPY VARCHAR2,

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

133: -- Pre-Req :
134: -- Parameters:
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
141: -- P_mol_Rec IN mol_Rec_Type Required

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

134: -- Parameters:
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
141: -- P_mol_Rec IN mol_Rec_Type Required
142: --

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

135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
141: -- P_mol_Rec IN mol_Rec_Type Required
142: --
143: -- OUT:

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

152: --
153: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
154: PROCEDURE Update_orderlines(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_Identity_Salesforce_Id IN NUMBER := NULL,
160: P_mol_Rec IN mol_Rec_Type,

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

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

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

154: PROCEDURE Update_orderlines(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_Identity_Salesforce_Id IN NUMBER := NULL,
160: P_mol_Rec IN mol_Rec_Type,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162: X_Msg_Count OUT NOCOPY NUMBER,

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

171: -- Pre-Req :
172: -- Parameters:
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
179: -- P_mol_Rec IN mol_Rec_Type Required

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

172: -- Parameters:
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
179: -- P_mol_Rec IN mol_Rec_Type Required
180: --

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

173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
179: -- P_mol_Rec IN mol_Rec_Type Required
180: --
181: -- OUT:

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

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

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

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

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

193: PROCEDURE Delete_orderlines(
194: P_Api_Version_Number IN NUMBER,
195: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
196: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: P_identity_salesforce_id IN NUMBER := NULL,
199: P_mol_Rec IN mol_Rec_Type,
200: X_Return_Status OUT NOCOPY VARCHAR2,
201: 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_LINE_ID (
217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218: P_Validation_mode IN VARCHAR2,
219: P_LINE_ID IN NUMBER,
220: P_HEADER_ID IN NUMBER, -- added for valiation of line_id 06-DEC-99, VL.
221: -- 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.

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

235: --
236: -- End of Comments
237:
238: PROCEDURE Validate_LAST_UPDATED_LOGIN (
239: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
240: P_Validation_mode IN VARCHAR2,
241: P_LAST_UPDATED_LOGIN IN NUMBER,
242: -- 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.
243: X_Return_Status OUT NOCOPY VARCHAR2,

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

256: --
257: -- End of Comments
258:
259: PROCEDURE Validate_HEADER_ID (
260: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
261: P_Validation_mode IN VARCHAR2,
262: P_HEADER_ID IN NUMBER,
263: -- 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.
264: X_Return_Status OUT NOCOPY VARCHAR2,

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

277: --
278: -- End of Comments
279:
280: PROCEDURE Validate_CUSTOMER_PO (
281: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
282: P_Validation_mode IN VARCHAR2,
283: P_CUSTOMER_PO IN VARCHAR2,
284: -- 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.
285: X_Return_Status OUT NOCOPY VARCHAR2,

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

298: --
299: -- End of Comments
300:
301: PROCEDURE Validate_INCIDENT_ID (
302: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
303: P_Validation_mode IN VARCHAR2,
304: P_INCIDENT_ID IN NUMBER,
305: -- 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.
306: X_Return_Status OUT NOCOPY VARCHAR2,

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

319: --
320: -- End of Comments
321:
322: PROCEDURE Validate_TASK_ID (
323: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
324: P_Validation_mode IN VARCHAR2,
325: P_TASK_ID IN NUMBER,
326: -- 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.
327: X_Return_Status OUT NOCOPY VARCHAR2,

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

340: --
341: -- End of Comments
342:
343: PROCEDURE Validate_TASK_ASSIGNMENT_ID (
344: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
345: P_Validation_mode IN VARCHAR2,
346: P_TASK_ASSIGNMENT_ID IN NUMBER,
347: -- 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.
348: X_Return_Status OUT NOCOPY VARCHAR2,

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

361: --
362: -- End of Comments
363:
364: PROCEDURE Validate_COMMENTS (
365: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
366: P_Validation_mode IN VARCHAR2,
367: P_COMMENTS IN VARCHAR2,
368: -- 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.
369: X_Return_Status OUT NOCOPY VARCHAR2,

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

382: -- 2. Developer can manually added inter-field level validation.
383: -- End of Comments
384:
385: PROCEDURE Validate_mol_rec(
386: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
387: P_Validation_mode IN VARCHAR2,
388: P_mol_Rec IN mol_Rec_Type,
389: X_Return_Status OUT NOCOPY VARCHAR2,
390: X_Msg_Count OUT NOCOPY NUMBER,

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

402: -- 2. We can also validate table instead of record. There will be an option for user to choose.
403: -- End of Comments
404:
405: PROCEDURE Validate_orderlines(
406: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
407: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
408: P_Validation_mode IN VARCHAR2,
409: P_mol_Rec IN mol_Rec_Type,
410: X_Return_Status OUT NOCOPY VARCHAR2,

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

403: -- End of Comments
404:
405: PROCEDURE Validate_orderlines(
406: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
407: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
408: P_Validation_mode IN VARCHAR2,
409: P_mol_Rec IN mol_Rec_Type,
410: X_Return_Status OUT NOCOPY VARCHAR2,
411: X_Msg_Count OUT NOCOPY NUMBER,