10:
11:
12: l_parameter_list WF_PARAMETER_LIST_T;
13: l_key WF_ITEMS.item_key%TYPE;
14: l_event_name WF_EVENTS.NAME%TYPE := 'oracle.apps.okl.vss.requestrepquote';
15: l_seq NUMBER;
16:
17: -- Cursor to get the value of the sequence
18: CURSOR okl_key_csr IS
38: -- *******
39: -- Set the parameter list
40: -- *******
41:
42: WF_EVENT.AddParameterToList('SSCKHRID',
43: p_khr_id,
44: l_parameter_list);
45:
46: WF_EVENT.AddParameterToList('SSCKLEID',
42: WF_EVENT.AddParameterToList('SSCKHRID',
43: p_khr_id,
44: l_parameter_list);
45:
46: WF_EVENT.AddParameterToList('SSCKLEID',
47: p_kle_id,
48: l_parameter_list);
49: WF_EVENT.AddParameterToList('SSCQTEID',
50: p_qte_id,
45:
46: WF_EVENT.AddParameterToList('SSCKLEID',
47: p_kle_id,
48: l_parameter_list);
49: WF_EVENT.AddParameterToList('SSCQTEID',
50: p_qte_id,
51: l_parameter_list);
52: WF_EVENT.AddParameterToList('REQUESTOR_ID',
53: p_requestor_id,
48: l_parameter_list);
49: WF_EVENT.AddParameterToList('SSCQTEID',
50: p_qte_id,
51: l_parameter_list);
52: WF_EVENT.AddParameterToList('REQUESTOR_ID',
53: p_requestor_id,
54: l_parameter_list);
55:
56:
54: l_parameter_list);
55:
56:
57: -- Raise Business Event
58: WF_EVENT.raise(
59: p_event_name => l_event_name,
60: p_event_key => l_key,
61: p_parameters => l_parameter_list);
62: