DBA Data[Home] [Help]

APPS.OKL_AM_QUOTES_WF dependencies on WF_USERS

Line 394: l_user WF_USERS.NAME%TYPE;

390:
391: l_trx_id NUMBER;
392: l_pre_proceeds_rec okl_pop_pre_proceeds_csr%ROWTYPE;
393: l_no_data_found BOOLEAN;
394: l_user WF_USERS.NAME%TYPE;
395: l_message VARCHAR2(30000);
396: l_header_done BOOLEAN := FALSE;
397: l_updated_by NUMBER;
398: l_comments VARCHAR2(30000);

Line 4085: l_user_name WF_USERS.name%type;

4081:
4082: l_quote_rec get_quote_csr%rowtype;
4083: l_quote_id varchar2(100);
4084:
4085: l_user_name WF_USERS.name%type;
4086: l_name WF_USERS.description%type;
4087:
4088: l_recipient_name varchar2(100);
4089: l_recipient_id number;

Line 4086: l_name WF_USERS.description%type;

4082: l_quote_rec get_quote_csr%rowtype;
4083: l_quote_id varchar2(100);
4084:
4085: l_user_name WF_USERS.name%type;
4086: l_name WF_USERS.description%type;
4087:
4088: l_recipient_name varchar2(100);
4089: l_recipient_id number;
4090: l_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;

Line 4334: l_user WF_USERS.NAME%TYPE;

4330: resultout OUT NOCOPY VARCHAR2 ) AS
4331:
4332: l_id NUMBER;
4333: l_no_data_found BOOLEAN;
4334: l_user WF_USERS.NAME%TYPE;
4335:
4336: l_message VARCHAR2(30000);
4337: l_comments VARCHAR2(1000);
4338: l_sent_date VARCHAR2(50);

Line 4676: l_user WF_USERS.NAME%TYPE;

4672: resultout OUT NOCOPY VARCHAR2 ) AS
4673:
4674: l_id NUMBER;
4675: l_no_data_found BOOLEAN;
4676: l_user WF_USERS.NAME%TYPE;
4677:
4678: l_message VARCHAR2(30000);
4679:
4680: -- cursor to populate notification attributes

Line 4833: l_user_name WF_USERS.name%type;

4829:
4830: l_last_updated_by NUMBER;
4831: l_quote_id VARCHAR2(200);
4832:
4833: l_user_name WF_USERS.name%type;
4834: l_name WF_USERS.description%type;
4835: l_current_party NUMBER;
4836:
4837: l_quote_number VARCHAR2(100);

Line 4834: l_name WF_USERS.description%type;

4830: l_last_updated_by NUMBER;
4831: l_quote_id VARCHAR2(200);
4832:
4833: l_user_name WF_USERS.name%type;
4834: l_name WF_USERS.description%type;
4835: l_current_party NUMBER;
4836:
4837: l_quote_number VARCHAR2(100);
4838:

Line 5178: l_user WF_USERS.NAME%TYPE;

5174: resultout OUT NOCOPY VARCHAR2 ) AS
5175:
5176: l_id NUMBER;
5177: l_no_data_found BOOLEAN;
5178: l_user WF_USERS.NAME%TYPE;
5179:
5180: l_message VARCHAR2(30000);
5181:
5182: -- cursor to populate notification attributes

Line 5475: l_user_name WF_USERS.name%type;

5471: l_tolerance_basis VARCHAR2(30);
5472: l_approval_formula VARCHAR2(150);
5473:
5474:
5475: l_user_name WF_USERS.name%type;
5476: l_name WF_USERS.description%type;
5477: l_header_done BOOLEAN := FALSE;
5478: l_pos NUMBER;
5479: l_stop_type VARCHAR2(15);

Line 5476: l_name WF_USERS.description%type;

5472: l_approval_formula VARCHAR2(150);
5473:
5474:
5475: l_user_name WF_USERS.name%type;
5476: l_name WF_USERS.description%type;
5477: l_header_done BOOLEAN := FALSE;
5478: l_pos NUMBER;
5479: l_stop_type VARCHAR2(15);
5480: -- for debug logging

Line 7031: l_user_name WF_USERS.name%type;

7027: and trx.khr_id = khr.id;
7028:
7029: r_qte_details get_quote_csr%rowtype;
7030:
7031: l_user_name WF_USERS.name%type;
7032: l_name WF_USERS.description%type;
7033:
7034: l_quote_id NUMBER;
7035: -- for debug logging

Line 7032: l_name WF_USERS.description%type;

7028:
7029: r_qte_details get_quote_csr%rowtype;
7030:
7031: l_user_name WF_USERS.name%type;
7032: l_name WF_USERS.description%type;
7033:
7034: l_quote_id NUMBER;
7035: -- for debug logging
7036: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'validate_manual_quote_req';

Line 7177: l_user_name WF_USERS.name%type;

7173:
7174: l_last_updated_by NUMBER;
7175: l_quote_id VARCHAR2(200);
7176:
7177: l_user_name WF_USERS.name%type;
7178: l_name WF_USERS.description%type;
7179:
7180: l_quote_number VARCHAR2(100);
7181: -- for debug logging

Line 7178: l_name WF_USERS.description%type;

7174: l_last_updated_by NUMBER;
7175: l_quote_id VARCHAR2(200);
7176:
7177: l_user_name WF_USERS.name%type;
7178: l_name WF_USERS.description%type;
7179:
7180: l_quote_number VARCHAR2(100);
7181: -- for debug logging
7182: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'validate_accept_rest_qte';

Line 7571: l_user_name WF_USERS.name%type;

7567: and txl.kle_id = kle.id;
7568:
7569: r_qte_details get_quote_csr%rowtype;
7570:
7571: l_user_name WF_USERS.name%type;
7572: l_name WF_USERS.description%type;
7573:
7574: l_quote_id NUMBER;
7575:

Line 7572: l_name WF_USERS.description%type;

7568:
7569: r_qte_details get_quote_csr%rowtype;
7570:
7571: l_user_name WF_USERS.name%type;
7572: l_name WF_USERS.description%type;
7573:
7574: l_quote_id NUMBER;
7575:
7576: l_message VARCHAR2(32000);