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 */
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,
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,
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 */
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);
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
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 */
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,