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

Line 62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,

58: -- End of Comments
59:
60: TYPE MOH_Rec_Type IS RECORD
61: (
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

59:
60: TYPE MOH_Rec_Type IS RECORD
61: (
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 64: CREATION_DATE DATE := FND_API.G_MISS_DATE,

60: TYPE MOH_Rec_Type IS RECORD
61: (
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

61: (
62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
69: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

62: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
69: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
70: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
69: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
70: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
69: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
70: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
69: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
70: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
69: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
70: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
69: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
70: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

68: CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
69: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
70: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

69: SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
70: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

70: AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

71: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

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

80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
88: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM

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

81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
88: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM
89: );

Line 86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,

82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
88: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM
89: );
90:

Line 87: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
88: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM
89: );
90:
91: G_MISS_MOH_REC MOH_Rec_Type;

Line 88: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM

84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
88: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM
89: );
90:
91: G_MISS_MOH_REC MOH_Rec_Type;
92: TYPE MOH_Tbl_Type IS TABLE OF MOH_Rec_Type

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

101: -- Pre-Req :
102: -- Parameters:
103: -- IN
104: -- p_api_version_number IN NUMBER Required
105: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
106: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- P_MOH_Rec IN MOH_Rec_Type Required
109: --

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

102: -- Parameters:
103: -- IN
104: -- p_api_version_number IN NUMBER Required
105: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
106: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- P_MOH_Rec IN MOH_Rec_Type Required
109: --
110: -- OUT:

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

103: -- IN
104: -- p_api_version_number IN NUMBER Required
105: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
106: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- P_MOH_Rec IN MOH_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_orderheaders(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_MOH_Rec IN MOH_Rec_Type := G_MISS_MOH_REC,
126: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

119: --
120: PROCEDURE Create_orderheaders(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_MOH_Rec IN MOH_Rec_Type := G_MISS_MOH_REC,
126: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
127: X_HEADER_ID OUT NOCOPY NUMBER,

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

120: PROCEDURE Create_orderheaders(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_MOH_Rec IN MOH_Rec_Type := G_MISS_MOH_REC,
126: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
127: X_HEADER_ID OUT NOCOPY NUMBER,
128: X_Return_Status OUT NOCOPY VARCHAR2,

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

138: -- Pre-Req :
139: -- Parameters:
140: -- IN
141: -- p_api_version_number IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
143: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
145: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
146: -- P_MOH_Rec IN MOH_Rec_Type Required

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

139: -- Parameters:
140: -- IN
141: -- p_api_version_number IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
143: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
145: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
146: -- P_MOH_Rec IN MOH_Rec_Type Required
147: --

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

140: -- IN
141: -- p_api_version_number IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
143: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
145: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
146: -- P_MOH_Rec IN MOH_Rec_Type Required
147: --
148: -- OUT:

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

157: --
158: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
159: PROCEDURE Update_orderheaders(
160: P_Api_Version_Number IN NUMBER,
161: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: P_Identity_Salesforce_Id IN NUMBER := NULL,
165: P_MOH_Rec IN MOH_Rec_Type,

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

158: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
159: PROCEDURE Update_orderheaders(
160: P_Api_Version_Number IN NUMBER,
161: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: P_Identity_Salesforce_Id IN NUMBER := NULL,
165: P_MOH_Rec IN MOH_Rec_Type,
166: X_Return_Status OUT NOCOPY VARCHAR2,

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

159: PROCEDURE Update_orderheaders(
160: P_Api_Version_Number IN NUMBER,
161: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: P_Identity_Salesforce_Id IN NUMBER := NULL,
165: P_MOH_Rec IN MOH_Rec_Type,
166: X_Return_Status OUT NOCOPY VARCHAR2,
167: X_Msg_Count OUT NOCOPY NUMBER,

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

176: -- Pre-Req :
177: -- Parameters:
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
184: -- P_MOH_Rec IN MOH_Rec_Type Required

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

177: -- Parameters:
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
184: -- P_MOH_Rec IN MOH_Rec_Type Required
185: --

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

178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
184: -- P_MOH_Rec IN MOH_Rec_Type Required
185: --
186: -- OUT:

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

196: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
197: -- The Master delete procedure may not be needed depends on different business requirements.
198: PROCEDURE Delete_orderheaders(
199: P_Api_Version_Number IN NUMBER,
200: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
201: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: P_identity_salesforce_id IN NUMBER := NULL,
204: P_MOH_Rec IN MOH_Rec_Type,

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

197: -- The Master delete procedure may not be needed depends on different business requirements.
198: PROCEDURE Delete_orderheaders(
199: P_Api_Version_Number IN NUMBER,
200: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
201: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: P_identity_salesforce_id IN NUMBER := NULL,
204: P_MOH_Rec IN MOH_Rec_Type,
205: X_Return_Status OUT NOCOPY VARCHAR2,

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

198: PROCEDURE Delete_orderheaders(
199: P_Api_Version_Number IN NUMBER,
200: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
201: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: P_identity_salesforce_id IN NUMBER := NULL,
204: P_MOH_Rec IN MOH_Rec_Type,
205: X_Return_Status OUT NOCOPY VARCHAR2,
206: X_Msg_Count OUT NOCOPY NUMBER,

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

218: --
219: -- End of Comments
220:
221: PROCEDURE Validate_HEADER_ID (
222: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
223: P_Validation_mode IN VARCHAR2,
224: P_HEADER_ID IN NUMBER,
225: -- 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.
226: X_Return_Status OUT NOCOPY VARCHAR2,

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

239: --
240: -- End of Comments
241:
242: PROCEDURE Validate_CARRIER (
243: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
244: P_Validation_mode IN VARCHAR2,
245: P_CARRIER IN VARCHAR2,
246: -- 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.
247: X_Return_Status OUT NOCOPY VARCHAR2,

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

260: --
261: -- End of Comments
262:
263: PROCEDURE Validate_SHIPMENT_METHOD (
264: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
265: P_Validation_mode IN VARCHAR2,
266: P_SHIPMENT_METHOD IN VARCHAR2,
267: -- 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.
268: X_Return_Status OUT NOCOPY VARCHAR2,

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

281: --
282: -- End of Comments
283:
284: PROCEDURE Validate_AUTORECEIPT_FLAG (
285: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
286: P_Validation_mode IN VARCHAR2,
287: P_AUTORECEIPT_FLAG IN VARCHAR2,
288: -- 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.
289: X_Return_Status OUT NOCOPY VARCHAR2,

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

304:
305: /* START OF CHANGES - PHEGDE 02/28
306:
307: PROCEDURE Validate_ADDRESS1 (
308: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
309: P_Validation_mode IN VARCHAR2,
310: P_ADDRESS1 IN VARCHAR2,
311: -- 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.
312: X_Return_Status OUT NOCOPY VARCHAR2,

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

325: --
326: -- End of Comments
327:
328: PROCEDURE Validate_ADDRESS2 (
329: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
330: P_Validation_mode IN VARCHAR2,
331: P_ADDRESS2 IN VARCHAR2,
332: -- 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.
333: X_Return_Status OUT NOCOPY VARCHAR2,

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

346: --
347: -- End of Comments
348:
349: PROCEDURE Validate_ADDRESS3 (
350: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
351: P_Validation_mode IN VARCHAR2,
352: P_ADDRESS3 IN VARCHAR2,
353: -- 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.
354: X_Return_Status OUT NOCOPY VARCHAR2,

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

367: --
368: -- End of Comments
369:
370: PROCEDURE Validate_ADDRESS4 (
371: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
372: P_Validation_mode IN VARCHAR2,
373: P_ADDRESS4 IN VARCHAR2,
374: -- 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.
375: X_Return_Status OUT NOCOPY VARCHAR2,

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

388: --
389: -- End of Comments
390:
391: PROCEDURE Validate_CITY (
392: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393: P_Validation_mode IN VARCHAR2,
394: P_CITY IN VARCHAR2,
395: -- 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.
396: X_Return_Status OUT NOCOPY VARCHAR2,

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

409: --
410: -- End of Comments
411:
412: PROCEDURE Validate_POSTAL_CODE (
413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414: P_Validation_mode IN VARCHAR2,
415: P_POSTAL_CODE IN VARCHAR2,
416: -- 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.
417: X_Return_Status OUT NOCOPY VARCHAR2,

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

430: --
431: -- End of Comments
432:
433: PROCEDURE Validate_STATE (
434: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
435: P_Validation_mode IN VARCHAR2,
436: P_STATE IN VARCHAR2,
437: -- 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.
438: X_Return_Status OUT NOCOPY VARCHAR2,

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

451: --
452: -- End of Comments
453:
454: PROCEDURE Validate_PROVINCE (
455: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
456: P_Validation_mode IN VARCHAR2,
457: P_PROVINCE IN VARCHAR2,
458: -- 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.
459: X_Return_Status OUT NOCOPY VARCHAR2,

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

472: --
473: -- End of Comments
474:
475: PROCEDURE Validate_COUNTRY (
476: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
477: P_Validation_mode IN VARCHAR2,
478: P_COUNTRY IN VARCHAR2,
479: -- 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.
480: X_Return_Status OUT NOCOPY VARCHAR2,

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

496: -- 2. Developer can manually added inter-field level validation.
497: -- End of Comments
498:
499: PROCEDURE Validate_MOH_rec(
500: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
501: P_Validation_mode IN VARCHAR2,
502: P_MOH_Rec IN MOH_Rec_Type,
503: X_Return_Status OUT NOCOPY VARCHAR2,
504: X_Msg_Count OUT NOCOPY NUMBER,

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

516: -- 2. We can also validate table instead of record. There will be an option for user to choose.
517: -- End of Comments
518:
519: PROCEDURE Validate_orderheaders(
520: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
521: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
522: P_Validation_mode IN VARCHAR2,
523: P_MOH_Rec IN MOH_Rec_Type,
524: X_Return_Status OUT NOCOPY VARCHAR2,

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

517: -- End of Comments
518:
519: PROCEDURE Validate_orderheaders(
520: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
521: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
522: P_Validation_mode IN VARCHAR2,
523: P_MOH_Rec IN MOH_Rec_Type,
524: X_Return_Status OUT NOCOPY VARCHAR2,
525: X_Msg_Count OUT NOCOPY NUMBER,