APPS.GMO_MBR_UTIL dependencies on FND_TABLE_OF_VARCHAR2_255

Line 5: L_ame_rule_ids FND_TABLE_OF_VARCHAR2_255;

1: PACKAGE BODY GMO_MBR_UTIL AS
2: /* $Header: GMOMBRUB.pls 120.12 2006/10/06 11:20:19 rvsingh noship $ */
3:
4: FUNCTION GET_TEMPLATE_CODE(P_EVENT_NAME VARCHAR2,P_EVENT_KEY VARCHAR2) RETURN VARCHAR2 IS
5: L_ame_rule_ids FND_TABLE_OF_VARCHAR2_255;
6: L_ame_rule_descriptions FND_TABLE_OF_VARCHAR2_255;
7: L_variable_names FND_TABLE_OF_VARCHAR2_255;
8: L_variable_values FND_TABLE_OF_VARCHAR2_255;
9: BEGIN

Line 6: L_ame_rule_descriptions FND_TABLE_OF_VARCHAR2_255;

2: /* $Header: GMOMBRUB.pls 120.12 2006/10/06 11:20:19 rvsingh noship $ */
3:
4: FUNCTION GET_TEMPLATE_CODE(P_EVENT_NAME VARCHAR2,P_EVENT_KEY VARCHAR2) RETURN VARCHAR2 IS
5: L_ame_rule_ids FND_TABLE_OF_VARCHAR2_255;
6: L_ame_rule_descriptions FND_TABLE_OF_VARCHAR2_255;
7: L_variable_names FND_TABLE_OF_VARCHAR2_255;
8: L_variable_values FND_TABLE_OF_VARCHAR2_255;
9: BEGIN
10: edr_utilities.get_rules_and_variables(P_EVENT_NAME => P_EVENT_NAME

Line 7: L_variable_names FND_TABLE_OF_VARCHAR2_255;

3:
4: FUNCTION GET_TEMPLATE_CODE(P_EVENT_NAME VARCHAR2,P_EVENT_KEY VARCHAR2) RETURN VARCHAR2 IS
5: L_ame_rule_ids FND_TABLE_OF_VARCHAR2_255;
6: L_ame_rule_descriptions FND_TABLE_OF_VARCHAR2_255;
7: L_variable_names FND_TABLE_OF_VARCHAR2_255;
8: L_variable_values FND_TABLE_OF_VARCHAR2_255;
9: BEGIN
10: edr_utilities.get_rules_and_variables(P_EVENT_NAME => P_EVENT_NAME
11: ,P_EVENT_KEY =>P_EVENT_KEY

Line 8: L_variable_values FND_TABLE_OF_VARCHAR2_255;

4: FUNCTION GET_TEMPLATE_CODE(P_EVENT_NAME VARCHAR2,P_EVENT_KEY VARCHAR2) RETURN VARCHAR2 IS
5: L_ame_rule_ids FND_TABLE_OF_VARCHAR2_255;
6: L_ame_rule_descriptions FND_TABLE_OF_VARCHAR2_255;
7: L_variable_names FND_TABLE_OF_VARCHAR2_255;
8: L_variable_values FND_TABLE_OF_VARCHAR2_255;
9: BEGIN
10: edr_utilities.get_rules_and_variables(P_EVENT_NAME => P_EVENT_NAME
11: ,P_EVENT_KEY =>P_EVENT_KEY
12: ,X_AME_RULE_IDS => l_ame_rule_ids

Line 83: L_event_names FND_TABLE_OF_VARCHAR2_255;

79: **
80: ************************************************************************/
81:
82: FUNCTION GET_QUERY_ID(P_EVENT_NAME VARCHAR2,P_EVENT_KEY VARCHAR2) RETURN NUMBER IS
83: L_event_names FND_TABLE_OF_VARCHAR2_255;
84: L_event_keys FND_TABLE_OF_VARCHAR2_255;
85: L_QUERY_ID NUMBER;
86: BEGIN
87: --Initialize the the event names array containing only one element.

Line 84: L_event_keys FND_TABLE_OF_VARCHAR2_255;

80: ************************************************************************/
81:
82: FUNCTION GET_QUERY_ID(P_EVENT_NAME VARCHAR2,P_EVENT_KEY VARCHAR2) RETURN NUMBER IS
83: L_event_names FND_TABLE_OF_VARCHAR2_255;
84: L_event_keys FND_TABLE_OF_VARCHAR2_255;
85: L_QUERY_ID NUMBER;
86: BEGIN
87: --Initialize the the event names array containing only one element.
88: L_event_names := FND_TABLE_OF_VARCHAR2_255();

Line 88: L_event_names := FND_TABLE_OF_VARCHAR2_255();

84: L_event_keys FND_TABLE_OF_VARCHAR2_255;
85: L_QUERY_ID NUMBER;
86: BEGIN
87: --Initialize the the event names array containing only one element.
88: L_event_names := FND_TABLE_OF_VARCHAR2_255();
89: L_event_names.EXTEND;
90: --Initialize the the event key array containing only one element.
91: L_event_keys := FND_TABLE_OF_VARCHAR2_255();
92: L_event_keys.EXTEND;

Line 91: L_event_keys := FND_TABLE_OF_VARCHAR2_255();

87: --Initialize the the event names array containing only one element.
88: L_event_names := FND_TABLE_OF_VARCHAR2_255();
89: L_event_names.EXTEND;
90: --Initialize the the event key array containing only one element.
91: L_event_keys := FND_TABLE_OF_VARCHAR2_255();
92: L_event_keys.EXTEND;
93: L_event_names(1) := P_EVENT_NAME;
94: L_event_keys(1) := P_EVENT_KEY;
95: edr_standard.PSIG_QUERY_ONE ( p_event_name => L_event_names ,