500: SigningLimit SigningLimitRecTyp;
501: SigningCurrencyCodes SigningLimitCurTyp; -- Cursor Variable
502:
503: l_doc_cost_center signingLimits_costCenter;
504: l_alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%type;
505: l_uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%type;
506: l_numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%type;
507: l_max_size fnd_flex_value_sets.maximum_size%type;
508:
501: SigningCurrencyCodes SigningLimitCurTyp; -- Cursor Variable
502:
503: l_doc_cost_center signingLimits_costCenter;
504: l_alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%type;
505: l_uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%type;
506: l_numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%type;
507: l_max_size fnd_flex_value_sets.maximum_size%type;
508:
509: BEGIN
502:
503: l_doc_cost_center signingLimits_costCenter;
504: l_alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%type;
505: l_uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%type;
506: l_numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%type;
507: l_max_size fnd_flex_value_sets.maximum_size%type;
508:
509: BEGIN
510:
503: l_doc_cost_center signingLimits_costCenter;
504: l_alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%type;
505: l_uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%type;
506: l_numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%type;
507: l_max_size fnd_flex_value_sets.maximum_size%type;
508:
509: BEGIN
510:
511: AP_WEB_ACCTG_PKG.GetCostCenterApprovalRule(
613: Is_Cost_Center_UpperCase_flag OUT NOCOPY VARCHAR2
614: ) IS
615: -------------------------------------------------------------------
616:
617: l_alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%type;
618: l_uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%type;
619: l_numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%type;
620: l_max_size fnd_flex_value_sets.maximum_size%type;
621: l_doc_cost_center VARCHAR2(2000);
614: ) IS
615: -------------------------------------------------------------------
616:
617: l_alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%type;
618: l_uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%type;
619: l_numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%type;
620: l_max_size fnd_flex_value_sets.maximum_size%type;
621: l_doc_cost_center VARCHAR2(2000);
622:
615: -------------------------------------------------------------------
616:
617: l_alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%type;
618: l_uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%type;
619: l_numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%type;
620: l_max_size fnd_flex_value_sets.maximum_size%type;
621: l_doc_cost_center VARCHAR2(2000);
622:
623: BEGIN
616:
617: l_alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%type;
618: l_uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%type;
619: l_numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%type;
620: l_max_size fnd_flex_value_sets.maximum_size%type;
621: l_doc_cost_center VARCHAR2(2000);
622:
623: BEGIN
624:
655:
656: /*Bug 2690715 : variable declarations */
657:
658:
659: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
660:
661: l_emp_set_of_books_id AP_WEB_DB_AP_INT_PKG.glsob_setOfBooksID;
662: l_ou_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
663: l_emp_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;