50:
51: --===================================================================
52: TYPE interaction_track_rec_type IS RECORD
53: (
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
51: --===================================================================
52: TYPE interaction_track_rec_type IS RECORD
53: (
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
52: TYPE interaction_track_rec_type IS RECORD
53: (
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: web_content_id NUMBER := FND_API.G_MISS_NUM,
53: (
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: web_content_id NUMBER := FND_API.G_MISS_NUM,
61: obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: web_content_id NUMBER := FND_API.G_MISS_NUM,
61: obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: obj_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: web_content_id NUMBER := FND_API.G_MISS_NUM,
61: obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: obj_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: obj_id NUMBER := FND_API.G_MISS_NUM,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: web_content_id NUMBER := FND_API.G_MISS_NUM,
61: obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: obj_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: obj_id NUMBER := FND_API.G_MISS_NUM,
64: offer_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: web_content_id NUMBER := FND_API.G_MISS_NUM,
61: obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: obj_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: obj_id NUMBER := FND_API.G_MISS_NUM,
64: offer_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: offer_id NUMBER := FND_API.G_MISS_NUM,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: web_content_id NUMBER := FND_API.G_MISS_NUM,
61: obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: obj_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: obj_id NUMBER := FND_API.G_MISS_NUM,
64: offer_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: offer_id NUMBER := FND_API.G_MISS_NUM,
66: party_id NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: web_content_id NUMBER := FND_API.G_MISS_NUM,
61: obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: obj_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: obj_id NUMBER := FND_API.G_MISS_NUM,
64: offer_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: offer_id NUMBER := FND_API.G_MISS_NUM,
66: party_id NUMBER := FND_API.G_MISS_NUM,
67: affiliate_id NUMBER := FND_API.G_MISS_NUM,
60: web_content_id NUMBER := FND_API.G_MISS_NUM,
61: obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: obj_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: obj_id NUMBER := FND_API.G_MISS_NUM,
64: offer_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: offer_id NUMBER := FND_API.G_MISS_NUM,
66: party_id NUMBER := FND_API.G_MISS_NUM,
67: affiliate_id NUMBER := FND_API.G_MISS_NUM,
68: posting_id NUMBER := FND_API.G_MISS_NUM,
61: obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: obj_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: obj_id NUMBER := FND_API.G_MISS_NUM,
64: offer_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: offer_id NUMBER := FND_API.G_MISS_NUM,
66: party_id NUMBER := FND_API.G_MISS_NUM,
67: affiliate_id NUMBER := FND_API.G_MISS_NUM,
68: posting_id NUMBER := FND_API.G_MISS_NUM,
69: did NUMBER := FND_API.G_MISS_NUM,
62: obj_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: obj_id NUMBER := FND_API.G_MISS_NUM,
64: offer_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: offer_id NUMBER := FND_API.G_MISS_NUM,
66: party_id NUMBER := FND_API.G_MISS_NUM,
67: affiliate_id NUMBER := FND_API.G_MISS_NUM,
68: posting_id NUMBER := FND_API.G_MISS_NUM,
69: did NUMBER := FND_API.G_MISS_NUM,
70: flavour VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: obj_id NUMBER := FND_API.G_MISS_NUM,
64: offer_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: offer_id NUMBER := FND_API.G_MISS_NUM,
66: party_id NUMBER := FND_API.G_MISS_NUM,
67: affiliate_id NUMBER := FND_API.G_MISS_NUM,
68: posting_id NUMBER := FND_API.G_MISS_NUM,
69: did NUMBER := FND_API.G_MISS_NUM,
70: flavour VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: web_tracking_id NUMBER := FND_API.G_MISS_NUM
64: offer_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: offer_id NUMBER := FND_API.G_MISS_NUM,
66: party_id NUMBER := FND_API.G_MISS_NUM,
67: affiliate_id NUMBER := FND_API.G_MISS_NUM,
68: posting_id NUMBER := FND_API.G_MISS_NUM,
69: did NUMBER := FND_API.G_MISS_NUM,
70: flavour VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: web_tracking_id NUMBER := FND_API.G_MISS_NUM
72: );
65: offer_id NUMBER := FND_API.G_MISS_NUM,
66: party_id NUMBER := FND_API.G_MISS_NUM,
67: affiliate_id NUMBER := FND_API.G_MISS_NUM,
68: posting_id NUMBER := FND_API.G_MISS_NUM,
69: did NUMBER := FND_API.G_MISS_NUM,
70: flavour VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: web_tracking_id NUMBER := FND_API.G_MISS_NUM
72: );
73:
66: party_id NUMBER := FND_API.G_MISS_NUM,
67: affiliate_id NUMBER := FND_API.G_MISS_NUM,
68: posting_id NUMBER := FND_API.G_MISS_NUM,
69: did NUMBER := FND_API.G_MISS_NUM,
70: flavour VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: web_tracking_id NUMBER := FND_API.G_MISS_NUM
72: );
73:
74: g_miss_ps_strats_rec interaction_track_rec_type;
67: affiliate_id NUMBER := FND_API.G_MISS_NUM,
68: posting_id NUMBER := FND_API.G_MISS_NUM,
69: did NUMBER := FND_API.G_MISS_NUM,
70: flavour VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: web_tracking_id NUMBER := FND_API.G_MISS_NUM
72: );
73:
74: g_miss_ps_strats_rec interaction_track_rec_type;
75:
85: -- Parameters
86: --
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_track_rec IN interaction_track_rec_type Required
93: -- OUT
86: --
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_track_rec IN interaction_track_rec_type Required
93: -- OUT
94: -- x_return_status OUT VARCHAR2
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_track_rec IN interaction_track_rec_type Required
93: -- OUT
94: -- x_return_status OUT VARCHAR2
95: -- x_msg_count OUT NUMBER
104: --
105:
106: PROCEDURE Log_interaction(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
105:
106: PROCEDURE Log_interaction(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
106: PROCEDURE Log_interaction(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,