DBA Data[Home] [Help]

APPS.PV_MATCH_V2_PUB dependencies on FND_API

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

33: -- pklin
34:
35: Procedure Manual_match(
36: p_api_version_number IN NUMBER,
37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38: p_commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
41: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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

34:
35: Procedure Manual_match(
36: p_api_version_number IN NUMBER,
37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38: p_commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
41: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
42: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

35: Procedure Manual_match(
36: p_api_version_number IN NUMBER,
37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38: p_commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
41: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
42: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
43: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

60: );
61:
62: procedure Form_Where_Clause(
63: p_api_version_number IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
68: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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

61:
62: procedure Form_Where_Clause(
63: p_api_version_number IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
68: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
69: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

62: procedure Form_Where_Clause(
63: p_api_version_number IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
68: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
69: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
70: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

85:
86:
87: /*Procedure Auto_Match_Criteria (
88: p_api_version_number IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_lead_id IN Number,
93: p_resource_id IN Number,

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

86:
87: /*Procedure Auto_Match_Criteria (
88: p_api_version_number IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_lead_id IN Number,
93: p_resource_id IN Number,
94: x_matched_attr OUT NOCOPY JTF_NUMBER_TABLE,

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

87: /*Procedure Auto_Match_Criteria (
88: p_api_version_number IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_lead_id IN Number,
93: p_resource_id IN Number,
94: x_matched_attr OUT NOCOPY JTF_NUMBER_TABLE,
95: x_matched_attr_val OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

104:
105:
106: Procedure Get_Assigned_Partners(
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: p_lead_id IN NUMBER,
112: p_resource_id IN NUMBER,

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

105:
106: Procedure Get_Assigned_Partners(
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: p_lead_id IN NUMBER,
112: p_resource_id IN NUMBER,
113: x_assigned_partner_id OUT NOCOPY JTF_NUMBER_TABLE,

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

106: Procedure Get_Assigned_Partners(
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: p_lead_id IN NUMBER,
112: p_resource_id IN NUMBER,
113: x_assigned_partner_id OUT NOCOPY JTF_NUMBER_TABLE,
114: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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

133: X_MSG_DATA OUT NOCOPY VARCHAR2);
134:
135: Procedure Match_partner(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_sql IN VARCHAR2,
141: p_selection_criteria IN VARCHAR2,

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

134:
135: Procedure Match_partner(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_sql IN VARCHAR2,
141: p_selection_criteria IN VARCHAR2,
142: p_num_of_attrs IN NUMBER,

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

135: Procedure Match_partner(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_sql IN VARCHAR2,
141: p_selection_criteria IN VARCHAR2,
142: p_num_of_attrs IN NUMBER,
143: p_bind_var_tbl IN bind_var_tbl,

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

152:
153:
154: Procedure Get_Matched_Partner_Details(
155: p_api_version_number IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: p_lead_id IN NUMBER,
160: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000 := null,

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

153:
154: Procedure Get_Matched_Partner_Details(
155: p_api_version_number IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: p_lead_id IN NUMBER,
160: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000 := null,
161: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,

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

154: Procedure Get_Matched_Partner_Details(
155: p_api_version_number IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: p_lead_id IN NUMBER,
160: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000 := null,
161: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
162: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,