26: -- This API will be used to mark any article as amended if any of variables have been changed.
27: */
28: PROCEDURE Mark_Amendment (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31:
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_data OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
47: 2. Update the table OKC_TMPL_DRAFT_CLAUSES with the merged/parent template id.
48: */
49: PROCEDURE Merge_Template_Working_Copy (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53:
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_data OUT NOCOPY VARCHAR2,
48: */
49: PROCEDURE Merge_Template_Working_Copy (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53:
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_data OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
63: -- get values of all variables being used in Terms and Conditions of a document
64: */
65: PROCEDURE Get_System_Variables (
66: p_api_version IN NUMBER,
67: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
68:
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_data OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
71: x_msg_count OUT NOCOPY NUMBER,
72:
73: p_doc_type IN VARCHAR2,
74: p_doc_id IN NUMBER,
75: p_only_doc_variables IN VARCHAR2 := FND_API.G_TRUE,
76:
77: x_sys_var_value_tbl OUT NOCOPY OKC_TERMS_UTIL_GRP.sys_var_value_tbl_type );
78:
79: /*
82: -- for every occurance of variable on document
83: */
84: PROCEDURE Substitute_Var_Value_Globally (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87:
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
94: p_variable_code IN VARCHAR2,
95: p_variable_value IN VARCHAR2,
96: p_variable_value_id IN VARCHAR2,
97: p_mode IN VARCHAR2,
98: p_validate_commit IN VARCHAR2 := FND_API.G_TRUE,
99: p_validation_string IN VARCHAR2 := NULL );
100:
101: /*
102: -- PROCEDURE Create_Unassigned_Section
103: -- creating un-assigned sections in a document
104: */
105: PROCEDURE Create_Unassigned_Section (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109:
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_data OUT NOCOPY VARCHAR2,
104: */
105: PROCEDURE Create_Unassigned_Section (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109:
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
292: ) RETURN VARCHAR2;
293:
294: PROCEDURE get_template_details (
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297: p_commit IN VARCHAR2 := FND_API.G_FALSE,
298:
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_data OUT NOCOPY VARCHAR2,
293:
294: PROCEDURE get_template_details (
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297: p_commit IN VARCHAR2 := FND_API.G_FALSE,
298:
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_data OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
388: -- new out parameter x_parent_template_id returns the template id of the merged template
389: */
390: PROCEDURE Merge_Template_Working_Copy (
391: p_api_version IN NUMBER,
392: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394:
395: x_return_status OUT NOCOPY VARCHAR2,
396: x_msg_data OUT NOCOPY VARCHAR2,
389: */
390: PROCEDURE Merge_Template_Working_Copy (
391: p_api_version IN NUMBER,
392: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394:
395: x_return_status OUT NOCOPY VARCHAR2,
396: x_msg_data OUT NOCOPY VARCHAR2,
397: x_msg_count OUT NOCOPY NUMBER,
424: --Pre-reqs : None.
425: --Parameters :
426: --IN : p_api_version IN NUMBER Required
427: -- : p_init_msg_list IN VARCHAR2 Optional
428: -- Default = FND_API.G_FALSE
429: -- : p_commit IN VARCHAR2 Optional
430: -- Default = FND_API.G_FALSE
431: -- : p_doc_ids_tbl IN doc_ids_tbl Required
432: -- List of document ids whose Contract Administrator to be changed
426: --IN : p_api_version IN NUMBER Required
427: -- : p_init_msg_list IN VARCHAR2 Optional
428: -- Default = FND_API.G_FALSE
429: -- : p_commit IN VARCHAR2 Optional
430: -- Default = FND_API.G_FALSE
431: -- : p_doc_ids_tbl IN doc_ids_tbl Required
432: -- List of document ids whose Contract Administrator to be changed
433: -- : p_doc_types_tbl IN doc_types_tbl Required
434: -- List of document types whose Contract Administrator to be changed
460: --Pre-reqs : None.
461: --Parameters :
462: --IN : p_api_version IN NUMBER Required
463: -- : p_init_msg_list IN VARCHAR2 Optional
464: -- Default = FND_API.G_FALSE
465: -- : p_doc_id IN NUMBER Required
466: -- Id of document whose Contract Administrator is required
467: -- : p_doc_type IN VARCHAR2 Required
468: -- Type of document whose Contract Administrator is required
503:
504: --For R12: MSWord2WaySync
505: PROCEDURE lock_contract(
506: p_api_version IN NUMBER,
507: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
508:
509: p_commit IN Varchar2,
510: p_document_type IN VARCHAR2,
511: p_document_id IN NUMBER,
516:
517: --For R12: MSWord2WaySync
518: PROCEDURE unlock_contract(
519: p_api_version IN NUMBER,
520: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
521:
522: p_commit IN Varchar2,
523: p_document_type IN VARCHAR2,
524: p_document_id IN NUMBER,
528: );
529:
530: PROCEDURE get_default_contract_admin(
531: p_api_version IN NUMBER,
532: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
533:
534: p_document_type IN VARCHAR2,
535: p_document_id IN NUMBER,
536: x_has_default_contract_admin OUT NOCOPY VARCHAR2,
563:
564: --For R12.1: User defined variables with procedures
565: PROCEDURE set_udv_with_procedures (
566: p_api_version IN NUMBER,
567: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
568: p_document_type IN VARCHAR2,
569: p_document_id IN NUMBER,
570: p_output_error IN VARCHAR2 := FND_API.G_TRUE,
571: x_return_status OUT NOCOPY VARCHAR2,
566: p_api_version IN NUMBER,
567: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
568: p_document_type IN VARCHAR2,
569: p_document_id IN NUMBER,
570: p_output_error IN VARCHAR2 := FND_API.G_TRUE,
571: x_return_status OUT NOCOPY VARCHAR2,
572: x_msg_data OUT NOCOPY VARCHAR2,
573: x_msg_count OUT NOCOPY NUMBER
574: );
576: PROCEDURE get_udv_with_proc_value (
577: p_document_type IN VARCHAR2,
578: p_document_id IN NUMBER,
579: p_variable_code IN VARCHAR2,
580: p_output_error IN VARCHAR2 := FND_API.G_FALSE,
581: x_variable_value OUT NOCOPY VARCHAR2,
582: x_return_status OUT NOCOPY VARCHAR2,
583: x_msg_data OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER