3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ptm_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM,
8: org_id NUMBER := OKL_API.G_MISS_NUM,
9: ptm_code OKL_PROCESS_TMPLTS_B.PTM_CODE%TYPE := OKL_API.G_MISS_CHAR,
10: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
11: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ptm_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM,
8: org_id NUMBER := OKL_API.G_MISS_NUM,
9: ptm_code OKL_PROCESS_TMPLTS_B.PTM_CODE%TYPE := OKL_API.G_MISS_CHAR,
10: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
11: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
12: jtf_amv_item_id NUMBER := -1,
5: ---------------------------------------------------------------------------
6: TYPE ptm_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM,
8: org_id NUMBER := OKL_API.G_MISS_NUM,
9: ptm_code OKL_PROCESS_TMPLTS_B.PTM_CODE%TYPE := OKL_API.G_MISS_CHAR,
10: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
11: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
12: jtf_amv_item_id NUMBER := -1,
13: /* END Changes */
7: id NUMBER := OKL_API.G_MISS_NUM,
8: org_id NUMBER := OKL_API.G_MISS_NUM,
9: ptm_code OKL_PROCESS_TMPLTS_B.PTM_CODE%TYPE := OKL_API.G_MISS_CHAR,
10: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
11: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
12: jtf_amv_item_id NUMBER := -1,
13: /* END Changes */
14: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
15: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
10: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
11: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
12: jtf_amv_item_id NUMBER := -1,
13: /* END Changes */
14: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
15: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
16: object_version_number NUMBER := OKL_API.G_MISS_NUM,
17: attribute_category OKL_PROCESS_TMPLTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
18: attribute1 OKL_PROCESS_TMPLTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
11: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
12: jtf_amv_item_id NUMBER := -1,
13: /* END Changes */
14: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
15: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
16: object_version_number NUMBER := OKL_API.G_MISS_NUM,
17: attribute_category OKL_PROCESS_TMPLTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
18: attribute1 OKL_PROCESS_TMPLTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
19: attribute2 OKL_PROCESS_TMPLTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
12: jtf_amv_item_id NUMBER := -1,
13: /* END Changes */
14: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
15: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
16: object_version_number NUMBER := OKL_API.G_MISS_NUM,
17: attribute_category OKL_PROCESS_TMPLTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
18: attribute1 OKL_PROCESS_TMPLTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
19: attribute2 OKL_PROCESS_TMPLTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
20: attribute3 OKL_PROCESS_TMPLTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
13: /* END Changes */
14: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
15: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
16: object_version_number NUMBER := OKL_API.G_MISS_NUM,
17: attribute_category OKL_PROCESS_TMPLTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
18: attribute1 OKL_PROCESS_TMPLTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
19: attribute2 OKL_PROCESS_TMPLTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
20: attribute3 OKL_PROCESS_TMPLTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
21: attribute4 OKL_PROCESS_TMPLTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
14: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
15: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
16: object_version_number NUMBER := OKL_API.G_MISS_NUM,
17: attribute_category OKL_PROCESS_TMPLTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
18: attribute1 OKL_PROCESS_TMPLTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
19: attribute2 OKL_PROCESS_TMPLTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
20: attribute3 OKL_PROCESS_TMPLTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
21: attribute4 OKL_PROCESS_TMPLTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
22: attribute5 OKL_PROCESS_TMPLTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
15: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
16: object_version_number NUMBER := OKL_API.G_MISS_NUM,
17: attribute_category OKL_PROCESS_TMPLTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
18: attribute1 OKL_PROCESS_TMPLTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
19: attribute2 OKL_PROCESS_TMPLTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
20: attribute3 OKL_PROCESS_TMPLTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
21: attribute4 OKL_PROCESS_TMPLTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
22: attribute5 OKL_PROCESS_TMPLTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
23: attribute6 OKL_PROCESS_TMPLTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
16: object_version_number NUMBER := OKL_API.G_MISS_NUM,
17: attribute_category OKL_PROCESS_TMPLTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
18: attribute1 OKL_PROCESS_TMPLTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
19: attribute2 OKL_PROCESS_TMPLTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
20: attribute3 OKL_PROCESS_TMPLTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
21: attribute4 OKL_PROCESS_TMPLTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
22: attribute5 OKL_PROCESS_TMPLTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
23: attribute6 OKL_PROCESS_TMPLTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
24: attribute7 OKL_PROCESS_TMPLTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
17: attribute_category OKL_PROCESS_TMPLTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
18: attribute1 OKL_PROCESS_TMPLTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
19: attribute2 OKL_PROCESS_TMPLTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
20: attribute3 OKL_PROCESS_TMPLTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
21: attribute4 OKL_PROCESS_TMPLTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
22: attribute5 OKL_PROCESS_TMPLTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
23: attribute6 OKL_PROCESS_TMPLTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
24: attribute7 OKL_PROCESS_TMPLTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
25: attribute8 OKL_PROCESS_TMPLTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
18: attribute1 OKL_PROCESS_TMPLTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
19: attribute2 OKL_PROCESS_TMPLTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
20: attribute3 OKL_PROCESS_TMPLTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
21: attribute4 OKL_PROCESS_TMPLTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
22: attribute5 OKL_PROCESS_TMPLTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
23: attribute6 OKL_PROCESS_TMPLTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
24: attribute7 OKL_PROCESS_TMPLTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
25: attribute8 OKL_PROCESS_TMPLTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
26: attribute9 OKL_PROCESS_TMPLTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
19: attribute2 OKL_PROCESS_TMPLTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
20: attribute3 OKL_PROCESS_TMPLTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
21: attribute4 OKL_PROCESS_TMPLTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
22: attribute5 OKL_PROCESS_TMPLTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
23: attribute6 OKL_PROCESS_TMPLTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
24: attribute7 OKL_PROCESS_TMPLTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
25: attribute8 OKL_PROCESS_TMPLTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
26: attribute9 OKL_PROCESS_TMPLTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
27: attribute10 OKL_PROCESS_TMPLTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
20: attribute3 OKL_PROCESS_TMPLTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
21: attribute4 OKL_PROCESS_TMPLTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
22: attribute5 OKL_PROCESS_TMPLTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
23: attribute6 OKL_PROCESS_TMPLTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
24: attribute7 OKL_PROCESS_TMPLTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
25: attribute8 OKL_PROCESS_TMPLTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
26: attribute9 OKL_PROCESS_TMPLTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
27: attribute10 OKL_PROCESS_TMPLTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
28: attribute11 OKL_PROCESS_TMPLTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
21: attribute4 OKL_PROCESS_TMPLTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
22: attribute5 OKL_PROCESS_TMPLTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
23: attribute6 OKL_PROCESS_TMPLTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
24: attribute7 OKL_PROCESS_TMPLTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
25: attribute8 OKL_PROCESS_TMPLTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
26: attribute9 OKL_PROCESS_TMPLTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
27: attribute10 OKL_PROCESS_TMPLTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
28: attribute11 OKL_PROCESS_TMPLTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
29: attribute12 OKL_PROCESS_TMPLTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
22: attribute5 OKL_PROCESS_TMPLTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
23: attribute6 OKL_PROCESS_TMPLTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
24: attribute7 OKL_PROCESS_TMPLTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
25: attribute8 OKL_PROCESS_TMPLTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
26: attribute9 OKL_PROCESS_TMPLTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
27: attribute10 OKL_PROCESS_TMPLTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
28: attribute11 OKL_PROCESS_TMPLTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
29: attribute12 OKL_PROCESS_TMPLTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
30: attribute13 OKL_PROCESS_TMPLTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
23: attribute6 OKL_PROCESS_TMPLTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
24: attribute7 OKL_PROCESS_TMPLTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
25: attribute8 OKL_PROCESS_TMPLTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
26: attribute9 OKL_PROCESS_TMPLTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
27: attribute10 OKL_PROCESS_TMPLTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
28: attribute11 OKL_PROCESS_TMPLTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
29: attribute12 OKL_PROCESS_TMPLTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
30: attribute13 OKL_PROCESS_TMPLTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
31: attribute14 OKL_PROCESS_TMPLTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
24: attribute7 OKL_PROCESS_TMPLTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
25: attribute8 OKL_PROCESS_TMPLTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
26: attribute9 OKL_PROCESS_TMPLTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
27: attribute10 OKL_PROCESS_TMPLTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
28: attribute11 OKL_PROCESS_TMPLTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
29: attribute12 OKL_PROCESS_TMPLTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
30: attribute13 OKL_PROCESS_TMPLTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
31: attribute14 OKL_PROCESS_TMPLTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
32: attribute15 OKL_PROCESS_TMPLTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
25: attribute8 OKL_PROCESS_TMPLTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
26: attribute9 OKL_PROCESS_TMPLTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
27: attribute10 OKL_PROCESS_TMPLTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
28: attribute11 OKL_PROCESS_TMPLTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
29: attribute12 OKL_PROCESS_TMPLTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
30: attribute13 OKL_PROCESS_TMPLTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
31: attribute14 OKL_PROCESS_TMPLTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
32: attribute15 OKL_PROCESS_TMPLTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
33: created_by NUMBER := OKL_API.G_MISS_NUM,
26: attribute9 OKL_PROCESS_TMPLTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
27: attribute10 OKL_PROCESS_TMPLTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
28: attribute11 OKL_PROCESS_TMPLTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
29: attribute12 OKL_PROCESS_TMPLTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
30: attribute13 OKL_PROCESS_TMPLTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
31: attribute14 OKL_PROCESS_TMPLTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
32: attribute15 OKL_PROCESS_TMPLTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
33: created_by NUMBER := OKL_API.G_MISS_NUM,
34: creation_date OKL_PROCESS_TMPLTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
27: attribute10 OKL_PROCESS_TMPLTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
28: attribute11 OKL_PROCESS_TMPLTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
29: attribute12 OKL_PROCESS_TMPLTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
30: attribute13 OKL_PROCESS_TMPLTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
31: attribute14 OKL_PROCESS_TMPLTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
32: attribute15 OKL_PROCESS_TMPLTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
33: created_by NUMBER := OKL_API.G_MISS_NUM,
34: creation_date OKL_PROCESS_TMPLTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
28: attribute11 OKL_PROCESS_TMPLTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
29: attribute12 OKL_PROCESS_TMPLTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
30: attribute13 OKL_PROCESS_TMPLTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
31: attribute14 OKL_PROCESS_TMPLTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
32: attribute15 OKL_PROCESS_TMPLTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
33: created_by NUMBER := OKL_API.G_MISS_NUM,
34: creation_date OKL_PROCESS_TMPLTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
36: last_update_date OKL_PROCESS_TMPLTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
29: attribute12 OKL_PROCESS_TMPLTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
30: attribute13 OKL_PROCESS_TMPLTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
31: attribute14 OKL_PROCESS_TMPLTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
32: attribute15 OKL_PROCESS_TMPLTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
33: created_by NUMBER := OKL_API.G_MISS_NUM,
34: creation_date OKL_PROCESS_TMPLTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
36: last_update_date OKL_PROCESS_TMPLTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
37: last_update_login NUMBER := OKL_API.G_MISS_NUM,
30: attribute13 OKL_PROCESS_TMPLTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
31: attribute14 OKL_PROCESS_TMPLTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
32: attribute15 OKL_PROCESS_TMPLTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
33: created_by NUMBER := OKL_API.G_MISS_NUM,
34: creation_date OKL_PROCESS_TMPLTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
36: last_update_date OKL_PROCESS_TMPLTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
37: last_update_login NUMBER := OKL_API.G_MISS_NUM,
38: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
31: attribute14 OKL_PROCESS_TMPLTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
32: attribute15 OKL_PROCESS_TMPLTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
33: created_by NUMBER := OKL_API.G_MISS_NUM,
34: creation_date OKL_PROCESS_TMPLTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
36: last_update_date OKL_PROCESS_TMPLTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
37: last_update_login NUMBER := OKL_API.G_MISS_NUM,
38: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
39: recipient_type_code OKL_PROCESS_TMPLTS_B.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
32: attribute15 OKL_PROCESS_TMPLTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
33: created_by NUMBER := OKL_API.G_MISS_NUM,
34: creation_date OKL_PROCESS_TMPLTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
36: last_update_date OKL_PROCESS_TMPLTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
37: last_update_login NUMBER := OKL_API.G_MISS_NUM,
38: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
39: recipient_type_code OKL_PROCESS_TMPLTS_B.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
40: xml_tmplt_code OKL_PROCESS_TMPLTS_B.XML_TMPLT_CODE%TYPE :=OKL_API.G_MISS_CHAR);
33: created_by NUMBER := OKL_API.G_MISS_NUM,
34: creation_date OKL_PROCESS_TMPLTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
36: last_update_date OKL_PROCESS_TMPLTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
37: last_update_login NUMBER := OKL_API.G_MISS_NUM,
38: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
39: recipient_type_code OKL_PROCESS_TMPLTS_B.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
40: xml_tmplt_code OKL_PROCESS_TMPLTS_B.XML_TMPLT_CODE%TYPE :=OKL_API.G_MISS_CHAR);
41: /* End Changes : R12 B */
35: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
36: last_update_date OKL_PROCESS_TMPLTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
37: last_update_login NUMBER := OKL_API.G_MISS_NUM,
38: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
39: recipient_type_code OKL_PROCESS_TMPLTS_B.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
40: xml_tmplt_code OKL_PROCESS_TMPLTS_B.XML_TMPLT_CODE%TYPE :=OKL_API.G_MISS_CHAR);
41: /* End Changes : R12 B */
42: g_miss_ptm_rec ptm_rec_type;
43:
36: last_update_date OKL_PROCESS_TMPLTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
37: last_update_login NUMBER := OKL_API.G_MISS_NUM,
38: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
39: recipient_type_code OKL_PROCESS_TMPLTS_B.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
40: xml_tmplt_code OKL_PROCESS_TMPLTS_B.XML_TMPLT_CODE%TYPE :=OKL_API.G_MISS_CHAR);
41: /* End Changes : R12 B */
42: g_miss_ptm_rec ptm_rec_type;
43:
44: TYPE ptm_tbl_type IS TABLE OF ptm_rec_type
44: TYPE ptm_tbl_type IS TABLE OF ptm_rec_type
45: INDEX BY BINARY_INTEGER;
46:
47: TYPE okl_process_tmplts_tl_rec_type IS RECORD (
48: id NUMBER := OKL_API.G_MISS_NUM,
49: language OKL_PROCESS_TMPLTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
50: source_lang OKL_PROCESS_TMPLTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
51: sfwt_flag OKL_PROCESS_TMPLTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
52: email_subject_line OKL_PROCESS_TMPLTS_TL.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
45: INDEX BY BINARY_INTEGER;
46:
47: TYPE okl_process_tmplts_tl_rec_type IS RECORD (
48: id NUMBER := OKL_API.G_MISS_NUM,
49: language OKL_PROCESS_TMPLTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
50: source_lang OKL_PROCESS_TMPLTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
51: sfwt_flag OKL_PROCESS_TMPLTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
52: email_subject_line OKL_PROCESS_TMPLTS_TL.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
53: created_by NUMBER := OKL_API.G_MISS_NUM,
46:
47: TYPE okl_process_tmplts_tl_rec_type IS RECORD (
48: id NUMBER := OKL_API.G_MISS_NUM,
49: language OKL_PROCESS_TMPLTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
50: source_lang OKL_PROCESS_TMPLTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
51: sfwt_flag OKL_PROCESS_TMPLTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
52: email_subject_line OKL_PROCESS_TMPLTS_TL.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
53: created_by NUMBER := OKL_API.G_MISS_NUM,
54: creation_date OKL_PROCESS_TMPLTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
47: TYPE okl_process_tmplts_tl_rec_type IS RECORD (
48: id NUMBER := OKL_API.G_MISS_NUM,
49: language OKL_PROCESS_TMPLTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
50: source_lang OKL_PROCESS_TMPLTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
51: sfwt_flag OKL_PROCESS_TMPLTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
52: email_subject_line OKL_PROCESS_TMPLTS_TL.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
53: created_by NUMBER := OKL_API.G_MISS_NUM,
54: creation_date OKL_PROCESS_TMPLTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
55: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
48: id NUMBER := OKL_API.G_MISS_NUM,
49: language OKL_PROCESS_TMPLTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
50: source_lang OKL_PROCESS_TMPLTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
51: sfwt_flag OKL_PROCESS_TMPLTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
52: email_subject_line OKL_PROCESS_TMPLTS_TL.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
53: created_by NUMBER := OKL_API.G_MISS_NUM,
54: creation_date OKL_PROCESS_TMPLTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
55: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
56: last_update_date OKL_PROCESS_TMPLTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
49: language OKL_PROCESS_TMPLTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
50: source_lang OKL_PROCESS_TMPLTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
51: sfwt_flag OKL_PROCESS_TMPLTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
52: email_subject_line OKL_PROCESS_TMPLTS_TL.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
53: created_by NUMBER := OKL_API.G_MISS_NUM,
54: creation_date OKL_PROCESS_TMPLTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
55: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
56: last_update_date OKL_PROCESS_TMPLTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
57: last_update_login NUMBER := OKL_API.G_MISS_NUM);
50: source_lang OKL_PROCESS_TMPLTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
51: sfwt_flag OKL_PROCESS_TMPLTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
52: email_subject_line OKL_PROCESS_TMPLTS_TL.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
53: created_by NUMBER := OKL_API.G_MISS_NUM,
54: creation_date OKL_PROCESS_TMPLTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
55: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
56: last_update_date OKL_PROCESS_TMPLTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
57: last_update_login NUMBER := OKL_API.G_MISS_NUM);
58:
51: sfwt_flag OKL_PROCESS_TMPLTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
52: email_subject_line OKL_PROCESS_TMPLTS_TL.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
53: created_by NUMBER := OKL_API.G_MISS_NUM,
54: creation_date OKL_PROCESS_TMPLTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
55: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
56: last_update_date OKL_PROCESS_TMPLTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
57: last_update_login NUMBER := OKL_API.G_MISS_NUM);
58:
59: GMissOklProcessTmpltsTlRec okl_process_tmplts_tl_rec_type;
52: email_subject_line OKL_PROCESS_TMPLTS_TL.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
53: created_by NUMBER := OKL_API.G_MISS_NUM,
54: creation_date OKL_PROCESS_TMPLTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
55: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
56: last_update_date OKL_PROCESS_TMPLTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
57: last_update_login NUMBER := OKL_API.G_MISS_NUM);
58:
59: GMissOklProcessTmpltsTlRec okl_process_tmplts_tl_rec_type;
60:
53: created_by NUMBER := OKL_API.G_MISS_NUM,
54: creation_date OKL_PROCESS_TMPLTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
55: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
56: last_update_date OKL_PROCESS_TMPLTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
57: last_update_login NUMBER := OKL_API.G_MISS_NUM);
58:
59: GMissOklProcessTmpltsTlRec okl_process_tmplts_tl_rec_type;
60:
61: TYPE okl_process_tmplts_tl_tbl_type IS TABLE OF okl_process_tmplts_tl_rec_type
62: INDEX BY BINARY_INTEGER;
63:
64:
65: TYPE ptmv_rec_type IS RECORD (
66: id NUMBER := OKL_API.G_MISS_NUM,
67: org_id NUMBER := OKL_API.G_MISS_NUM,
68: ptm_code OKL_PROCESS_TMPLTS_B.PTM_CODE%TYPE := OKL_API.G_MISS_CHAR,
69: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
70: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
63:
64:
65: TYPE ptmv_rec_type IS RECORD (
66: id NUMBER := OKL_API.G_MISS_NUM,
67: org_id NUMBER := OKL_API.G_MISS_NUM,
68: ptm_code OKL_PROCESS_TMPLTS_B.PTM_CODE%TYPE := OKL_API.G_MISS_CHAR,
69: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
70: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
71: jtf_amv_item_id NUMBER := -1,
64:
65: TYPE ptmv_rec_type IS RECORD (
66: id NUMBER := OKL_API.G_MISS_NUM,
67: org_id NUMBER := OKL_API.G_MISS_NUM,
68: ptm_code OKL_PROCESS_TMPLTS_B.PTM_CODE%TYPE := OKL_API.G_MISS_CHAR,
69: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
70: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
71: jtf_amv_item_id NUMBER := -1,
72: /* End Changes : R12 B */
66: id NUMBER := OKL_API.G_MISS_NUM,
67: org_id NUMBER := OKL_API.G_MISS_NUM,
68: ptm_code OKL_PROCESS_TMPLTS_B.PTM_CODE%TYPE := OKL_API.G_MISS_CHAR,
69: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
70: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
71: jtf_amv_item_id NUMBER := -1,
72: /* End Changes : R12 B */
73: sfwt_flag OKL_PROCESS_TMPLTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
74: email_subject_line OKL_PROCESS_TMPLTS_V.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
69: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
70: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
71: jtf_amv_item_id NUMBER := -1,
72: /* End Changes : R12 B */
73: sfwt_flag OKL_PROCESS_TMPLTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
74: email_subject_line OKL_PROCESS_TMPLTS_V.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
75: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
76: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
77: object_version_number NUMBER := OKL_API.G_MISS_NUM,
70: -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
71: jtf_amv_item_id NUMBER := -1,
72: /* End Changes : R12 B */
73: sfwt_flag OKL_PROCESS_TMPLTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
74: email_subject_line OKL_PROCESS_TMPLTS_V.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
75: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
76: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
77: object_version_number NUMBER := OKL_API.G_MISS_NUM,
78: attribute_category OKL_PROCESS_TMPLTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
71: jtf_amv_item_id NUMBER := -1,
72: /* End Changes : R12 B */
73: sfwt_flag OKL_PROCESS_TMPLTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
74: email_subject_line OKL_PROCESS_TMPLTS_V.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
75: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
76: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
77: object_version_number NUMBER := OKL_API.G_MISS_NUM,
78: attribute_category OKL_PROCESS_TMPLTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
79: attribute1 OKL_PROCESS_TMPLTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
72: /* End Changes : R12 B */
73: sfwt_flag OKL_PROCESS_TMPLTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
74: email_subject_line OKL_PROCESS_TMPLTS_V.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
75: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
76: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
77: object_version_number NUMBER := OKL_API.G_MISS_NUM,
78: attribute_category OKL_PROCESS_TMPLTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
79: attribute1 OKL_PROCESS_TMPLTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
80: attribute2 OKL_PROCESS_TMPLTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
73: sfwt_flag OKL_PROCESS_TMPLTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
74: email_subject_line OKL_PROCESS_TMPLTS_V.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
75: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
76: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
77: object_version_number NUMBER := OKL_API.G_MISS_NUM,
78: attribute_category OKL_PROCESS_TMPLTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
79: attribute1 OKL_PROCESS_TMPLTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
80: attribute2 OKL_PROCESS_TMPLTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
81: attribute3 OKL_PROCESS_TMPLTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
74: email_subject_line OKL_PROCESS_TMPLTS_V.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
75: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
76: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
77: object_version_number NUMBER := OKL_API.G_MISS_NUM,
78: attribute_category OKL_PROCESS_TMPLTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
79: attribute1 OKL_PROCESS_TMPLTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
80: attribute2 OKL_PROCESS_TMPLTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
81: attribute3 OKL_PROCESS_TMPLTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
82: attribute4 OKL_PROCESS_TMPLTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
75: start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
76: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
77: object_version_number NUMBER := OKL_API.G_MISS_NUM,
78: attribute_category OKL_PROCESS_TMPLTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
79: attribute1 OKL_PROCESS_TMPLTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
80: attribute2 OKL_PROCESS_TMPLTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
81: attribute3 OKL_PROCESS_TMPLTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
82: attribute4 OKL_PROCESS_TMPLTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
83: attribute5 OKL_PROCESS_TMPLTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
76: end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
77: object_version_number NUMBER := OKL_API.G_MISS_NUM,
78: attribute_category OKL_PROCESS_TMPLTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
79: attribute1 OKL_PROCESS_TMPLTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
80: attribute2 OKL_PROCESS_TMPLTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
81: attribute3 OKL_PROCESS_TMPLTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
82: attribute4 OKL_PROCESS_TMPLTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
83: attribute5 OKL_PROCESS_TMPLTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
84: attribute6 OKL_PROCESS_TMPLTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
77: object_version_number NUMBER := OKL_API.G_MISS_NUM,
78: attribute_category OKL_PROCESS_TMPLTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
79: attribute1 OKL_PROCESS_TMPLTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
80: attribute2 OKL_PROCESS_TMPLTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
81: attribute3 OKL_PROCESS_TMPLTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
82: attribute4 OKL_PROCESS_TMPLTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
83: attribute5 OKL_PROCESS_TMPLTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
84: attribute6 OKL_PROCESS_TMPLTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
85: attribute7 OKL_PROCESS_TMPLTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
78: attribute_category OKL_PROCESS_TMPLTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
79: attribute1 OKL_PROCESS_TMPLTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
80: attribute2 OKL_PROCESS_TMPLTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
81: attribute3 OKL_PROCESS_TMPLTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
82: attribute4 OKL_PROCESS_TMPLTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
83: attribute5 OKL_PROCESS_TMPLTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
84: attribute6 OKL_PROCESS_TMPLTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
85: attribute7 OKL_PROCESS_TMPLTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
86: attribute8 OKL_PROCESS_TMPLTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
79: attribute1 OKL_PROCESS_TMPLTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
80: attribute2 OKL_PROCESS_TMPLTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
81: attribute3 OKL_PROCESS_TMPLTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
82: attribute4 OKL_PROCESS_TMPLTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
83: attribute5 OKL_PROCESS_TMPLTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
84: attribute6 OKL_PROCESS_TMPLTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
85: attribute7 OKL_PROCESS_TMPLTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
86: attribute8 OKL_PROCESS_TMPLTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
87: attribute9 OKL_PROCESS_TMPLTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
80: attribute2 OKL_PROCESS_TMPLTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
81: attribute3 OKL_PROCESS_TMPLTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
82: attribute4 OKL_PROCESS_TMPLTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
83: attribute5 OKL_PROCESS_TMPLTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
84: attribute6 OKL_PROCESS_TMPLTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
85: attribute7 OKL_PROCESS_TMPLTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
86: attribute8 OKL_PROCESS_TMPLTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
87: attribute9 OKL_PROCESS_TMPLTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
88: attribute10 OKL_PROCESS_TMPLTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
81: attribute3 OKL_PROCESS_TMPLTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
82: attribute4 OKL_PROCESS_TMPLTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
83: attribute5 OKL_PROCESS_TMPLTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
84: attribute6 OKL_PROCESS_TMPLTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
85: attribute7 OKL_PROCESS_TMPLTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
86: attribute8 OKL_PROCESS_TMPLTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
87: attribute9 OKL_PROCESS_TMPLTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
88: attribute10 OKL_PROCESS_TMPLTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
89: attribute11 OKL_PROCESS_TMPLTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
82: attribute4 OKL_PROCESS_TMPLTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
83: attribute5 OKL_PROCESS_TMPLTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
84: attribute6 OKL_PROCESS_TMPLTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
85: attribute7 OKL_PROCESS_TMPLTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
86: attribute8 OKL_PROCESS_TMPLTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
87: attribute9 OKL_PROCESS_TMPLTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
88: attribute10 OKL_PROCESS_TMPLTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
89: attribute11 OKL_PROCESS_TMPLTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
90: attribute12 OKL_PROCESS_TMPLTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
83: attribute5 OKL_PROCESS_TMPLTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
84: attribute6 OKL_PROCESS_TMPLTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
85: attribute7 OKL_PROCESS_TMPLTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
86: attribute8 OKL_PROCESS_TMPLTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
87: attribute9 OKL_PROCESS_TMPLTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
88: attribute10 OKL_PROCESS_TMPLTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
89: attribute11 OKL_PROCESS_TMPLTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
90: attribute12 OKL_PROCESS_TMPLTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
91: attribute13 OKL_PROCESS_TMPLTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
84: attribute6 OKL_PROCESS_TMPLTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
85: attribute7 OKL_PROCESS_TMPLTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
86: attribute8 OKL_PROCESS_TMPLTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
87: attribute9 OKL_PROCESS_TMPLTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
88: attribute10 OKL_PROCESS_TMPLTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
89: attribute11 OKL_PROCESS_TMPLTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
90: attribute12 OKL_PROCESS_TMPLTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
91: attribute13 OKL_PROCESS_TMPLTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
92: attribute14 OKL_PROCESS_TMPLTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
85: attribute7 OKL_PROCESS_TMPLTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
86: attribute8 OKL_PROCESS_TMPLTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
87: attribute9 OKL_PROCESS_TMPLTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
88: attribute10 OKL_PROCESS_TMPLTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
89: attribute11 OKL_PROCESS_TMPLTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
90: attribute12 OKL_PROCESS_TMPLTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
91: attribute13 OKL_PROCESS_TMPLTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
92: attribute14 OKL_PROCESS_TMPLTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
93: attribute15 OKL_PROCESS_TMPLTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
86: attribute8 OKL_PROCESS_TMPLTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
87: attribute9 OKL_PROCESS_TMPLTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
88: attribute10 OKL_PROCESS_TMPLTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
89: attribute11 OKL_PROCESS_TMPLTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
90: attribute12 OKL_PROCESS_TMPLTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
91: attribute13 OKL_PROCESS_TMPLTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
92: attribute14 OKL_PROCESS_TMPLTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
93: attribute15 OKL_PROCESS_TMPLTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
94: created_by NUMBER := OKL_API.G_MISS_NUM,
87: attribute9 OKL_PROCESS_TMPLTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
88: attribute10 OKL_PROCESS_TMPLTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
89: attribute11 OKL_PROCESS_TMPLTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
90: attribute12 OKL_PROCESS_TMPLTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
91: attribute13 OKL_PROCESS_TMPLTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
92: attribute14 OKL_PROCESS_TMPLTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
93: attribute15 OKL_PROCESS_TMPLTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
94: created_by NUMBER := OKL_API.G_MISS_NUM,
95: creation_date OKL_PROCESS_TMPLTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
88: attribute10 OKL_PROCESS_TMPLTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
89: attribute11 OKL_PROCESS_TMPLTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
90: attribute12 OKL_PROCESS_TMPLTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
91: attribute13 OKL_PROCESS_TMPLTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
92: attribute14 OKL_PROCESS_TMPLTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
93: attribute15 OKL_PROCESS_TMPLTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
94: created_by NUMBER := OKL_API.G_MISS_NUM,
95: creation_date OKL_PROCESS_TMPLTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
89: attribute11 OKL_PROCESS_TMPLTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
90: attribute12 OKL_PROCESS_TMPLTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
91: attribute13 OKL_PROCESS_TMPLTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
92: attribute14 OKL_PROCESS_TMPLTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
93: attribute15 OKL_PROCESS_TMPLTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
94: created_by NUMBER := OKL_API.G_MISS_NUM,
95: creation_date OKL_PROCESS_TMPLTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
97: last_update_date OKL_PROCESS_TMPLTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
90: attribute12 OKL_PROCESS_TMPLTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
91: attribute13 OKL_PROCESS_TMPLTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
92: attribute14 OKL_PROCESS_TMPLTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
93: attribute15 OKL_PROCESS_TMPLTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
94: created_by NUMBER := OKL_API.G_MISS_NUM,
95: creation_date OKL_PROCESS_TMPLTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
97: last_update_date OKL_PROCESS_TMPLTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
98: last_update_login NUMBER := OKL_API.G_MISS_NUM,
91: attribute13 OKL_PROCESS_TMPLTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
92: attribute14 OKL_PROCESS_TMPLTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
93: attribute15 OKL_PROCESS_TMPLTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
94: created_by NUMBER := OKL_API.G_MISS_NUM,
95: creation_date OKL_PROCESS_TMPLTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
97: last_update_date OKL_PROCESS_TMPLTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
98: last_update_login NUMBER := OKL_API.G_MISS_NUM,
99: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
92: attribute14 OKL_PROCESS_TMPLTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
93: attribute15 OKL_PROCESS_TMPLTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
94: created_by NUMBER := OKL_API.G_MISS_NUM,
95: creation_date OKL_PROCESS_TMPLTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
97: last_update_date OKL_PROCESS_TMPLTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
98: last_update_login NUMBER := OKL_API.G_MISS_NUM,
99: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
100: recipient_type_code OKL_PROCESS_TMPLTS_V.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
93: attribute15 OKL_PROCESS_TMPLTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
94: created_by NUMBER := OKL_API.G_MISS_NUM,
95: creation_date OKL_PROCESS_TMPLTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
97: last_update_date OKL_PROCESS_TMPLTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
98: last_update_login NUMBER := OKL_API.G_MISS_NUM,
99: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
100: recipient_type_code OKL_PROCESS_TMPLTS_V.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
101: xml_tmplt_code OKL_PROCESS_TMPLTS_V.XML_TMPLT_CODE%TYPE :=OKL_API.G_MISS_CHAR);
94: created_by NUMBER := OKL_API.G_MISS_NUM,
95: creation_date OKL_PROCESS_TMPLTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
97: last_update_date OKL_PROCESS_TMPLTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
98: last_update_login NUMBER := OKL_API.G_MISS_NUM,
99: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
100: recipient_type_code OKL_PROCESS_TMPLTS_V.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
101: xml_tmplt_code OKL_PROCESS_TMPLTS_V.XML_TMPLT_CODE%TYPE :=OKL_API.G_MISS_CHAR);
102: /* End Changes : R12 B */
96: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
97: last_update_date OKL_PROCESS_TMPLTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
98: last_update_login NUMBER := OKL_API.G_MISS_NUM,
99: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
100: recipient_type_code OKL_PROCESS_TMPLTS_V.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
101: xml_tmplt_code OKL_PROCESS_TMPLTS_V.XML_TMPLT_CODE%TYPE :=OKL_API.G_MISS_CHAR);
102: /* End Changes : R12 B */
103:
104: g_miss_ptmv_rec ptmv_rec_type;
97: last_update_date OKL_PROCESS_TMPLTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
98: last_update_login NUMBER := OKL_API.G_MISS_NUM,
99: /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
100: recipient_type_code OKL_PROCESS_TMPLTS_V.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
101: xml_tmplt_code OKL_PROCESS_TMPLTS_V.XML_TMPLT_CODE%TYPE :=OKL_API.G_MISS_CHAR);
102: /* End Changes : R12 B */
103:
104: g_miss_ptmv_rec ptmv_rec_type;
105:
108:
109: ---------------------------------------------------------------------------
110: -- GLOBAL MESSAGE CONSTANTS
111: ---------------------------------------------------------------------------
112: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
113: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
114: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
115: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
116: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
109: ---------------------------------------------------------------------------
110: -- GLOBAL MESSAGE CONSTANTS
111: ---------------------------------------------------------------------------
112: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
113: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
114: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
115: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
116: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
117: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
110: -- GLOBAL MESSAGE CONSTANTS
111: ---------------------------------------------------------------------------
112: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
113: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
114: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
115: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
116: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
117: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
118: -- OKL_API bug (points to OKL_CONTRACTS_REQUIRED_VALUE instead of OKL_REQUIRED_VALUE)
111: ---------------------------------------------------------------------------
112: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
113: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
114: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
115: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
116: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
117: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
118: -- OKL_API bug (points to OKL_CONTRACTS_REQUIRED_VALUE instead of OKL_REQUIRED_VALUE)
119:
112: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
113: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
114: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
115: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
116: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
117: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
118: -- OKL_API bug (points to OKL_CONTRACTS_REQUIRED_VALUE instead of OKL_REQUIRED_VALUE)
119:
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
113: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
114: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
115: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
116: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
117: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
118: -- OKL_API bug (points to OKL_CONTRACTS_REQUIRED_VALUE instead of OKL_REQUIRED_VALUE)
119:
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
121:
114: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
115: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
116: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
117: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
118: -- OKL_API bug (points to OKL_CONTRACTS_REQUIRED_VALUE instead of OKL_REQUIRED_VALUE)
119:
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
121:
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
118: -- OKL_API bug (points to OKL_CONTRACTS_REQUIRED_VALUE instead of OKL_REQUIRED_VALUE)
119:
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
121:
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
125: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
126: ---------------------------------------------------------------------------
119:
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
121:
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
125: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
126: ---------------------------------------------------------------------------
127: -- GLOBAL MESSAGE CONSTANTS - Post TAPI generation
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
121:
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
125: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
126: ---------------------------------------------------------------------------
127: -- GLOBAL MESSAGE CONSTANTS - Post TAPI generation
128: ---------------------------------------------------------------------------
121:
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
125: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
126: ---------------------------------------------------------------------------
127: -- GLOBAL MESSAGE CONSTANTS - Post TAPI generation
128: ---------------------------------------------------------------------------
129: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
137: ---------------------------------------------------------------------------
138: -- GLOBAL VARIABLES
139: ---------------------------------------------------------------------------
140: G_PKG_NAME CONSTANT VARCHAR2(200) := 'Okl_Ptm_Pvt';
141: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
142: ---------------------------------------------------------------------------
143: -- Procedures and Functions
144: ---------------------------------------------------------------------------
145: PROCEDURE qc;
148: PROCEDURE add_language;
149:
150: PROCEDURE insert_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_ptmv_rec IN ptmv_rec_type,
156: p_ptmv_rec IN ptmv_rec_type,
157: x_ptmv_rec OUT NOCOPY ptmv_rec_type);
158: PROCEDURE insert_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_ptmv_tbl IN ptmv_tbl_type,
164: p_ptmv_tbl IN ptmv_tbl_type,
165: x_ptmv_tbl OUT NOCOPY ptmv_tbl_type);
166: PROCEDURE lock_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_ptmv_rec IN ptmv_rec_type);
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_ptmv_rec IN ptmv_rec_type);
173: PROCEDURE lock_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_ptmv_tbl IN ptmv_tbl_type);
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_ptmv_tbl IN ptmv_tbl_type);
180: PROCEDURE update_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_ptmv_rec IN ptmv_rec_type,
186: p_ptmv_rec IN ptmv_rec_type,
187: x_ptmv_rec OUT NOCOPY ptmv_rec_type);
188: PROCEDURE update_row(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_ptmv_tbl IN ptmv_tbl_type,
194: p_ptmv_tbl IN ptmv_tbl_type,
195: x_ptmv_tbl OUT NOCOPY ptmv_tbl_type);
196: PROCEDURE delete_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_ptmv_rec IN ptmv_rec_type);
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_ptmv_rec IN ptmv_rec_type);
203: PROCEDURE delete_row(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_ptmv_tbl IN ptmv_tbl_type);
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_ptmv_tbl IN ptmv_tbl_type);
210: PROCEDURE validate_row(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_ptmv_rec IN ptmv_rec_type);
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_ptmv_rec IN ptmv_rec_type);
217: PROCEDURE validate_row(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_ptmv_tbl IN ptmv_tbl_type);