DBA Data[Home] [Help]

APPS.AMW_ORG_HIERARCHY_PKG dependencies on FND_API

Line 167: p_update_count in varchar2 := FND_API.G_TRUE,

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,

Line 168: p_commit in varchar2 := FND_API.G_FALSE,

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,

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

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

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

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:

Line 182: p_update_count in varchar2 := FND_API.G_TRUE,

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,

Line 183: p_commit in varchar2 := FND_API.G_FALSE,

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,

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

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

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

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:

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

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,

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

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

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

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:

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

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,

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

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

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

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:

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

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,

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

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

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

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:

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

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,

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

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

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

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:

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

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,

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

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

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

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:

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

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,

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

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

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

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:

Line 419: p_commit in varchar2 := FND_API.G_FALSE,

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,

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

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

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

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:

Line 509: p_commit in varchar2 := FND_API.G_FALSE,

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,

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

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

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

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:

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

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: /********************************************************

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

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:

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

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:

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

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,

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

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

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

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: