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);
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;
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;
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);
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
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);
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:
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
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);
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
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
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';
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
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';
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:
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);