DBA Data[Home] [Help]

APPS.AST_SEARCH_RESULT_PVT dependencies on FND_API

Line 26: version_number NUMBER := FND_API.G_MISS_NUM,

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,

Line 27: created_by NUMBER := FND_API.G_MISS_NUM,

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,

Line 28: creation_date DATE := FND_API.G_MISS_DATE,

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,

Line 29: last_updated_by NUMBER := FND_API.G_MISS_NUM,

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,

Line 30: last_update_date DATE := FND_API.G_MISS_DATE,

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

Line 31: last_update_login 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: );

Line 32: search_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

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:

Line 33: primary_id NUMBER := FND_API.G_MISS_NUM,

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;

Line 34: secondary_id 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;
38: TYPE SEARCH_RESULT_TBL_TYPE IS TABLE OF SEARCH_RESULT_REC_TYPE

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

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

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

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,

Line 67: := FND_API.G_VALID_LEVEL_FULL,

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,

Line 77: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 78: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 80: := FND_API.G_VALID_LEVEL_FULL,

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,

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

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,

Line 91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 93: := FND_API.G_VALID_LEVEL_FULL,

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: );

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,