163: p_org_id_string in varchar2,
164: p_mode in varchar2,
165: p_apply_rcm in varchar2,
166: p_synchronize in varchar2,
167: p_update_count in varchar2 := FND_API.G_TRUE,
168: p_commit in varchar2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: x_return_status out nocopy varchar2,
164: p_mode in varchar2,
165: p_apply_rcm in varchar2,
166: p_synchronize in varchar2,
167: p_update_count in varchar2 := FND_API.G_TRUE,
168: p_commit in varchar2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: x_return_status out nocopy varchar2,
172: x_msg_count out nocopy number,
165: p_apply_rcm in varchar2,
166: p_synchronize in varchar2,
167: p_update_count in varchar2 := FND_API.G_TRUE,
168: p_commit in varchar2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: x_return_status out nocopy varchar2,
172: x_msg_count out nocopy number,
173: x_msg_data out nocopy varchar2 );
166: p_synchronize in varchar2,
167: p_update_count in varchar2 := FND_API.G_TRUE,
168: p_commit in varchar2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: x_return_status out nocopy varchar2,
172: x_msg_count out nocopy number,
173: x_msg_data out nocopy varchar2 );
174:
178: p_org_id in number,
179: p_mode in varchar2,
180: p_apply_rcm in varchar2,
181: p_synchronize in varchar2,
182: p_update_count in varchar2 := FND_API.G_TRUE,
183: p_commit in varchar2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: x_return_status out nocopy varchar2,
179: p_mode in varchar2,
180: p_apply_rcm in varchar2,
181: p_synchronize in varchar2,
182: p_update_count in varchar2 := FND_API.G_TRUE,
183: p_commit in varchar2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: x_return_status out nocopy varchar2,
187: x_msg_count out nocopy number,
180: p_apply_rcm in varchar2,
181: p_synchronize in varchar2,
182: p_update_count in varchar2 := FND_API.G_TRUE,
183: p_commit in varchar2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: x_return_status out nocopy varchar2,
187: x_msg_count out nocopy number,
188: x_msg_data out nocopy varchar2 );
181: p_synchronize in varchar2,
182: p_update_count in varchar2 := FND_API.G_TRUE,
183: p_commit in varchar2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: x_return_status out nocopy varchar2,
187: x_msg_count out nocopy number,
188: x_msg_data out nocopy varchar2 );
189:
342: P_parent_id IN NUMBER,
343: P_add_from IN VARCHAR2,
344: p_revise_existing IN VARCHAR2,
345: P_apply_rcm IN VARCHAR2,
346: p_commit IN VARCHAR2 := FND_API.G_FALSE,
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY VARCHAR2,
343: P_add_from IN VARCHAR2,
344: p_revise_existing IN VARCHAR2,
345: P_apply_rcm IN VARCHAR2,
346: p_commit IN VARCHAR2 := FND_API.G_FALSE,
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY VARCHAR2,
351: x_msg_data OUT NOCOPY VARCHAR2);
344: p_revise_existing IN VARCHAR2,
345: P_apply_rcm IN VARCHAR2,
346: p_commit IN VARCHAR2 := FND_API.G_FALSE,
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY VARCHAR2,
351: x_msg_data OUT NOCOPY VARCHAR2);
352:
355: PROCEDURE delete_organization_child
356: ( p_organization_id IN NUMBER,
357: p_child_id IN NUMBER,
358: P_parent_id IN NUMBER,
359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: x_return_status OUT NOCOPY VARCHAR2,
363: x_msg_count OUT NOCOPY VARCHAR2,
356: ( p_organization_id IN NUMBER,
357: p_child_id IN NUMBER,
358: P_parent_id IN NUMBER,
359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: x_return_status OUT NOCOPY VARCHAR2,
363: x_msg_count OUT NOCOPY VARCHAR2,
364: x_msg_data OUT NOCOPY VARCHAR2);
357: p_child_id IN NUMBER,
358: P_parent_id IN NUMBER,
359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: x_return_status OUT NOCOPY VARCHAR2,
363: x_msg_count OUT NOCOPY VARCHAR2,
364: x_msg_data OUT NOCOPY VARCHAR2);
365:
366: /*kosriniv..... Procedure to disassociate a process in the organization */
367: PROCEDURE disassociate_org_process
368: ( p_organization_id IN NUMBER,
369: P_process_id IN NUMBER,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: x_return_status OUT NOCOPY VARCHAR2,
374: x_msg_count OUT NOCOPY VARCHAR2,
367: PROCEDURE disassociate_org_process
368: ( p_organization_id IN NUMBER,
369: P_process_id IN NUMBER,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: x_return_status OUT NOCOPY VARCHAR2,
374: x_msg_count OUT NOCOPY VARCHAR2,
375: x_msg_data OUT NOCOPY VARCHAR2);
368: ( p_organization_id IN NUMBER,
369: P_process_id IN NUMBER,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: x_return_status OUT NOCOPY VARCHAR2,
374: x_msg_count OUT NOCOPY VARCHAR2,
375: x_msg_data OUT NOCOPY VARCHAR2);
376:
382: p_sync_hierarchy in varchar2,
383: p_sync_attributes in varchar2,
384: p_sync_rcm in varchar2,
385: p_sync_people in varchar2,
386: p_commit IN VARCHAR2 := FND_API.G_FALSE,
387: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: x_return_status OUT NOCOPY VARCHAR2,
390: x_msg_count OUT NOCOPY VARCHAR2,
383: p_sync_attributes in varchar2,
384: p_sync_rcm in varchar2,
385: p_sync_people in varchar2,
386: p_commit IN VARCHAR2 := FND_API.G_FALSE,
387: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: x_return_status OUT NOCOPY VARCHAR2,
390: x_msg_count OUT NOCOPY VARCHAR2,
391: x_msg_data OUT NOCOPY VARCHAR2);
384: p_sync_rcm in varchar2,
385: p_sync_people in varchar2,
386: p_commit IN VARCHAR2 := FND_API.G_FALSE,
387: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: x_return_status OUT NOCOPY VARCHAR2,
390: x_msg_count OUT NOCOPY VARCHAR2,
391: x_msg_data OUT NOCOPY VARCHAR2);
392:
393: /* kosriniv ..Procedure to Set the Approved Risk and Control counts */
394: PROCEDURE update_approved_rc_counts
395: ( p_organization_id IN NUMBER,
396: P_process_id IN NUMBER,
397: p_commit IN VARCHAR2 := FND_API.G_FALSE,
398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY VARCHAR2,
394: PROCEDURE update_approved_rc_counts
395: ( p_organization_id IN NUMBER,
396: P_process_id IN NUMBER,
397: p_commit IN VARCHAR2 := FND_API.G_FALSE,
398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY VARCHAR2,
402: x_msg_data OUT NOCOPY VARCHAR2);
395: ( p_organization_id IN NUMBER,
396: P_process_id IN NUMBER,
397: p_commit IN VARCHAR2 := FND_API.G_FALSE,
398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY VARCHAR2,
402: x_msg_data OUT NOCOPY VARCHAR2);
403:
404: /* kosriniv ..Procedure to Set the latestRisk and Control counts */
405: PROCEDURE update_latest_rc_counts
406: ( p_organization_id IN NUMBER,
407: P_process_id IN NUMBER,
408: p_commit IN VARCHAR2 := FND_API.G_FALSE,
409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: x_return_status OUT NOCOPY VARCHAR2,
412: x_msg_count OUT NOCOPY VARCHAR2,
405: PROCEDURE update_latest_rc_counts
406: ( p_organization_id IN NUMBER,
407: P_process_id IN NUMBER,
408: p_commit IN VARCHAR2 := FND_API.G_FALSE,
409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: x_return_status OUT NOCOPY VARCHAR2,
412: x_msg_count OUT NOCOPY VARCHAR2,
413: x_msg_data OUT NOCOPY VARCHAR2);
406: ( p_organization_id IN NUMBER,
407: P_process_id IN NUMBER,
408: p_commit IN VARCHAR2 := FND_API.G_FALSE,
409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: x_return_status OUT NOCOPY VARCHAR2,
412: x_msg_count OUT NOCOPY VARCHAR2,
413: x_msg_data OUT NOCOPY VARCHAR2);
414:
415: /* kosriniv insert the exceptions justification ..*/
416: PROCEDURE insert_exception_justification
417: (p_exception_Id IN Number,
418: p_justification IN Varchar2,
419: p_commit in varchar2 := FND_API.G_FALSE,
420: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422: x_return_status out nocopy varchar2,
423: x_msg_count out nocopy number,
416: PROCEDURE insert_exception_justification
417: (p_exception_Id IN Number,
418: p_justification IN Varchar2,
419: p_commit in varchar2 := FND_API.G_FALSE,
420: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422: x_return_status out nocopy varchar2,
423: x_msg_count out nocopy number,
424: x_msg_data out nocopy varchar2);
417: (p_exception_Id IN Number,
418: p_justification IN Varchar2,
419: p_commit in varchar2 := FND_API.G_FALSE,
420: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422: x_return_status out nocopy varchar2,
423: x_msg_count out nocopy number,
424: x_msg_data out nocopy varchar2);
425:
505: p_sync_hierarchy in varchar2,
506: p_sync_attributes in varchar2,
507: p_sync_rcm in varchar2,
508: p_sync_people in varchar2,
509: p_commit in varchar2 := FND_API.G_FALSE,
510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
512: x_return_status out nocopy varchar2,
513: x_msg_count out nocopy number,
506: p_sync_attributes in varchar2,
507: p_sync_rcm in varchar2,
508: p_sync_people in varchar2,
509: p_commit in varchar2 := FND_API.G_FALSE,
510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
512: x_return_status out nocopy varchar2,
513: x_msg_count out nocopy number,
514: x_msg_data out nocopy varchar2 );
507: p_sync_rcm in varchar2,
508: p_sync_people in varchar2,
509: p_commit in varchar2 := FND_API.G_FALSE,
510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
512: x_return_status out nocopy varchar2,
513: x_msg_count out nocopy number,
514: x_msg_data out nocopy varchar2 );
515:
529: ****************************************************************/
530: procedure delete_activities(p_parent_process_id in number,
531: p_organization_id in number,
532: p_child_id_string in varchar2,
533: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
534: x_return_status out nocopy varchar2,
535: x_msg_count out nocopy number,
536: x_msg_data out nocopy varchar2);
537: /********************************************************
541: ****************************************************************/
542: procedure add_org_activities(p_parent_process_id in number,
543: p_organization_id in number,
544: p_child_id_string in varchar2,
545: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
546: x_return_status out nocopy varchar2,
547: x_msg_count out nocopy number,
548: x_msg_data out nocopy varchar2);
549:
554: ****************************************************************/
555: procedure add_rl_activities(p_parent_process_id in number,
556: p_organization_id in number,
557: p_comb_string in varchar2,
558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
559: x_return_status out nocopy varchar2,
560: x_msg_count out nocopy number,
561: x_msg_data out nocopy varchar2);
562:
567: ****************************************************************/
568: PROCEDURE update_latest_denorm_counts
569: ( p_organization_id IN NUMBER,
570: P_process_id IN NUMBER,
571: p_commit IN VARCHAR2 := FND_API.G_FALSE,
572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
574: x_return_status OUT NOCOPY VARCHAR2,
575: x_msg_count OUT NOCOPY VARCHAR2,
568: PROCEDURE update_latest_denorm_counts
569: ( p_organization_id IN NUMBER,
570: P_process_id IN NUMBER,
571: p_commit IN VARCHAR2 := FND_API.G_FALSE,
572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
574: x_return_status OUT NOCOPY VARCHAR2,
575: x_msg_count OUT NOCOPY VARCHAR2,
576: x_msg_data OUT NOCOPY VARCHAR2);
569: ( p_organization_id IN NUMBER,
570: P_process_id IN NUMBER,
571: p_commit IN VARCHAR2 := FND_API.G_FALSE,
572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
574: x_return_status OUT NOCOPY VARCHAR2,
575: x_msg_count OUT NOCOPY VARCHAR2,
576: x_msg_data OUT NOCOPY VARCHAR2);
577: