22: -- End of Comments
23:
24: TYPE SEARCH_RESULT_REC_TYPE IS RECORD
25: (
26: version_number NUMBER := FND_API.G_MISS_NUM,
27: created_by NUMBER := FND_API.G_MISS_NUM,
28: creation_date DATE := FND_API.G_MISS_DATE,
29: last_updated_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_date DATE := FND_API.G_MISS_DATE,
23:
24: TYPE SEARCH_RESULT_REC_TYPE IS RECORD
25: (
26: version_number NUMBER := FND_API.G_MISS_NUM,
27: created_by NUMBER := FND_API.G_MISS_NUM,
28: creation_date DATE := FND_API.G_MISS_DATE,
29: last_updated_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_date DATE := FND_API.G_MISS_DATE,
31: last_update_login NUMBER := FND_API.G_MISS_NUM,
24: TYPE SEARCH_RESULT_REC_TYPE IS RECORD
25: (
26: version_number NUMBER := FND_API.G_MISS_NUM,
27: created_by NUMBER := FND_API.G_MISS_NUM,
28: creation_date DATE := FND_API.G_MISS_DATE,
29: last_updated_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_date DATE := FND_API.G_MISS_DATE,
31: last_update_login NUMBER := FND_API.G_MISS_NUM,
32: search_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: (
26: version_number NUMBER := FND_API.G_MISS_NUM,
27: created_by NUMBER := FND_API.G_MISS_NUM,
28: creation_date DATE := FND_API.G_MISS_DATE,
29: last_updated_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_date DATE := FND_API.G_MISS_DATE,
31: last_update_login NUMBER := FND_API.G_MISS_NUM,
32: search_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: primary_id NUMBER := FND_API.G_MISS_NUM,
26: version_number NUMBER := FND_API.G_MISS_NUM,
27: created_by NUMBER := FND_API.G_MISS_NUM,
28: creation_date DATE := FND_API.G_MISS_DATE,
29: last_updated_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_date DATE := FND_API.G_MISS_DATE,
31: last_update_login NUMBER := FND_API.G_MISS_NUM,
32: search_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: primary_id NUMBER := FND_API.G_MISS_NUM,
34: secondary_id NUMBER := FND_API.G_MISS_NUM
27: created_by NUMBER := FND_API.G_MISS_NUM,
28: creation_date DATE := FND_API.G_MISS_DATE,
29: last_updated_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_date DATE := FND_API.G_MISS_DATE,
31: last_update_login NUMBER := FND_API.G_MISS_NUM,
32: search_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: primary_id NUMBER := FND_API.G_MISS_NUM,
34: secondary_id NUMBER := FND_API.G_MISS_NUM
35: );
28: creation_date DATE := FND_API.G_MISS_DATE,
29: last_updated_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_date DATE := FND_API.G_MISS_DATE,
31: last_update_login NUMBER := FND_API.G_MISS_NUM,
32: search_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: primary_id NUMBER := FND_API.G_MISS_NUM,
34: secondary_id NUMBER := FND_API.G_MISS_NUM
35: );
36:
29: last_updated_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_date DATE := FND_API.G_MISS_DATE,
31: last_update_login NUMBER := FND_API.G_MISS_NUM,
32: search_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: primary_id NUMBER := FND_API.G_MISS_NUM,
34: secondary_id NUMBER := FND_API.G_MISS_NUM
35: );
36:
37: G_MISS_SEARCH_RESULT_REC SEARCH_RESULT_REC_TYPE;
30: last_update_date DATE := FND_API.G_MISS_DATE,
31: last_update_login NUMBER := FND_API.G_MISS_NUM,
32: search_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: primary_id NUMBER := FND_API.G_MISS_NUM,
34: secondary_id NUMBER := FND_API.G_MISS_NUM
35: );
36:
37: G_MISS_SEARCH_RESULT_REC SEARCH_RESULT_REC_TYPE;
38: TYPE SEARCH_RESULT_TBL_TYPE IS TABLE OF SEARCH_RESULT_REC_TYPE
60: RETURN AST_SEARCH_RESULT_PVT.SEARCH_RESULT_REC_TYPE;
61:
62: PROCEDURE CREATE_SEARCH_RESULT(
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
67: := FND_API.G_VALID_LEVEL_FULL,
68: P_Search_Result_Rec IN SEARCH_RESULT_REC_TYPE
61:
62: PROCEDURE CREATE_SEARCH_RESULT(
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
67: := FND_API.G_VALID_LEVEL_FULL,
68: P_Search_Result_Rec IN SEARCH_RESULT_REC_TYPE
69: := G_MISS_search_result_REC,
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
67: := FND_API.G_VALID_LEVEL_FULL,
68: P_Search_Result_Rec IN SEARCH_RESULT_REC_TYPE
69: := G_MISS_search_result_REC,
70: X_Return_Status OUT VARCHAR2,
71: X_Msg_Count OUT NUMBER,
73: );
74:
75: PROCEDURE GET_SEARCH_RESULT(
76: P_Api_Version_Number IN NUMBER,
77: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
78: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
79: p_validation_level IN NUMBER
80: := FND_API.G_VALID_LEVEL_FULL,
81: p_count IN NUMBER,
74:
75: PROCEDURE GET_SEARCH_RESULT(
76: P_Api_Version_Number IN NUMBER,
77: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
78: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
79: p_validation_level IN NUMBER
80: := FND_API.G_VALID_LEVEL_FULL,
81: p_count IN NUMBER,
82: x_Search_Result_Rec OUT SEARCH_RESULT_REC_TYPE,
76: P_Api_Version_Number IN NUMBER,
77: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
78: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
79: p_validation_level IN NUMBER
80: := FND_API.G_VALID_LEVEL_FULL,
81: p_count IN NUMBER,
82: x_Search_Result_Rec OUT SEARCH_RESULT_REC_TYPE,
83: X_Return_Status OUT VARCHAR2,
84: X_Msg_Count OUT NUMBER,
86: );
87:
88: PROCEDURE DELETE_SEARCH_RESULT(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER
93: := FND_API.G_VALID_LEVEL_FULL,
94: X_Return_Status OUT VARCHAR2,
87:
88: PROCEDURE DELETE_SEARCH_RESULT(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER
93: := FND_API.G_VALID_LEVEL_FULL,
94: X_Return_Status OUT VARCHAR2,
95: X_Msg_Count OUT NUMBER,
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER
93: := FND_API.G_VALID_LEVEL_FULL,
94: X_Return_Status OUT VARCHAR2,
95: X_Msg_Count OUT NUMBER,
96: X_Msg_Data OUT VARCHAR2
97: );
115: glb_collateral_id_tbl collateral_id_tbl;
116:
117: PROCEDURE add_party_id(
118: p_api_version IN NUMBER := 1.0,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: x_return_status OUT VARCHAR2,
123: x_msg_count OUT NUMBER,
116:
117: PROCEDURE add_party_id(
118: p_api_version IN NUMBER := 1.0,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: x_return_status OUT VARCHAR2,
123: x_msg_count OUT NUMBER,
124: x_msg_data OUT VARCHAR2,
117: PROCEDURE add_party_id(
118: p_api_version IN NUMBER := 1.0,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: x_return_status OUT VARCHAR2,
123: x_msg_count OUT NUMBER,
124: x_msg_data OUT VARCHAR2,
125: p_search_type IN VARCHAR2,
128: );
129:
130: PROCEDURE get_party_id(
131: p_api_version IN NUMBER := 1.0,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: x_return_status OUT VARCHAR2,
136: x_msg_count OUT NUMBER,
129:
130: PROCEDURE get_party_id(
131: p_api_version IN NUMBER := 1.0,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: x_return_status OUT VARCHAR2,
136: x_msg_count OUT NUMBER,
137: x_msg_data OUT VARCHAR2,
130: PROCEDURE get_party_id(
131: p_api_version IN NUMBER := 1.0,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: x_return_status OUT VARCHAR2,
136: x_msg_count OUT NUMBER,
137: x_msg_data OUT VARCHAR2,
138: p_search_type IN VARCHAR2,