DBA Data[Home] [Help]

APPS.PO_RCOTOLERANCE_PVT dependencies on PO_CO_TOLERANCES_GRP

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

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

Line 415: RETURN po_co_tolerances_grp.tolerances_tbl_type

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

Line 417: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;

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

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

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

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

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

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

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

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

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

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

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

Line 468: RETURN po_co_tolerances_grp.tolerances_tbl_type

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

Line 470: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;

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

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

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

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

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

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

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

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

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

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

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

Line 527: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;

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