120: ( x_request_id OUT NOCOPY NUMBER,
121: x_return_status OUT NOCOPY VARCHAR2 )
122: is
123: l_request_id NUMBER;
124: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
125: begin
126: -- bug 3359609
127: Request_Sync_Set_index(l_request_id,
128: l_return_status);
125: begin
126: -- bug 3359609
127: Request_Sync_Set_index(l_request_id,
128: l_return_status);
129: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
130: THEN
131: RAISE Sync_Set_Index_Error;
132: END IF;
133:
132: END IF;
133:
134: Request_Sync_Element_Index(l_request_id,
135: l_return_status);
136: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
137: THEN
138: RAISE Sync_Element_Index_Error;
139: END IF;
140: x_request_id := l_request_id;
142:
143: exception
144: when others then
145: x_request_id := 0;
146: x_return_status := fnd_api.G_RET_STS_ERROR;
147: end Request_Sync_KM_Indexes;
148:
149:
150: /*
163: l_request_id NUMBER;
164: l_CS_appsname VARCHAR2(2) := 'CS';
165: l_mark_idx_progname VARCHAR2(30) := 'CS_KB_MARK_IDX_ON_SEC_CHG';
166: -- l_num_pending_requests NUMBER := 0;
167: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
168: begin
169:
170: l_request_id :=
171: fnd_request.submit_request
179: argument3 => p_parameter2 );
180:
181: if( l_request_id > 0 )
182: then
183: l_return_status := fnd_api.G_RET_STS_SUCCESS;
184: else
185: l_return_status := fnd_api.G_RET_STS_ERROR;
186: end if;
187:
181: if( l_request_id > 0 )
182: then
183: l_return_status := fnd_api.G_RET_STS_SUCCESS;
184: else
185: l_return_status := fnd_api.G_RET_STS_ERROR;
186: end if;
187:
188: x_request_id := l_request_id;
189: x_return_status := l_return_status;
189: x_return_status := l_return_status;
190: exception
191: when others then
192: x_request_id := 0;
193: x_return_status := fnd_api.G_RET_STS_ERROR;
194: end Request_Mark_Idx_on_Sec_Change;
195:
196:
197: /*
751: l_sync_idx_progname VARCHAR2(100) := 'CS_KB_SYNC_SOLUTIONS_INDEX';
752: l_sync_mode VARCHAR2(1) := 'S';
753: l_pending_phase_code VARCHAR2(1) := 'P';
754: l_num_pending_requests NUMBER := 0;
755: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
756: begin
757:
758: -- Detect how many Pending, but not scheduled, KM Sync-Index
759: -- concurrent program requests there are.
785: argument1 => l_sync_mode );
786:
787: if( l_request_id > 0 )
788: then
789: l_return_status := fnd_api.G_RET_STS_SUCCESS;
790: end if;
791: else
792: -- There is already a pending request, so just return success
793: l_request_id := 0;
790: end if;
791: else
792: -- There is already a pending request, so just return success
793: l_request_id := 0;
794: l_return_status := fnd_api.G_RET_STS_SUCCESS;
795: end if;
796:
797: x_request_id := l_request_id;
798: x_return_status := l_return_status;
798: x_return_status := l_return_status;
799: EXCEPTION
800: WHEN OTHERS THEN
801: x_request_id := 0;
802: x_return_status := fnd_api.G_RET_STS_ERROR;
803: END Request_Sync_Set_Index;
804:
805:
806: /*
819: l_sync_idx_progname VARCHAR2(100) := 'CS_KB_SYNC_STATEMENTS_INDEX';
820: l_sync_mode VARCHAR2(1) := 'S';
821: l_pending_phase_code VARCHAR2(1) := 'P';
822: l_num_pending_requests NUMBER := 0;
823: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
824: BEGIN
825:
826: -- Detect how many Pending, but not scheduled, KM Sync-Index
827: -- concurrent program requests there are.
853: argument1 => l_sync_mode );
854:
855: if( l_request_id > 0 )
856: then
857: l_return_status := fnd_api.G_RET_STS_SUCCESS;
858: end if;
859: else
860: -- There is already a pending request, so just return success
861: l_request_id := 0;
858: end if;
859: else
860: -- There is already a pending request, so just return success
861: l_request_id := 0;
862: l_return_status := fnd_api.G_RET_STS_SUCCESS;
863: end if;
864:
865: x_request_id := l_request_id;
866: x_return_status := l_return_status;
866: x_return_status := l_return_status;
867: EXCEPTION
868: WHEN OTHERS THEN
869: x_request_id := 0;
870: x_return_status := fnd_api.G_RET_STS_ERROR;
871: END Request_Sync_Element_Index;
872:
873:
874: end CS_KB_SYNC_INDEX_PKG;