APPS.AS_INTEREST_PUB dependencies on FND_API

Line 46: -- FND_API.G_MISS for update purpose

42: -- Add interest_id, customer_id, address_id,
43: -- contact_id and lead_id into
44: -- interest record
45: -- Changed interest rec default value NULL to
46: -- FND_API.G_MISS for update purpose
47: -- 11/03/03 GBATRA Product Hierarchy Uptake
48: --
49:
50:

Line 73: interest_id NUMBER := FND_API.G_MISS_NUM,

69: -- End of Comments
70:
71: TYPE interest_rec_type IS RECORD
72: (
73: interest_id NUMBER := FND_API.G_MISS_NUM,
74: customer_id NUMBER := FND_API.G_MISS_NUM,
75: address_id NUMBER := FND_API.G_MISS_NUM,
76: contact_id NUMBER := FND_API.G_MISS_NUM,
77: lead_id NUMBER := FND_API.G_MISS_NUM,

Line 74: customer_id NUMBER := FND_API.G_MISS_NUM,

70:
71: TYPE interest_rec_type IS RECORD
72: (
73: interest_id NUMBER := FND_API.G_MISS_NUM,
74: customer_id NUMBER := FND_API.G_MISS_NUM,
75: address_id NUMBER := FND_API.G_MISS_NUM,
76: contact_id NUMBER := FND_API.G_MISS_NUM,
77: lead_id NUMBER := FND_API.G_MISS_NUM,
78: interest_type_id NUMBER := FND_API.G_MISS_NUM,

Line 75: address_id NUMBER := FND_API.G_MISS_NUM,

71: TYPE interest_rec_type IS RECORD
72: (
73: interest_id NUMBER := FND_API.G_MISS_NUM,
74: customer_id NUMBER := FND_API.G_MISS_NUM,
75: address_id NUMBER := FND_API.G_MISS_NUM,
76: contact_id NUMBER := FND_API.G_MISS_NUM,
77: lead_id NUMBER := FND_API.G_MISS_NUM,
78: interest_type_id NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,

Line 76: contact_id NUMBER := FND_API.G_MISS_NUM,

72: (
73: interest_id NUMBER := FND_API.G_MISS_NUM,
74: customer_id NUMBER := FND_API.G_MISS_NUM,
75: address_id NUMBER := FND_API.G_MISS_NUM,
76: contact_id NUMBER := FND_API.G_MISS_NUM,
77: lead_id NUMBER := FND_API.G_MISS_NUM,
78: interest_type_id NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 77: lead_id NUMBER := FND_API.G_MISS_NUM,

73: interest_id NUMBER := FND_API.G_MISS_NUM,
74: customer_id NUMBER := FND_API.G_MISS_NUM,
75: address_id NUMBER := FND_API.G_MISS_NUM,
76: contact_id NUMBER := FND_API.G_MISS_NUM,
77: lead_id NUMBER := FND_API.G_MISS_NUM,
78: interest_type_id NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_updated_by NUMBER := FND_API.G_MISS_NUM,
81: creation_date DATE := FND_API.G_MISS_DATE,

Line 78: interest_type_id NUMBER := FND_API.G_MISS_NUM,

74: customer_id NUMBER := FND_API.G_MISS_NUM,
75: address_id NUMBER := FND_API.G_MISS_NUM,
76: contact_id NUMBER := FND_API.G_MISS_NUM,
77: lead_id NUMBER := FND_API.G_MISS_NUM,
78: interest_type_id NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_updated_by NUMBER := FND_API.G_MISS_NUM,
81: creation_date DATE := FND_API.G_MISS_DATE,
82: created_by NUMBER := FND_API.G_MISS_NUM,

Line 79: last_update_date DATE := FND_API.G_MISS_DATE,

75: address_id NUMBER := FND_API.G_MISS_NUM,
76: contact_id NUMBER := FND_API.G_MISS_NUM,
77: lead_id NUMBER := FND_API.G_MISS_NUM,
78: interest_type_id NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_updated_by NUMBER := FND_API.G_MISS_NUM,
81: creation_date DATE := FND_API.G_MISS_DATE,
82: created_by NUMBER := FND_API.G_MISS_NUM,
83: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 80: last_updated_by NUMBER := FND_API.G_MISS_NUM,

76: contact_id NUMBER := FND_API.G_MISS_NUM,
77: lead_id NUMBER := FND_API.G_MISS_NUM,
78: interest_type_id NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_updated_by NUMBER := FND_API.G_MISS_NUM,
81: creation_date DATE := FND_API.G_MISS_DATE,
82: created_by NUMBER := FND_API.G_MISS_NUM,
83: last_update_login NUMBER := FND_API.G_MISS_NUM,
84: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 81: creation_date DATE := FND_API.G_MISS_DATE,

77: lead_id NUMBER := FND_API.G_MISS_NUM,
78: interest_type_id NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_updated_by NUMBER := FND_API.G_MISS_NUM,
81: creation_date DATE := FND_API.G_MISS_DATE,
82: created_by NUMBER := FND_API.G_MISS_NUM,
83: last_update_login NUMBER := FND_API.G_MISS_NUM,
84: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
85: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,

Line 82: created_by NUMBER := FND_API.G_MISS_NUM,

78: interest_type_id NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_updated_by NUMBER := FND_API.G_MISS_NUM,
81: creation_date DATE := FND_API.G_MISS_DATE,
82: created_by NUMBER := FND_API.G_MISS_NUM,
83: last_update_login NUMBER := FND_API.G_MISS_NUM,
84: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
85: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
86: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,

Line 83: last_update_login NUMBER := FND_API.G_MISS_NUM,

79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_updated_by NUMBER := FND_API.G_MISS_NUM,
81: creation_date DATE := FND_API.G_MISS_DATE,
82: created_by NUMBER := FND_API.G_MISS_NUM,
83: last_update_login NUMBER := FND_API.G_MISS_NUM,
84: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
85: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
86: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
87: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,

Line 84: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,

80: last_updated_by NUMBER := FND_API.G_MISS_NUM,
81: creation_date DATE := FND_API.G_MISS_DATE,
82: created_by NUMBER := FND_API.G_MISS_NUM,
83: last_update_login NUMBER := FND_API.G_MISS_NUM,
84: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
85: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
86: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
87: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
88: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,

Line 85: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,

81: creation_date DATE := FND_API.G_MISS_DATE,
82: created_by NUMBER := FND_API.G_MISS_NUM,
83: last_update_login NUMBER := FND_API.G_MISS_NUM,
84: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
85: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
86: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
87: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
88: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
89: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 86: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,

82: created_by NUMBER := FND_API.G_MISS_NUM,
83: last_update_login NUMBER := FND_API.G_MISS_NUM,
84: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
85: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
86: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
87: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
88: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
89: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: status VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 87: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,

83: last_update_login NUMBER := FND_API.G_MISS_NUM,
84: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
85: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
86: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
87: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
88: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
89: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
91: description VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 88: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,

84: interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
85: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
86: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
87: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
88: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
89: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
91: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 89: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

85: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
86: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
87: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
88: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
89: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
91: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 90: status VARCHAR2(80) := FND_API.G_MISS_CHAR,

86: primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
87: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
88: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
89: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
91: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 91: description VARCHAR2(240) := FND_API.G_MISS_CHAR,

87: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
88: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
89: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
91: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

88: secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
89: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
91: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 93: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

89: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
91: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 94: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

90: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
91: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 95: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

91: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 96: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

92: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 97: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

93: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 98: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

94: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 99: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

95: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 100: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

96: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 101: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

97: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 102: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

98: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 103: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

99: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 104: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

100: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108: product_category_id NUMBER := FND_API.G_MISS_NUM,

Line 105: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

101: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108: product_category_id NUMBER := FND_API.G_MISS_NUM,
109: product_cat_set_id NUMBER := FND_API.G_MISS_NUM

Line 106: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

102: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108: product_category_id NUMBER := FND_API.G_MISS_NUM,
109: product_cat_set_id NUMBER := FND_API.G_MISS_NUM
110: );

Line 107: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

103: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108: product_category_id NUMBER := FND_API.G_MISS_NUM,
109: product_cat_set_id NUMBER := FND_API.G_MISS_NUM
110: );
111:

Line 108: product_category_id NUMBER := FND_API.G_MISS_NUM,

104: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108: product_category_id NUMBER := FND_API.G_MISS_NUM,
109: product_cat_set_id NUMBER := FND_API.G_MISS_NUM
110: );
111:
112: G_MISS_INTEREST_REC interest_rec_type;

Line 109: product_cat_set_id NUMBER := FND_API.G_MISS_NUM

105: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108: product_category_id NUMBER := FND_API.G_MISS_NUM,
109: product_cat_set_id NUMBER := FND_API.G_MISS_NUM
110: );
111:
112: G_MISS_INTEREST_REC interest_rec_type;
113:

Line 156: ( interest_code_id NUMBER := FND_API.G_MISS_NUM,

152: --
153: -- End of Comments
154:
155: TYPE interest_code_rec_type IS RECORD
156: ( interest_code_id NUMBER := FND_API.G_MISS_NUM,
157: code VARCHAR2(100) := FND_API.G_MISS_CHAR,
158: interest_type_id NUMBER := FND_API.G_MISS_NUM,
159: revenue_class_id NUMBER := FND_API.G_MISS_NUM,
160: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 157: code VARCHAR2(100) := FND_API.G_MISS_CHAR,

153: -- End of Comments
154:
155: TYPE interest_code_rec_type IS RECORD
156: ( interest_code_id NUMBER := FND_API.G_MISS_NUM,
157: code VARCHAR2(100) := FND_API.G_MISS_CHAR,
158: interest_type_id NUMBER := FND_API.G_MISS_NUM,
159: revenue_class_id NUMBER := FND_API.G_MISS_NUM,
160: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: parent_interest_code_id NUMBER := FND_API.G_MISS_NUM,

Line 158: interest_type_id NUMBER := FND_API.G_MISS_NUM,

154:
155: TYPE interest_code_rec_type IS RECORD
156: ( interest_code_id NUMBER := FND_API.G_MISS_NUM,
157: code VARCHAR2(100) := FND_API.G_MISS_CHAR,
158: interest_type_id NUMBER := FND_API.G_MISS_NUM,
159: revenue_class_id NUMBER := FND_API.G_MISS_NUM,
160: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: parent_interest_code_id NUMBER := FND_API.G_MISS_NUM,
162: description VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 159: revenue_class_id NUMBER := FND_API.G_MISS_NUM,

155: TYPE interest_code_rec_type IS RECORD
156: ( interest_code_id NUMBER := FND_API.G_MISS_NUM,
157: code VARCHAR2(100) := FND_API.G_MISS_CHAR,
158: interest_type_id NUMBER := FND_API.G_MISS_NUM,
159: revenue_class_id NUMBER := FND_API.G_MISS_NUM,
160: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: parent_interest_code_id NUMBER := FND_API.G_MISS_NUM,
162: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: category_id NUMBER := FND_API.G_MISS_NUM,

Line 160: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

156: ( interest_code_id NUMBER := FND_API.G_MISS_NUM,
157: code VARCHAR2(100) := FND_API.G_MISS_CHAR,
158: interest_type_id NUMBER := FND_API.G_MISS_NUM,
159: revenue_class_id NUMBER := FND_API.G_MISS_NUM,
160: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: parent_interest_code_id NUMBER := FND_API.G_MISS_NUM,
162: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: category_id NUMBER := FND_API.G_MISS_NUM,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,

Line 161: parent_interest_code_id NUMBER := FND_API.G_MISS_NUM,

157: code VARCHAR2(100) := FND_API.G_MISS_CHAR,
158: interest_type_id NUMBER := FND_API.G_MISS_NUM,
159: revenue_class_id NUMBER := FND_API.G_MISS_NUM,
160: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: parent_interest_code_id NUMBER := FND_API.G_MISS_NUM,
162: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: category_id NUMBER := FND_API.G_MISS_NUM,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: org_id NUMBER := FND_API.G_MISS_NUM,

Line 162: description VARCHAR2(240) := FND_API.G_MISS_CHAR,

158: interest_type_id NUMBER := FND_API.G_MISS_NUM,
159: revenue_class_id NUMBER := FND_API.G_MISS_NUM,
160: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: parent_interest_code_id NUMBER := FND_API.G_MISS_NUM,
162: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: category_id NUMBER := FND_API.G_MISS_NUM,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: org_id NUMBER := FND_API.G_MISS_NUM,
166: pf_item_id NUMBER := FND_API.G_MISS_NUM,

Line 163: category_id NUMBER := FND_API.G_MISS_NUM,

159: revenue_class_id NUMBER := FND_API.G_MISS_NUM,
160: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: parent_interest_code_id NUMBER := FND_API.G_MISS_NUM,
162: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: category_id NUMBER := FND_API.G_MISS_NUM,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: org_id NUMBER := FND_API.G_MISS_NUM,
166: pf_item_id NUMBER := FND_API.G_MISS_NUM,
167: pf_organization_id NUMBER := FND_API.G_MISS_NUM,

Line 164: category_set_id NUMBER := FND_API.G_MISS_NUM,

160: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: parent_interest_code_id NUMBER := FND_API.G_MISS_NUM,
162: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: category_id NUMBER := FND_API.G_MISS_NUM,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: org_id NUMBER := FND_API.G_MISS_NUM,
166: pf_item_id NUMBER := FND_API.G_MISS_NUM,
167: pf_organization_id NUMBER := FND_API.G_MISS_NUM,
168: price NUMBER := FND_API.G_MISS_NUM,

Line 165: org_id NUMBER := FND_API.G_MISS_NUM,

161: parent_interest_code_id NUMBER := FND_API.G_MISS_NUM,
162: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: category_id NUMBER := FND_API.G_MISS_NUM,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: org_id NUMBER := FND_API.G_MISS_NUM,
166: pf_item_id NUMBER := FND_API.G_MISS_NUM,
167: pf_organization_id NUMBER := FND_API.G_MISS_NUM,
168: price NUMBER := FND_API.G_MISS_NUM,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 166: pf_item_id NUMBER := FND_API.G_MISS_NUM,

162: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
163: category_id NUMBER := FND_API.G_MISS_NUM,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: org_id NUMBER := FND_API.G_MISS_NUM,
166: pf_item_id NUMBER := FND_API.G_MISS_NUM,
167: pf_organization_id NUMBER := FND_API.G_MISS_NUM,
168: price NUMBER := FND_API.G_MISS_NUM,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: attribute_category VARCHAR2(30),

Line 167: pf_organization_id NUMBER := FND_API.G_MISS_NUM,

163: category_id NUMBER := FND_API.G_MISS_NUM,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: org_id NUMBER := FND_API.G_MISS_NUM,
166: pf_item_id NUMBER := FND_API.G_MISS_NUM,
167: pf_organization_id NUMBER := FND_API.G_MISS_NUM,
168: price NUMBER := FND_API.G_MISS_NUM,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: attribute_category VARCHAR2(30),
171: attribute1 VARCHAR2(150),

Line 168: price NUMBER := FND_API.G_MISS_NUM,

164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: org_id NUMBER := FND_API.G_MISS_NUM,
166: pf_item_id NUMBER := FND_API.G_MISS_NUM,
167: pf_organization_id NUMBER := FND_API.G_MISS_NUM,
168: price NUMBER := FND_API.G_MISS_NUM,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: attribute_category VARCHAR2(30),
171: attribute1 VARCHAR2(150),
172: attribute2 VARCHAR2(150),

Line 169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

165: org_id NUMBER := FND_API.G_MISS_NUM,
166: pf_item_id NUMBER := FND_API.G_MISS_NUM,
167: pf_organization_id NUMBER := FND_API.G_MISS_NUM,
168: price NUMBER := FND_API.G_MISS_NUM,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: attribute_category VARCHAR2(30),
171: attribute1 VARCHAR2(150),
172: attribute2 VARCHAR2(150),
173: attribute3 VARCHAR2(150),

Line 186: product_category_id NUMBER := FND_API.G_MISS_NUM,

182: attribute12 VARCHAR2(150),
183: attribute13 VARCHAR2(150),
184: attribute14 VARCHAR2(150),
185: attribute15 VARCHAR2(150),
186: product_category_id NUMBER := FND_API.G_MISS_NUM,
187: product_cat_set_id NUMBER := FND_API.G_MISS_NUM
188: );
189:
190:

Line 187: product_cat_set_id NUMBER := FND_API.G_MISS_NUM

183: attribute13 VARCHAR2(150),
184: attribute14 VARCHAR2(150),
185: attribute15 VARCHAR2(150),
186: product_category_id NUMBER := FND_API.G_MISS_NUM,
187: product_cat_set_id NUMBER := FND_API.G_MISS_NUM
188: );
189:
190:
191: -- Start of Comments

Line 215: -- Default = FND_API.G_FALSE

211: -- Parameters :
212: -- IN :
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional
215: -- Default = FND_API.G_FALSE
216: -- p_commit IN VARCHAR2 Optional
217: -- Default = FND_API.G_FALSE
218: -- p_interest_tbl IN INTEREST_REC_TYPE Optional
219: --

Line 217: -- Default = FND_API.G_FALSE

213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional
215: -- Default = FND_API.G_FALSE
216: -- p_commit IN VARCHAR2 Optional
217: -- Default = FND_API.G_FALSE
218: -- p_interest_tbl IN INTEREST_REC_TYPE Optional
219: --
220: -- OUT :
221: -- p_return_status OUT VARCHAR2(1)

Line 237: ,p_init_msg_list in varchar2 := fnd_api.g_false

233: --
234: -- End of Comments
235: --
236: Procedure create_interest(p_api_version_number in number
237: ,p_init_msg_list in varchar2 := fnd_api.g_false
238: ,p_commit in varchar2 := fnd_api.g_false
239: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
240: ,p_interest_rec in interest_rec_type
241: ,p_customer_id in number

Line 238: ,p_commit in varchar2 := fnd_api.g_false

234: -- End of Comments
235: --
236: Procedure create_interest(p_api_version_number in number
237: ,p_init_msg_list in varchar2 := fnd_api.g_false
238: ,p_commit in varchar2 := fnd_api.g_false
239: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
240: ,p_interest_rec in interest_rec_type
241: ,p_customer_id in number
242: ,p_address_id in number

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

235: --
236: Procedure create_interest(p_api_version_number in number
237: ,p_init_msg_list in varchar2 := fnd_api.g_false
238: ,p_commit in varchar2 := fnd_api.g_false
239: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
240: ,p_interest_rec in interest_rec_type
241: ,p_customer_id in number
242: ,p_address_id in number
243: ,p_contact_id in number

Line 267: -- Default = FND_API.G_FALSE

263: -- Parameters
264: -- IN :
265: -- p_api_version_number IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional
267: -- Default = FND_API.G_FALSE
268: -- p_commit IN VARCHAR2 Optional
269: -- Default = FND_API.G_FALSE
270: -- p_validation_level IN NUMBER Optional
271: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 269: -- Default = FND_API.G_FALSE

265: -- p_api_version_number IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional
267: -- Default = FND_API.G_FALSE
268: -- p_commit IN VARCHAR2 Optional
269: -- Default = FND_API.G_FALSE
270: -- p_validation_level IN NUMBER Optional
271: -- Default = FND_API.G_VALID_LEVEL_FULL
272: -- p_identity_salesforce_id IN NUMBER Optional
273: -- p_interest_rec IN INTEREST_REC_TYPE Required

Line 271: -- Default = FND_API.G_VALID_LEVEL_FULL

267: -- Default = FND_API.G_FALSE
268: -- p_commit IN VARCHAR2 Optional
269: -- Default = FND_API.G_FALSE
270: -- p_validation_level IN NUMBER Optional
271: -- Default = FND_API.G_VALID_LEVEL_FULL
272: -- p_identity_salesforce_id IN NUMBER Optional
273: -- p_interest_rec IN INTEREST_REC_TYPE Required
274: -- p_interest_use_code IN VARCHAR2 Required
275: -- (LEAD_CLASSIFICATION, COMPANY_CLASSIFICATION,

Line 295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

291: --
292:
293: PROCEDURE Update_Interest
294: ( p_api_version_number IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
298: p_identity_salesforce_id IN NUMBER := NULL,
299: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,

Line 296: p_commit IN VARCHAR2 := FND_API.G_FALSE,

292:
293: PROCEDURE Update_Interest
294: ( p_api_version_number IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
298: p_identity_salesforce_id IN NUMBER := NULL,
299: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
300: p_interest_use_code IN VARCHAR2,

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

293: PROCEDURE Update_Interest
294: ( p_api_version_number IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
298: p_identity_salesforce_id IN NUMBER := NULL,
299: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
300: p_interest_use_code IN VARCHAR2,
301: p_check_access_flag in varchar2,

Line 365: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

361: );
362:
363: PROCEDURE Delete_Interest
364: ( p_api_version_number IN NUMBER,
365: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
366: p_commit IN VARCHAR2 := FND_API.G_FALSE,
367: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
368: p_identity_salesforce_id IN NUMBER,
369: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,

Line 366: p_commit IN VARCHAR2 := FND_API.G_FALSE,

362:
363: PROCEDURE Delete_Interest
364: ( p_api_version_number IN NUMBER,
365: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
366: p_commit IN VARCHAR2 := FND_API.G_FALSE,
367: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
368: p_identity_salesforce_id IN NUMBER,
369: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
370: p_interest_use_code IN VARCHAR2,

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

363: PROCEDURE Delete_Interest
364: ( p_api_version_number IN NUMBER,
365: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
366: p_commit IN VARCHAR2 := FND_API.G_FALSE,
367: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
368: p_identity_salesforce_id IN NUMBER,
369: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
370: p_interest_use_code IN VARCHAR2,
371: p_check_access_flag in varchar2,