DBA Data[Home] [Help]

APPS.AS_INTEREST_PVT dependencies on FND_API

Line 28: -- FND_API.G_MISS for update purpose

24: -- Add interest_id, customer_id, address_id,
25: -- contact_id and lead_id into
26: -- interest record
27: -- Changed interest rec default value NULL to
28: -- FND_API.G_MISS for update purpose
29: -- 11/03/03 GBATRA Product Hierarchy Uptake
30: --
31:
32:

Line 51: ( interest_id NUMBER := FND_API.G_MISS_NUM,

47: --
48: -- End of Comments
49:
50: TYPE interest_rec_type IS RECORD
51: ( interest_id NUMBER := FND_API.G_MISS_NUM,
52: customer_id NUMBER := FND_API.G_MISS_NUM,
53: address_id NUMBER := FND_API.G_MISS_NUM,
54: contact_id NUMBER := FND_API.G_MISS_NUM,
55: lead_id NUMBER := FND_API.G_MISS_NUM,

Line 52: customer_id NUMBER := FND_API.G_MISS_NUM,

48: -- End of Comments
49:
50: TYPE interest_rec_type IS RECORD
51: ( interest_id NUMBER := FND_API.G_MISS_NUM,
52: customer_id NUMBER := FND_API.G_MISS_NUM,
53: address_id NUMBER := FND_API.G_MISS_NUM,
54: contact_id NUMBER := FND_API.G_MISS_NUM,
55: lead_id NUMBER := FND_API.G_MISS_NUM,
56: interest_type_id NUMBER := FND_API.G_MISS_NUM,

Line 53: address_id NUMBER := FND_API.G_MISS_NUM,

49:
50: TYPE interest_rec_type IS RECORD
51: ( interest_id NUMBER := FND_API.G_MISS_NUM,
52: customer_id NUMBER := FND_API.G_MISS_NUM,
53: address_id NUMBER := FND_API.G_MISS_NUM,
54: contact_id NUMBER := FND_API.G_MISS_NUM,
55: lead_id NUMBER := FND_API.G_MISS_NUM,
56: interest_type_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,

Line 54: contact_id NUMBER := FND_API.G_MISS_NUM,

50: TYPE interest_rec_type IS RECORD
51: ( interest_id NUMBER := FND_API.G_MISS_NUM,
52: customer_id NUMBER := FND_API.G_MISS_NUM,
53: address_id NUMBER := FND_API.G_MISS_NUM,
54: contact_id NUMBER := FND_API.G_MISS_NUM,
55: lead_id NUMBER := FND_API.G_MISS_NUM,
56: interest_type_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 55: lead_id NUMBER := FND_API.G_MISS_NUM,

51: ( interest_id NUMBER := FND_API.G_MISS_NUM,
52: customer_id NUMBER := FND_API.G_MISS_NUM,
53: address_id NUMBER := FND_API.G_MISS_NUM,
54: contact_id NUMBER := FND_API.G_MISS_NUM,
55: lead_id NUMBER := FND_API.G_MISS_NUM,
56: interest_type_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,

Line 56: interest_type_id NUMBER := FND_API.G_MISS_NUM,

52: customer_id NUMBER := FND_API.G_MISS_NUM,
53: address_id NUMBER := FND_API.G_MISS_NUM,
54: contact_id NUMBER := FND_API.G_MISS_NUM,
55: lead_id NUMBER := FND_API.G_MISS_NUM,
56: interest_type_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,

Line 57: last_update_date DATE := FND_API.G_MISS_DATE,

53: address_id NUMBER := FND_API.G_MISS_NUM,
54: contact_id NUMBER := FND_API.G_MISS_NUM,
55: lead_id NUMBER := FND_API.G_MISS_NUM,
56: interest_type_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 58: last_updated_by NUMBER := FND_API.G_MISS_NUM,

54: contact_id NUMBER := FND_API.G_MISS_NUM,
55: lead_id NUMBER := FND_API.G_MISS_NUM,
56: interest_type_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,

Line 59: creation_date DATE := FND_API.G_MISS_DATE,

55: lead_id NUMBER := FND_API.G_MISS_NUM,
56: interest_type_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
63: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,

Line 60: created_by NUMBER := FND_API.G_MISS_NUM,

56: interest_type_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
63: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
64: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 61: last_update_login NUMBER := FND_API.G_MISS_NUM,

57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
63: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
64: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: status VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 62: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,

58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
63: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
64: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 63: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,

59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
63: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
64: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
63: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
64: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
63: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
64: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

62: primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
63: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
64: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

63: secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
64: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

64: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

65: status VARCHAR2(80) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

66: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: product_category_id NUMBER := FND_API.G_MISS_NUM,

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

76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: product_category_id NUMBER := FND_API.G_MISS_NUM,
84: product_cat_set_id NUMBER := FND_API.G_MISS_NUM

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

77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: product_category_id NUMBER := FND_API.G_MISS_NUM,
84: product_cat_set_id NUMBER := FND_API.G_MISS_NUM
85: );

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

78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: product_category_id NUMBER := FND_API.G_MISS_NUM,
84: product_cat_set_id NUMBER := FND_API.G_MISS_NUM
85: );
86:

Line 83: product_category_id NUMBER := FND_API.G_MISS_NUM,

79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: product_category_id NUMBER := FND_API.G_MISS_NUM,
84: product_cat_set_id NUMBER := FND_API.G_MISS_NUM
85: );
86:
87: G_MISS_INTEREST_REC interest_rec_type;

Line 84: product_cat_set_id NUMBER := FND_API.G_MISS_NUM

80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: product_category_id NUMBER := FND_API.G_MISS_NUM,
84: product_cat_set_id NUMBER := FND_API.G_MISS_NUM
85: );
86:
87: G_MISS_INTEREST_REC interest_rec_type;
88:

Line 136: -- Default = FND_API.G_FALSE

132: -- Parameters
133: -- IN :
134: -- p_api_version_number IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional
136: -- Default = FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional
140: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 138: -- Default = FND_API.G_FALSE

134: -- p_api_version_number IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional
136: -- Default = FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional
140: -- Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_interest_tbl IN INTEREST_TBL_TYPE Optional
142: -- p_customer_id IN NUMBER Required

Line 140: -- Default = FND_API.G_VALID_LEVEL_FULL

136: -- Default = FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional
140: -- Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_interest_tbl IN INTEREST_TBL_TYPE Optional
142: -- p_customer_id IN NUMBER Required
143: -- p_address_id IN NUMBER Required
144: -- p_contact_id IN NUMBER Optional

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

173: -- End of Comments
174:
175: PROCEDURE Create_Interest
176: ( p_api_version_number IN NUMBER,
177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: p_interest_tbl IN INTEREST_TBL_TYPE := G_MISS_INTEREST_TBL,
181: p_customer_id IN NUMBER,

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

174:
175: PROCEDURE Create_Interest
176: ( p_api_version_number IN NUMBER,
177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: p_interest_tbl IN INTEREST_TBL_TYPE := G_MISS_INTEREST_TBL,
181: p_customer_id IN NUMBER,
182: p_address_id IN NUMBER,

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

175: PROCEDURE Create_Interest
176: ( p_api_version_number IN NUMBER,
177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: p_interest_tbl IN INTEREST_TBL_TYPE := G_MISS_INTEREST_TBL,
181: p_customer_id IN NUMBER,
182: p_address_id IN NUMBER,
183: p_contact_id IN NUMBER,

Line 208: -- Default = FND_API.G_FALSE

204: -- Parameters
205: -- IN :
206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional
208: -- Default = FND_API.G_FALSE
209: -- p_commit IN VARCHAR2 Optional
210: -- Default = FND_API.G_FALSE
211: -- p_validation_level IN NUMBER Optional
212: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 210: -- Default = FND_API.G_FALSE

206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional
208: -- Default = FND_API.G_FALSE
209: -- p_commit IN VARCHAR2 Optional
210: -- Default = FND_API.G_FALSE
211: -- p_validation_level IN NUMBER Optional
212: -- Default = FND_API.G_VALID_LEVEL_FULL
213: -- p_identity_salesforce_id IN NUMBER Optional
214: -- p_interest_rec IN INTEREST_REC_TYPE Required

Line 212: -- Default = FND_API.G_VALID_LEVEL_FULL

208: -- Default = FND_API.G_FALSE
209: -- p_commit IN VARCHAR2 Optional
210: -- Default = FND_API.G_FALSE
211: -- p_validation_level IN NUMBER Optional
212: -- Default = FND_API.G_VALID_LEVEL_FULL
213: -- p_identity_salesforce_id IN NUMBER Optional
214: -- p_interest_rec IN INTEREST_REC_TYPE Required
215: -- p_interest_use_code IN VARCHAR2 Required
216: -- (LEAD_CLASSIFICATION, COMPANY_CLASSIFICATION,

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

229: --
230: --
231: PROCEDURE Update_Interest
232: ( p_api_version_number IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
236: p_identity_salesforce_id IN NUMBER := NULL,
237: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,

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

230: --
231: PROCEDURE Update_Interest
232: ( p_api_version_number IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
236: p_identity_salesforce_id IN NUMBER := NULL,
237: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
238: p_interest_use_code IN VARCHAR2,

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

231: PROCEDURE Update_Interest
232: ( p_api_version_number IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
236: p_identity_salesforce_id IN NUMBER := NULL,
237: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
238: p_interest_use_code IN VARCHAR2,
239: p_check_access_flag IN VARCHAR2,

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

247: );
248:
249: PROCEDURE Delete_Interest
250: ( p_api_version_number IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
254: p_identity_salesforce_id IN NUMBER,
255: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,

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

248:
249: PROCEDURE Delete_Interest
250: ( p_api_version_number IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
254: p_identity_salesforce_id IN NUMBER,
255: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
256: p_interest_use_code IN VARCHAR2,

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

249: PROCEDURE Delete_Interest
250: ( p_api_version_number IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
254: p_identity_salesforce_id IN NUMBER,
255: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
256: p_interest_use_code IN VARCHAR2,
257: p_check_access_flag in varchar2,

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

264: );
265:
266:
267: PROCEDURE Validate_party_id (
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269: p_party_id IN NUMBER,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2