APPS.GMA_STANDARD dependencies on GMA_STANDARD

Line 1: PACKAGE BODY gma_standard AS

1: PACKAGE BODY gma_standard AS
2: /* $Header: GMASTNDB.pls 120.2 2005/12/15 11:10:25 txdaniel noship $ */
3:
4: counter pls_integer;
5: v_eventQuery EDR_STANDARD.eventQuery;

Line 44: FUNCTION PSIG_QUERY(p_eventQuery GMA_STANDARD.eventQuery) return number IS PRAGMA AUTONOMOUS_TRANSACTION;

40: BEGIN
41: edr_standard.erec_required(p_event, p_event_key, p_status);
42: END EREC_REQUIRED;
43:
44: FUNCTION PSIG_QUERY(p_eventQuery GMA_STANDARD.eventQuery) return number IS PRAGMA AUTONOMOUS_TRANSACTION;
45: i number;
46: begin
47: v_eventQuery.DELETE; -- Added for bug 4874228
48: for counter IN 1..p_eventQuery.COUNT loop

Line 60: ameruleinputvalues OUT NOCOPY GMA_STANDARD.ameruleinputvalues) is

56:
57: PROCEDURE GET_AMERULE_INPUT_VALUES( ameapplication IN varchar2,
58: ameruleid IN NUMBER,
59: amerulename IN VARCHAR2,
60: ameruleinputvalues OUT NOCOPY GMA_STANDARD.ameruleinputvalues) is
61: BEGIN
62: for counter IN 1..ameruleinputvalues.COUNT loop
63: v_ameRuleinputvalues(counter).input_name := ameruleinputvalues(counter).input_name;
64: v_ameRuleinputvalues(counter).input_value := ameruleinputvalues(counter).input_value;

Line 713: -- l_query_id := GMA_STANDARD.build_eres_query('GR_ITEM_GENERAL',l_item_code,NULL,NULL,NULL,

709: -- x_error_message OUT VARCHAR2 - If there is an error, send back the approriate message
710: -- x_return_status OUT VARCHAR2 - 'S'uccess, 'E'rror, 'U'nexpected Error
711: --
712: -- SYNOPSIS:
713: -- l_query_id := GMA_STANDARD.build_eres_query('GR_ITEM_GENERAL',l_item_code,NULL,NULL,NULL,
714: -- NULL,NULL,l_err_message,l_return_status);
715: -- IF (l_query_id > 0 ) THEN
716: -- GMA_WF_SIGNi.show_trans_query(p_query_id => l_query_id);
717: -- END IF;

Line 721: -- R. Tardio 25-Nov-2003 Added to GMA_STANDARD.

717: -- END IF;
718: --
719: -- HISTORY
720: -- M. Grosser 18-Nov-2003 Created
721: -- R. Tardio 25-Nov-2003 Added to GMA_STANDARD.
722: --=========================================================================== */
723: FUNCTION build_eres_query (p_entity_name IN VARCHAR2,
724: p_pk1_value IN VARCHAR2,
725: p_pk2_value IN VARCHAR2,

Line 740: x_event_group GMA_STANDARD.eventQuery;

736: l_oracle_error NUMBER;
737: l_query_id NUMBER;
738: l_event_key VARCHAR2(240);
739: i NUMBER :=1;
740: x_event_group GMA_STANDARD.eventQuery;
741:
742: /* ------------------ CURSORS ---------------------- */
743: CURSOR c_get_event_key IS
744: SELECT file_id

Line 772: l_query_id := GMA_STANDARD.PSIG_QUERY(x_event_group);

768: FETCH c_get_event_key INTO l_event_key;
769: END LOOP;
770:
771: -- Retrieve query id
772: l_query_id := GMA_STANDARD.PSIG_QUERY(x_event_group);
773: END IF;
774: CLOSE c_get_event_key;
775:
776: RETURN(l_query_id);

Line 815: end GMA_STANDARD;

811: );
812:
813: END GET_ERECORD_ID;
814:
815: end GMA_STANDARD;