1144: p_approved_flag IN OUT NOCOPY varchar2,
1145: p_return_status IN OUT NOCOPY varchar2
1146: ) IS
1147:
1148: l_user_id ar_approval_user_limits.user_id%type;
1149: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1150: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1151:
1152: BEGIN
1145: p_return_status IN OUT NOCOPY varchar2
1146: ) IS
1147:
1148: l_user_id ar_approval_user_limits.user_id%type;
1149: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1150: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1151:
1152: BEGIN
1153:
1146: ) IS
1147:
1148: l_user_id ar_approval_user_limits.user_id%type;
1149: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1150: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1151:
1152: BEGIN
1153:
1154: IF PG_DEBUG in ('Y', 'C') THEN
1173: SELECT amount_to,
1174: amount_from
1175: INTO l_approval_amount_to,
1176: l_approval_amount_from
1177: FROM ar_approval_user_limits
1178: WHERE user_id = l_user_id
1179: AND currency_code = p_inv_curr_code;
1180:
1181: EXCEPTION
1695: ) IS
1696:
1697: l_index number;
1698: l_user_id BINARY_INTEGER;
1699: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1700: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1701: l_approved_flag VARCHAR2(1);
1702: l_return_status VARCHAR2(1);
1703: l_currency_code VARCHAR2(10);
1696:
1697: l_index number;
1698: l_user_id BINARY_INTEGER;
1699: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1700: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1701: l_approved_flag VARCHAR2(1);
1702: l_return_status VARCHAR2(1);
1703: l_currency_code VARCHAR2(10);
1704: l_amount Number;