APPS.PAY_JP_PROCESS_CMI_SS dependencies on HR_API

Line 2001: from hr_api_transaction_values

1997: datatype,
1998: varchar2_value,
1999: date_value,
2000: number_value
2001: from hr_api_transaction_values
2002: where transaction_step_id = p_transaction_step_id;
2003: --
2004: l_txn_value_tbl_cnt number := 0;
2005: --

Line 2072: l_value_char hr_api_transaction_values.varchar2_value%type;

2068: p_name in varchar2)
2069: return varchar2
2070: is
2071: --
2072: l_value_char hr_api_transaction_values.varchar2_value%type;
2073: l_value_date hr_api_transaction_values.date_value%type;
2074: l_value_number hr_api_transaction_values.number_value%type;
2075: --
2076: begin

Line 2073: l_value_date hr_api_transaction_values.date_value%type;

2069: return varchar2
2070: is
2071: --
2072: l_value_char hr_api_transaction_values.varchar2_value%type;
2073: l_value_date hr_api_transaction_values.date_value%type;
2074: l_value_number hr_api_transaction_values.number_value%type;
2075: --
2076: begin
2077: --

Line 2074: l_value_number hr_api_transaction_values.number_value%type;

2070: is
2071: --
2072: l_value_char hr_api_transaction_values.varchar2_value%type;
2073: l_value_date hr_api_transaction_values.date_value%type;
2074: l_value_number hr_api_transaction_values.number_value%type;
2075: --
2076: begin
2077: --
2078: get_txn_value(

Line 2095: l_value_char hr_api_transaction_values.varchar2_value%type;

2091: p_name in varchar2)
2092: return date
2093: is
2094: --
2095: l_value_char hr_api_transaction_values.varchar2_value%type;
2096: l_value_date hr_api_transaction_values.date_value%type;
2097: l_value_number hr_api_transaction_values.number_value%type;
2098: --
2099: begin

Line 2096: l_value_date hr_api_transaction_values.date_value%type;

2092: return date
2093: is
2094: --
2095: l_value_char hr_api_transaction_values.varchar2_value%type;
2096: l_value_date hr_api_transaction_values.date_value%type;
2097: l_value_number hr_api_transaction_values.number_value%type;
2098: --
2099: begin
2100: --

Line 2097: l_value_number hr_api_transaction_values.number_value%type;

2093: is
2094: --
2095: l_value_char hr_api_transaction_values.varchar2_value%type;
2096: l_value_date hr_api_transaction_values.date_value%type;
2097: l_value_number hr_api_transaction_values.number_value%type;
2098: --
2099: begin
2100: --
2101: get_txn_value(

Line 2118: l_value_char hr_api_transaction_values.varchar2_value%type;

2114: p_name in varchar2)
2115: return number
2116: is
2117: --
2118: l_value_char hr_api_transaction_values.varchar2_value%type;
2119: l_value_date hr_api_transaction_values.date_value%type;
2120: l_value_number hr_api_transaction_values.number_value%type;
2121: --
2122: begin

Line 2119: l_value_date hr_api_transaction_values.date_value%type;

2115: return number
2116: is
2117: --
2118: l_value_char hr_api_transaction_values.varchar2_value%type;
2119: l_value_date hr_api_transaction_values.date_value%type;
2120: l_value_number hr_api_transaction_values.number_value%type;
2121: --
2122: begin
2123: --

Line 2120: l_value_number hr_api_transaction_values.number_value%type;

2116: is
2117: --
2118: l_value_char hr_api_transaction_values.varchar2_value%type;
2119: l_value_date hr_api_transaction_values.date_value%type;
2120: l_value_number hr_api_transaction_values.number_value%type;
2121: --
2122: begin
2123: --
2124: get_txn_value(