DBA Data[Home] [Help]

APPS.CN_SRP_QUOTA_RATES_PKG dependencies on FND_API

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

42: -- 06-JUN-2000 mblum Created --+
43: -------------------------------------------------------------------------------+
44: PROCEDURE update_row
45: (SRP_QUOTA_RATE_ID IN NUMBER,
46: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
47: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
48: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
49: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
50: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,

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

43: -------------------------------------------------------------------------------+
44: PROCEDURE update_row
45: (SRP_QUOTA_RATE_ID IN NUMBER,
46: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
47: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
48: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
49: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
50: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
51: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,

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

44: PROCEDURE update_row
45: (SRP_QUOTA_RATE_ID IN NUMBER,
46: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
47: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
48: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
49: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
50: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
51: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
52: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

45: (SRP_QUOTA_RATE_ID IN NUMBER,
46: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
47: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
48: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
49: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
50: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
51: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
52: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

46: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
47: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
48: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
49: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
50: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
51: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
52: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

47: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
48: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
49: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
50: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
51: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
52: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

48: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
49: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
50: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
51: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
52: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

49: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
50: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
51: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
52: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

50: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
51: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
52: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

51: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
52: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

52: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

53: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

54: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

55: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

56: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

57: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

58: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

59: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR);

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

60: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR);
68:

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

61: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR);
68:
69: -------------------------------------------------------------------------------+

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

62: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR);
68:
69: -------------------------------------------------------------------------------+
70: -- Procedure Name : Delete_Row --+

Line 67: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR);

63: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR);
68:
69: -------------------------------------------------------------------------------+
70: -- Procedure Name : Delete_Row --+
71: -- Purpose : Delete the specified row in the cn_srp_quota_rates table;--+