1 PACKAGE fnd_flex_workflow AUTHID CURRENT_USER AS
2 /* $Header: AFFFWKFS.pls 120.1.12010000.1 2008/07/25 14:15:08 appldev ship $ */
3
4
5 TYPE key_flex_type IS RECORD
6 (application_id fnd_application.application_id%TYPE,
7 application_short_name fnd_application.application_short_name%TYPE,
8 id_flex_code fnd_id_flexs.id_flex_code%TYPE,
9 id_flex_num fnd_id_flex_structures.id_flex_num%TYPE,
10 numof_segments NUMBER);
11
12 PROCEDURE get_key_flex(p_item_type IN VARCHAR2,
13 p_item_key IN VARCHAR2,
14 px_key_flex IN OUT nocopy key_flex_type);
15
16 FUNCTION select_process(appl_short_name IN VARCHAR2,
17 code IN VARCHAR2,
18 num IN NUMBER,
19 itemtype IN VARCHAR2) RETURN VARCHAR2;
20
21 FUNCTION initialize(appl_short_name IN VARCHAR2,
22 code IN VARCHAR2,
23 num IN NUMBER,
24 itemtype IN VARCHAR2) RETURN VARCHAR2;
25
26 FUNCTION generate(itemtype IN VARCHAR2,
27 itemkey IN VARCHAR2,
28 ccid IN OUT nocopy NUMBER,
29 concat_segs IN OUT nocopy VARCHAR2,
30 concat_ids IN OUT nocopy VARCHAR2,
31 concat_descrs IN OUT nocopy VARCHAR2,
32 error_message IN OUT nocopy VARCHAR2) RETURN BOOLEAN;
33
34 FUNCTION generate(itemtype IN VARCHAR2,
35 itemkey IN VARCHAR2,
36 insert_if_new IN BOOLEAN,
37 ccid IN OUT nocopy NUMBER,
38 concat_segs IN OUT nocopy VARCHAR2,
39 concat_ids IN OUT nocopy VARCHAR2,
40 concat_descrs IN OUT nocopy VARCHAR2,
41 error_message IN OUT nocopy VARCHAR2,
42 new_combination IN OUT nocopy BOOLEAN) RETURN BOOLEAN;
43
44 FUNCTION generate_partial(itemtype IN VARCHAR2,
45 itemkey IN VARCHAR2,
46 subprocess IN VARCHAR2,
47 block_activity IN VARCHAR2,
48 ccid IN OUT nocopy NUMBER,
49 concat_segs IN OUT nocopy VARCHAR2,
50 concat_ids IN OUT nocopy VARCHAR2,
51 concat_descrs IN OUT nocopy VARCHAR2,
52 error_message IN OUT nocopy VARCHAR2) RETURN BOOLEAN;
53
54 FUNCTION generate_partial(itemtype IN VARCHAR2,
55 itemkey IN VARCHAR2,
56 subprocess IN VARCHAR2,
57 block_activity IN VARCHAR2,
58 insert_if_new IN BOOLEAN,
59 ccid IN OUT nocopy NUMBER,
60 concat_segs IN OUT nocopy VARCHAR2,
61 concat_ids IN OUT nocopy VARCHAR2,
62 concat_descrs IN OUT nocopy VARCHAR2,
63 error_message IN OUT nocopy VARCHAR2,
64 new_combination IN OUT nocopy BOOLEAN) RETURN BOOLEAN;
65
66 PROCEDURE load_concatenated_segments(itemtype IN VARCHAR2,
67 itemkey IN VARCHAR2,
68 concat_segs IN VARCHAR2);
69
70 PROCEDURE purge(itemtype IN VARCHAR2,
71 itemkey IN VARCHAR2);
72
73 PROCEDURE debug_on;
74
75 PROCEDURE debug_off;
76
77 END fnd_flex_workflow;