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

Line 72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,

68: -- 06-JUN-2000 mblum Created --+
69: -------------------------------------------------------------------------------+
70: PROCEDURE update_row
71: (SRP_QUOTA_RATE_ID IN NUMBER,
72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,

69: -------------------------------------------------------------------------------+
70: PROCEDURE update_row
71: (SRP_QUOTA_RATE_ID IN NUMBER,
72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,

Line 74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,

70: PROCEDURE update_row
71: (SRP_QUOTA_RATE_ID IN NUMBER,
72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,

71: (SRP_QUOTA_RATE_ID IN NUMBER,
72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,

72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,

73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS

Line 90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS
94:

Line 91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS
94:
95: l_srp_quota_rate_id number := srp_quota_rate_id;

Line 92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS
94:
95: l_srp_quota_rate_id number := srp_quota_rate_id;
96: l_srp_quota_cate_id number;

Line 93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS

89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS
94:
95: l_srp_quota_rate_id number := srp_quota_rate_id;
96: l_srp_quota_cate_id number;
97: l_role_quota_rate_id number;

Line 129: MN NUMBER := FND_API.G_MISS_NUM;

125: attribute13, attribute14, attribute15, object_version_number
126: FROM cn_srp_quota_rates r
127: WHERE r.srp_quota_rate_id = l_srp_quota_rate_id;
128:
129: MN NUMBER := FND_API.G_MISS_NUM;
130: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
131:
132: BEGIN
133: OPEN l_update_csr;

Line 130: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

126: FROM cn_srp_quota_rates r
127: WHERE r.srp_quota_rate_id = l_srp_quota_rate_id;
128:
129: MN NUMBER := FND_API.G_MISS_NUM;
130: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
131:
132: BEGIN
133: OPEN l_update_csr;
134: FETCH l_update_csr INTO l_srp_quota_cate_id, l_quota_category_id,