DBA Data[Home] [Help]

APPS.PO_RCOTOLERANCE_PVT dependencies on PO_CO_TOLERANCES_GRP

Line 410: * Effects: Calls PO_CO_TOLERANCES_GRP.get_tolerances to return

406: END changes_within_tol;
407: /**
408: * Requires: organization id
409: * Modifies: None.
410: * Effects: Calls PO_CO_TOLERANCES_GRP.get_tolerances to return
411: * tolerance values for RCO REQ Aproval tolerances.
412: * Returns:
413: * a table of records that contains tolerance values
414: */

Line 418: RETURN po_co_tolerances_grp.tolerances_tbl_type

414: */
415:
416: FUNCTION populate_internal_tolerances
417: (p_organization_id IN NUMBER)
418: RETURN po_co_tolerances_grp.tolerances_tbl_type
419: IS
420: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
421: l_return_status VARCHAR2(1);
422: l_msg_count NUMBER;

Line 420: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;

416: FUNCTION populate_internal_tolerances
417: (p_organization_id IN NUMBER)
418: RETURN po_co_tolerances_grp.tolerances_tbl_type
419: IS
420: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
421: l_return_status VARCHAR2(1);
422: l_msg_count NUMBER;
423: l_msg_data VARCHAR2(100);
424: l_api_name VARCHAR2(30) := 'Populate_INTERNAL_Tolerances';

Line 434: po_co_tolerances_grp.get_tolerances(p_api_version => 1.0, p_init_msg_list => fnd_api.g_true,

430: || p_organization_id);
431: END IF;
432:
433:
434: po_co_tolerances_grp.get_tolerances(p_api_version => 1.0, p_init_msg_list => fnd_api.g_true,
435: p_organization_id => p_organization_id, p_change_order_type => po_co_tolerances_grp.g_rco_int_req_app,
436: x_tolerances_tbl => l_tolerances_tbl, x_return_status => l_return_status,
437: x_msg_count => l_msg_count, x_msg_data => l_msg_data);
438:

Line 435: p_organization_id => p_organization_id, p_change_order_type => po_co_tolerances_grp.g_rco_int_req_app,

431: END IF;
432:
433:
434: po_co_tolerances_grp.get_tolerances(p_api_version => 1.0, p_init_msg_list => fnd_api.g_true,
435: p_organization_id => p_organization_id, p_change_order_type => po_co_tolerances_grp.g_rco_int_req_app,
436: x_tolerances_tbl => l_tolerances_tbl, x_return_status => l_return_status,
437: x_msg_count => l_msg_count, x_msg_data => l_msg_data);
438:
439: IF (g_debug = 'Y'

Line 442: || l_api_name,'PO_CO_Tolerances_Grp.get_tolerances API result:'

438:
439: IF (g_debug = 'Y'
440: AND fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
441: fnd_log.string(fnd_log.level_statement, g_module_prefix
442: || l_api_name,'PO_CO_Tolerances_Grp.get_tolerances API result:'
443: || l_return_status);
444: END IF;
445:
446: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 450: || l_api_name,'PO_CO_Tolerances_Grp.get_tolerances API failed:'

446: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
447: IF (g_debug = 'Y'
448: AND fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
449: fnd_log.string(fnd_log.level_statement, g_module_prefix
450: || l_api_name,'PO_CO_Tolerances_Grp.get_tolerances API failed:'
451: || l_msg_count
452: ||' '
453: || l_msg_data);
454:

Line 463: * Effects: Calls PO_CO_TOLERANCES_GRP.get_tolerances to return

459: END populate_internal_tolerances;
460: /**
461: * Requires: organization id
462: * Modifies: None.
463: * Effects: Calls PO_CO_TOLERANCES_GRP.get_tolerances to return
464: * tolerance values for RCO REQ Aproval tolerances.
465: * Returns:
466: * a table of records that contains tolerance values
467: */

Line 471: RETURN po_co_tolerances_grp.tolerances_tbl_type

467: */
468:
469: FUNCTION populate_tolerances
470: (p_organization_id IN NUMBER)
471: RETURN po_co_tolerances_grp.tolerances_tbl_type
472: IS
473: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
474: l_return_status VARCHAR2(1);
475: l_msg_count NUMBER;

Line 473: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;

469: FUNCTION populate_tolerances
470: (p_organization_id IN NUMBER)
471: RETURN po_co_tolerances_grp.tolerances_tbl_type
472: IS
473: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
474: l_return_status VARCHAR2(1);
475: l_msg_count NUMBER;
476: l_msg_data VARCHAR2(100);
477: l_api_name VARCHAR2(30) := 'Populate_Tolerances';

Line 486: po_co_tolerances_grp.get_tolerances(p_api_version => 1.0, p_init_msg_list => fnd_api.g_true,

482: || l_api_name,'p_organization_id :'
483: || p_organization_id);
484: END IF;
485:
486: po_co_tolerances_grp.get_tolerances(p_api_version => 1.0, p_init_msg_list => fnd_api.g_true,
487: p_organization_id => p_organization_id, p_change_order_type => po_co_tolerances_grp.g_rco_req_app,
488: x_tolerances_tbl => l_tolerances_tbl, x_return_status => l_return_status,
489: x_msg_count => l_msg_count, x_msg_data => l_msg_data);
490:

Line 487: p_organization_id => p_organization_id, p_change_order_type => po_co_tolerances_grp.g_rco_req_app,

483: || p_organization_id);
484: END IF;
485:
486: po_co_tolerances_grp.get_tolerances(p_api_version => 1.0, p_init_msg_list => fnd_api.g_true,
487: p_organization_id => p_organization_id, p_change_order_type => po_co_tolerances_grp.g_rco_req_app,
488: x_tolerances_tbl => l_tolerances_tbl, x_return_status => l_return_status,
489: x_msg_count => l_msg_count, x_msg_data => l_msg_data);
490:
491: IF (g_debug = 'Y'

Line 494: || l_api_name,'PO_CO_Tolerances_Grp.get_tolerances API result:'

490:
491: IF (g_debug = 'Y'
492: AND fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
493: fnd_log.string(fnd_log.level_statement, g_module_prefix
494: || l_api_name,'PO_CO_Tolerances_Grp.get_tolerances API result:'
495: || l_return_status);
496: END IF;
497:
498: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 502: || l_api_name,'PO_CO_Tolerances_Grp.get_tolerances API failed:'

498: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
499: IF (g_debug = 'Y'
500: AND fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
501: fnd_log.string(fnd_log.level_statement, g_module_prefix
502: || l_api_name,'PO_CO_Tolerances_Grp.get_tolerances API failed:'
503: || l_msg_count
504: ||' '
505: || l_msg_data);
506: END IF;

Line 515: * Effects: Calls PO_CO_TOLERANCES_GRP.get_tolerances to return

511: /**
512: * Requires: requisition change request group id
513: * organization id
514: * Modifies: None.
515: * Effects: Calls PO_CO_TOLERANCES_GRP.get_tolerances to return
516: * tolerance values for RCO REQ Aproval tolerances.
517: * Returns:
518: * a table of records that contains tolerance values
519: */

Line 530: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;

526: RETURN VARCHAR2
527: IS
528: l_return_val VARCHAR2(1) := 'Y';
529: -- PLSQL table of tolerance values
530: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
531: l_api_name VARCHAR2(30) := 'Changes_Within_ReqAppr_Tol_Val';
532: l_progress VARCHAR2(100) := '000';
533: BEGIN
534: l_progress := '001';