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 4835: l_user_name WF_USERS.name%type;

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

Line 4836: l_name WF_USERS.description%type;

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

Line 5180: l_user WF_USERS.NAME%TYPE;

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

Line 5477: l_user_name WF_USERS.name%type;

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

Line 5478: l_name WF_USERS.description%type;

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

Line 7033: l_user_name WF_USERS.name%type;

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

Line 7034: l_name WF_USERS.description%type;

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

Line 7179: l_user_name WF_USERS.name%type;

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

Line 7180: l_name WF_USERS.description%type;

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

Line 7573: l_user_name WF_USERS.name%type;

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

Line 7574: l_name WF_USERS.description%type;

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