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

Line 48: HEADER_ID NUMBER := FND_API.G_MISS_NUM,

44: -- End of Comments
45:
46: TYPE MOH_Rec_Type IS RECORD
47: (
48: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
49: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
50: CREATION_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 49: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

45:
46: TYPE MOH_Rec_Type IS RECORD
47: (
48: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
49: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
50: CREATION_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 50: CREATION_DATE DATE := FND_API.G_MISS_DATE,

46: TYPE MOH_Rec_Type IS RECORD
47: (
48: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
49: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
50: CREATION_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
54: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 51: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

47: (
48: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
49: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
50: CREATION_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
54: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
55: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 52: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

48: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
49: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
50: CREATION_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
54: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
55: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 53: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

49: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
50: CREATION_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
54: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
55: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 54: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

50: CREATION_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
54: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
55: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 55: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,

51: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
54: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
55: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
59: /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 56: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,

52: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
54: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
55: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
59: /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 57: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,

53: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
54: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
55: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
59: /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR

54: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
55: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
59: /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 59: /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

55: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
59: /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 60: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

56: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
59: /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 61: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

57: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
59: /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
65: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 62: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
59: /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
65: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
66: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 63: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,

59: /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
65: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
66: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR */

Line 64: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,

60: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
65: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
66: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR */
68: );

Line 65: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,

61: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
65: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
66: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR */
68: );
69:

Line 66: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,

62: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
65: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
66: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR */
68: );
69:
70: G_MISS_MOH_REC MOH_Rec_Type;

Line 67: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR */

63: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
65: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
66: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR */
68: );
69:
70: G_MISS_MOH_REC MOH_Rec_Type;
71: TYPE MOH_Tbl_Type IS TABLE OF MOH_Rec_Type

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

86: -- Pre-Req :
87: -- Parameters:
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- P_MOH_Rec IN MOH_Rec_Type Required
93: --
94: -- OUT:

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

87: -- Parameters:
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- P_MOH_Rec IN MOH_Rec_Type Required
93: --
94: -- OUT:
95: -- x_return_status OUT NOCOPY VARCHAR2

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

102: -- End of Comments
103: --
104: PROCEDURE Create_orderheaders(
105: P_Api_Version_Number IN NUMBER,
106: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
107: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
108: P_MOH_Rec IN MOH_Rec_Type := G_MISS_MOH_REC,
109: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
110: X_HEADER_ID OUT NOCOPY NUMBER,

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

103: --
104: PROCEDURE Create_orderheaders(
105: P_Api_Version_Number IN NUMBER,
106: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
107: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
108: P_MOH_Rec IN MOH_Rec_Type := G_MISS_MOH_REC,
109: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
110: X_HEADER_ID OUT NOCOPY NUMBER,
111: X_Return_Status OUT NOCOPY VARCHAR2,

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

121: -- Pre-Req :
122: -- Parameters:
123: -- IN
124: -- p_api_version_number IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
128: -- P_MOH_Rec IN MOH_Rec_Type Required
129: --

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

122: -- Parameters:
123: -- IN
124: -- p_api_version_number IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
128: -- P_MOH_Rec IN MOH_Rec_Type Required
129: --
130: -- OUT:

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

139: --
140: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
141: PROCEDURE Update_orderheaders(
142: P_Api_Version_Number IN NUMBER,
143: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
144: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
145: P_Identity_Salesforce_Id IN NUMBER := NULL,
146: P_MOH_Rec IN MOH_Rec_Type,
147: X_Return_Status OUT NOCOPY VARCHAR2,

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

140: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
141: PROCEDURE Update_orderheaders(
142: P_Api_Version_Number IN NUMBER,
143: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
144: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
145: P_Identity_Salesforce_Id IN NUMBER := NULL,
146: P_MOH_Rec IN MOH_Rec_Type,
147: X_Return_Status OUT NOCOPY VARCHAR2,
148: X_Msg_Count OUT NOCOPY NUMBER,

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

157: -- Pre-Req :
158: -- Parameters:
159: -- IN
160: -- p_api_version_number IN NUMBER Required
161: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
162: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
163: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
164: -- P_MOH_Rec IN MOH_Rec_Type Required
165: --

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

158: -- Parameters:
159: -- IN
160: -- p_api_version_number IN NUMBER Required
161: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
162: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
163: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
164: -- P_MOH_Rec IN MOH_Rec_Type Required
165: --
166: -- OUT:

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

176: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
177: -- The Master delete procedure may not be needed depends on different business requirements.
178: PROCEDURE Delete_orderheaders(
179: P_Api_Version_Number IN NUMBER,
180: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
181: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
182: P_identity_salesforce_id IN NUMBER := NULL,
183: P_MOH_Rec IN MOH_Rec_Type,
184: X_Return_Status OUT NOCOPY VARCHAR2,

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

177: -- The Master delete procedure may not be needed depends on different business requirements.
178: PROCEDURE Delete_orderheaders(
179: P_Api_Version_Number IN NUMBER,
180: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
181: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
182: P_identity_salesforce_id IN NUMBER := NULL,
183: P_MOH_Rec IN MOH_Rec_Type,
184: X_Return_Status OUT NOCOPY VARCHAR2,
185: X_Msg_Count OUT NOCOPY NUMBER,

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

194: -- Pre-Req :
195: -- Parameters:
196: -- IN
197: -- p_api_version_number IN NUMBER Required
198: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
199: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
200: -- P_MOH_Rec IN MOH_Rec_Type Required
201: -- Hint: Add List of bind variables here
202: -- p_rec_requested IN NUMBER Optional Default = 30

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

204: --
205: -- Return Total Records Count Flag. This flag controls whether the total record count
206: -- and total record amount is returned.
207: --
208: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
209: -- Hint: User defined record type
210: -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
211: --
212: -- OUT:

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

226: -- End of Comments
227: --
228: PROCEDURE Get_orderheaders(
229: P_Api_Version_Number IN NUMBER,
230: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
231: P_identity_salesforce_id IN NUMBER := NULL,
232: P_MOH_Rec IN CSP_orderheaders_PUB.MOH_Rec_Type,
233: -- Hint: Add list of bind variables here
234: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

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

232: P_MOH_Rec IN CSP_orderheaders_PUB.MOH_Rec_Type,
233: -- Hint: Add list of bind variables here
234: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
235: p_start_rec_prt IN NUMBER := 1,
236: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
237: -- Hint: user defined record type
238: p_order_by_rec IN CSP_orderheaders_PUB.MOH_sort_rec_type,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,