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_PUB 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 106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

102: -- Pre-Req :
103: -- Parameters:
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- P_mol_Rec IN mol_Rec_Type Required
109: --
110: -- OUT:

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

103: -- Parameters:
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- P_mol_Rec IN mol_Rec_Type Required
109: --
110: -- OUT:
111: -- x_return_status OUT NOCOPY VARCHAR2

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

118: -- End of Comments
119: --
120: PROCEDURE Create_orderlines(
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: P_mol_Rec IN mol_Rec_Type := G_MISS_mol_REC,
125: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
126: X_LINE_ID OUT NOCOPY NUMBER,

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

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

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

137: -- Pre-Req :
138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
144: -- P_mol_Rec IN mol_Rec_Type Required
145: --

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

138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
144: -- P_mol_Rec IN mol_Rec_Type Required
145: --
146: -- OUT:

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

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

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

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

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

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

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

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

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

192: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
193: -- The Master delete procedure may not be needed depends on different business requirements.
194: PROCEDURE Delete_orderlines(
195: P_Api_Version_Number IN NUMBER,
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
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_Commit IN VARCHAR2 := FND_API.G_FALSE,

193: -- The Master delete procedure may not be needed depends on different business requirements.
194: PROCEDURE Delete_orderlines(
195: P_Api_Version_Number IN NUMBER,
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
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 214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

210: -- Pre-Req :
211: -- Parameters:
212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
216: -- P_mol_Rec IN mol_Rec_Type Required
217: -- Hint: Add List of bind variables here
218: -- p_rec_requested IN NUMBER Optional Default = 30

Line 224: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE

220: --
221: -- Return Total Records Count Flag. This flag controls whether the total record count
222: -- and total record amount is returned.
223: --
224: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- Hint: User defined record type
226: -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
227: --
228: -- OUT:

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

242: -- End of Comments
243: --
244: PROCEDURE Get_orderlines(
245: P_Api_Version_Number IN NUMBER,
246: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
247: P_identity_salesforce_id IN NUMBER := NULL,
248: P_mol_Rec IN CSP_orderlines_PUB.mol_Rec_Type,
249: -- Hint: Add list of bind variables here
250: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

Line 252: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

248: P_mol_Rec IN CSP_orderlines_PUB.mol_Rec_Type,
249: -- Hint: Add list of bind variables here
250: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
251: p_start_rec_prt IN NUMBER := 1,
252: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
253: -- Hint: user defined record type
254: p_order_by_rec IN CSP_orderlines_PUB.mol_sort_rec_type,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,