12: X_release_numa NUMBER;
13:
14: BEGIN
15:
16: dbms_output.put_line('before call');
17:
18: po_releases_sv4.get_release_num(X_po_header_id, X_release_numa);
19:
20: dbms_output.put_line('after call');
16: dbms_output.put_line('before call');
17:
18: po_releases_sv4.get_release_num(X_po_header_id, X_release_numa);
19:
20: dbms_output.put_line('after call');
21: dbms_output.put_line(X_release_numa);
22:
23: END test_get_release_num;
24:
17:
18: po_releases_sv4.get_release_num(X_po_header_id, X_release_numa);
19:
20: dbms_output.put_line('after call');
21: dbms_output.put_line(X_release_numa);
22:
23: END test_get_release_num;
24:
25:
33: X_rowid IN VARCHAR2) IS
34:
35: BEGIN
36:
37: dbms_output.put_line('before call');
38:
39: IF po_releases_sv4.val_doc_num_unique(X_po_header_id,
40: X_release_num,
41: X_rowid) THEN
38:
39: IF po_releases_sv4.val_doc_num_unique(X_po_header_id,
40: X_release_num,
41: X_rowid) THEN
42: dbms_output.put_line('returned TRUE');
43: ELSE
44: dbms_output.put_line('returned FALSE');
45:
46: END IF;
40: X_release_num,
41: X_rowid) THEN
42: dbms_output.put_line('returned TRUE');
43: ELSE
44: dbms_output.put_line('returned FALSE');
45:
46: END IF;
47:
48: END test_val_doc_num_unique;
63:
64:
65: BEGIN
66:
67: dbms_output.put_line('before call');
68:
69: IF po_releases_sv4.val_approval_status(
70: X_po_release_id,
71: X_release_num,
74: X_acceptance_required_flag,
75: X_acceptance_due_date,
76: NULL) --
77: THEN
78: dbms_output.put_line('TRUE');
79: ELSE
80: dbms_output.put_line('FALSE');
81: END IF;
82:
76: NULL) --
77: THEN
78: dbms_output.put_line('TRUE');
79: ELSE
80: dbms_output.put_line('FALSE');
81: END IF;
82:
83: END test_val_approval_status;
84: