eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_CPAGEUTILITY_PVT dependencies on FND_API

Line 134: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

130: p_content_type_code IN VARCHAR2,
131: p_def_disp_template_id IN NUMBER,
132: p_delv_id IN NUMBER,
133: p_assoc_type_code IN VARCHAR2,
134: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
135: p_api_version IN NUMBER DEFAULT 1.0,
136: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
137: x_citem_id OUT NUMBER,
138: x_citem_ver_id OUT NUMBER,

Line 136: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

132: p_delv_id IN NUMBER,
133: p_assoc_type_code IN VARCHAR2,
134: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
135: p_api_version IN NUMBER DEFAULT 1.0,
136: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
137: x_citem_id OUT NUMBER,
138: x_citem_ver_id OUT NUMBER,
139: x_return_status OUT VARCHAR2,
140: x_msg_count OUT NUMBER,

Line 165: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

161: p_content_type_code IN VARCHAR2,
162: p_delv_id IN NUMBER,
163: p_citem_id IN NUMBER,
164: p_assoc_type_code IN VARCHAR2,
165: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
166: p_api_version IN NUMBER DEFAULT 1.0,
167: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
168: x_return_status OUT VARCHAR2,
169: x_msg_count OUT NUMBER,

Line 167: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

163: p_citem_id IN NUMBER,
164: p_assoc_type_code IN VARCHAR2,
165: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
166: p_api_version IN NUMBER DEFAULT 1.0,
167: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
168: x_return_status OUT VARCHAR2,
169: x_msg_count OUT NUMBER,
170: x_msg_data OUT VARCHAR2
171: );

Line 197: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

193: p_def_disp_template_id IN NUMBER,
194: p_delv_id IN NUMBER,
195: p_citem_id IN NUMBER,
196: p_assoc_type_code IN VARCHAR2,
197: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
198: p_api_version IN NUMBER DEFAULT 1.0,
199: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
200: x_return_status OUT VARCHAR2,
201: x_msg_count OUT NUMBER,

Line 199: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

195: p_citem_id IN NUMBER,
196: p_assoc_type_code IN VARCHAR2,
197: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
198: p_api_version IN NUMBER DEFAULT 1.0,
199: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
200: x_return_status OUT VARCHAR2,
201: x_msg_count OUT NUMBER,
202: x_msg_data OUT VARCHAR2
203: );

Line 286: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.

282: p_owner_resource_id IN NUMBER,
283: p_owner_resource_type IN VARCHAR2,
284: p_has_merge_fields IN VARCHAR2,
285: p_has_page_merge_fields IN VARCHAR2,
286: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
287: p_data_source_list IN JTF_VARCHAR2_TABLE_300,
288: p_merge_fields_list IN JTF_VARCHAR2_TABLE_300,
289: p_attribute_type_code IN VARCHAR2,
290: p_parent_citem_id IN NUMBER,

Line 293: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

289: p_attribute_type_code IN VARCHAR2,
290: p_parent_citem_id IN NUMBER,
291: p_parent_citem_ver_id IN NUMBER,
292: p_parent_ctype_code IN VARCHAR2,
293: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
294: p_api_version IN NUMBER DEFAULT 1.0,
295: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
296: px_citem_id IN OUT NUMBER,
297: px_citem_ver_id IN OUT NUMBER,

Line 295: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

291: p_parent_citem_ver_id IN NUMBER,
292: p_parent_ctype_code IN VARCHAR2,
293: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
294: p_api_version IN NUMBER DEFAULT 1.0,
295: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
296: px_citem_id IN OUT NUMBER,
297: px_citem_ver_id IN OUT NUMBER,
298: x_return_status OUT VARCHAR2,
299: x_msg_count OUT NUMBER,

Line 302: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_true

298: x_return_status OUT VARCHAR2,
299: x_msg_count OUT NUMBER,
300: x_msg_data OUT VARCHAR2,
301: p_dml_flag IN VARCHAR2,
302: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_true
303: );
304:
305:
306: -----------------------------------------------------------------------

Line 357: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.

353: p_description IN VARCHAR2,
354: p_delv_id IN NUMBER,
355: p_owner_resource_id IN NUMBER,
356: p_owner_resource_type IN VARCHAR2,
357: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
358: p_attr_types IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
359: p_attr_values IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
360: p_parent_citem_id IN NUMBER,
361: p_parent_citem_ver_id IN NUMBER,

Line 364: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

360: p_parent_citem_id IN NUMBER,
361: p_parent_citem_ver_id IN NUMBER,
362: p_parent_ctype_code IN VARCHAR2,
363: p_attribute_type_code IN VARCHAR2,
364: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
365: p_api_version IN NUMBER DEFAULT 1.0,
366: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
367: px_citem_id IN OUT NUMBER,
368: px_citem_ver_id IN OUT NUMBER,

Line 366: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

362: p_parent_ctype_code IN VARCHAR2,
363: p_attribute_type_code IN VARCHAR2,
364: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
365: p_api_version IN NUMBER DEFAULT 1.0,
366: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
367: px_citem_id IN OUT NUMBER,
368: px_citem_ver_id IN OUT NUMBER,
369: x_return_status OUT VARCHAR2,
370: x_msg_count OUT NUMBER,

Line 373: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_true

369: x_return_status OUT VARCHAR2,
370: x_msg_count OUT NUMBER,
371: x_msg_data OUT VARCHAR2,
372: p_dml_flag IN VARCHAR2,
373: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_true
374: );
375:
376: -----------------------------------------------------------------------
377: -- PROCEDURE

Line 419: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

415: p_content_item_name IN VARCHAR2,
416: p_description IN VARCHAR2,
417: p_attach_file_id IN NUMBER,
418: p_attach_file_name IN VARCHAR2,
419: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
420: p_api_version IN NUMBER DEFAULT 1.0,
421: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_true,
422: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
423: x_return_status OUT VARCHAR2,

Line 421: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_true,

417: p_attach_file_id IN NUMBER,
418: p_attach_file_name IN VARCHAR2,
419: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
420: p_api_version IN NUMBER DEFAULT 1.0,
421: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_true,
422: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
423: x_return_status OUT VARCHAR2,
424: x_msg_count OUT NUMBER,
425: x_msg_data OUT VARCHAR2

Line 422: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

418: p_attach_file_name IN VARCHAR2,
419: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
420: p_api_version IN NUMBER DEFAULT 1.0,
421: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_true,
422: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
423: x_return_status OUT VARCHAR2,
424: x_msg_count OUT NUMBER,
425: x_msg_data OUT VARCHAR2
426: );

Line 586: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_true, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.

582: p_description IN VARCHAR2,
583: p_delv_id IN NUMBER,
584: p_resource_id IN NUMBER,
585: p_resource_type IN VARCHAR2,
586: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_true, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
587: p_attr_types_cp_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
588: p_attr_values_cp_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
589: p_attach_file_id IN NUMBER,
590: p_attach_file_name IN VARCHAR2,

Line 597: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

593: p_parent_attr_type_code IN VARCHAR2,
594: p_parent_citem_id IN NUMBER,
595: p_parent_citem_ver_id IN NUMBER,
596: p_parent_ctype_code IN VARCHAR2,
597: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
598: p_api_version IN NUMBER DEFAULT 1.0,
599: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
600: x_cp_image_citem_id OUT NUMBER,
601: x_cp_image_citem_ver_id OUT NUMBER,

Line 599: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

595: p_parent_citem_ver_id IN NUMBER,
596: p_parent_ctype_code IN VARCHAR2,
597: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
598: p_api_version IN NUMBER DEFAULT 1.0,
599: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
600: x_cp_image_citem_id OUT NUMBER,
601: x_cp_image_citem_ver_id OUT NUMBER,
602: x_return_status OUT VARCHAR2,
603: x_msg_count OUT NUMBER,

Line 667: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

663: p_attach_file_id IN NUMBER,
664: p_attach_file_name IN VARCHAR2,
665: p_attr_types_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
666: p_attr_values_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
667: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
668: p_api_version IN NUMBER DEFAULT 1.0,
669: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
670: x_return_status OUT VARCHAR2,
671: x_msg_count OUT NUMBER,

Line 669: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

665: p_attr_types_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
666: p_attr_values_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
667: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
668: p_api_version IN NUMBER DEFAULT 1.0,
669: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
670: x_return_status OUT VARCHAR2,
671: x_msg_count OUT NUMBER,
672: x_msg_data OUT VARCHAR2
673: );

Line 723: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

719: p_attr_types_for_update IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
720: p_attr_values_for_update IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
721: p_attach_file_id IN NUMBER DEFAULT NULL,
722: p_attach_file_name IN VARCHAR2 DEFAULT NULL,
723: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
724: p_api_version IN NUMBER DEFAULT 1.0,
725: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
726: x_return_status OUT VARCHAR2,
727: x_msg_count OUT NUMBER,

Line 725: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

721: p_attach_file_id IN NUMBER DEFAULT NULL,
722: p_attach_file_name IN VARCHAR2 DEFAULT NULL,
723: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
724: p_api_version IN NUMBER DEFAULT 1.0,
725: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
726: x_return_status OUT VARCHAR2,
727: x_msg_count OUT NUMBER,
728: x_msg_data OUT VARCHAR2,
729: p_replace_attr_bundle IN VARCHAR2 DEFAULT FND_API.g_false

Line 729: p_replace_attr_bundle IN VARCHAR2 DEFAULT FND_API.g_false

725: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
726: x_return_status OUT VARCHAR2,
727: x_msg_count OUT NUMBER,
728: x_msg_data OUT VARCHAR2,
729: p_replace_attr_bundle IN VARCHAR2 DEFAULT FND_API.g_false
730: );
731:
732: -----------------------------------------------------------------------
733: -- PROCEDURE

Line 771: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

767: p_attach_file_id IN NUMBER,
768: p_attach_file_name IN VARCHAR2,
769: p_resource_id IN NUMBER,
770: p_resource_type IN VARCHAR2,
771: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
772: p_api_version IN NUMBER DEFAULT 1.0,
773: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
774: x_citem_id OUT NUMBER,
775: x_citem_ver_id OUT NUMBER,

Line 773: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

769: p_resource_id IN NUMBER,
770: p_resource_type IN VARCHAR2,
771: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
772: p_api_version IN NUMBER DEFAULT 1.0,
773: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
774: x_citem_id OUT NUMBER,
775: x_citem_ver_id OUT NUMBER,
776: x_return_status OUT VARCHAR2,
777: x_msg_count OUT NUMBER,

Line 819: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.

815: p_start_date IN DATE DEFAULT SYSDATE,
816: p_end_date IN DATE DEFAULT NULL,
817: p_owner_resource_id IN NUMBER,
818: p_owner_resource_type IN VARCHAR2,
819: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
820: p_attribute_type_code IN VARCHAR2,
821: p_parent_citem_id IN NUMBER,
822: p_parent_citem_ver_id IN NUMBER,
823: p_parent_ctype_code IN VARCHAR2,

Line 824: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

820: p_attribute_type_code IN VARCHAR2,
821: p_parent_citem_id IN NUMBER,
822: p_parent_citem_ver_id IN NUMBER,
823: p_parent_ctype_code IN VARCHAR2,
824: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
825: p_api_version IN NUMBER DEFAULT 1.0,
826: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
827: x_citem_id OUT NUMBER,
828: x_citem_ver_id OUT NUMBER,

Line 826: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

822: p_parent_citem_ver_id IN NUMBER,
823: p_parent_ctype_code IN VARCHAR2,
824: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
825: p_api_version IN NUMBER DEFAULT 1.0,
826: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
827: x_citem_id OUT NUMBER,
828: x_citem_ver_id OUT NUMBER,
829: x_return_status OUT VARCHAR2,
830: x_msg_count OUT NUMBER,

Line 907: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.

903: p_content_item_name IN VARCHAR2,
904: p_description IN VARCHAR2,
905: p_owner_resource_id IN NUMBER,
906: p_owner_resource_type IN VARCHAR2,
907: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
908: p_attribute_type_code IN VARCHAR2,
909: p_parent_citem_id IN NUMBER,
910: p_parent_citem_ver_id IN NUMBER,
911: p_parent_ctype_code IN VARCHAR2,

Line 916: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

912: p_ui_control_type IN VARCHAR2 DEFAULT G_DEF_UI_FOR_SUBMIT,
913: p_button_label IN VARCHAR2,
914: p_ocm_image_id IN NUMBER DEFAULT NULL,
915: p_alignment IN VARCHAR2 DEFAULT G_DEF_ALIGN_FOR_SUBMIT,
916: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
917: p_api_version IN NUMBER DEFAULT 1.0,
918: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
919: x_citem_id OUT NUMBER,
920: x_citem_ver_id OUT NUMBER,

Line 918: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

914: p_ocm_image_id IN NUMBER DEFAULT NULL,
915: p_alignment IN VARCHAR2 DEFAULT G_DEF_ALIGN_FOR_SUBMIT,
916: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
917: p_api_version IN NUMBER DEFAULT 1.0,
918: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
919: x_citem_id OUT NUMBER,
920: x_citem_ver_id OUT NUMBER,
921: x_return_status OUT VARCHAR2,
922: x_msg_count OUT NUMBER,

Line 963: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

959: p_ui_control_type IN VARCHAR2,
960: p_button_label IN VARCHAR2,
961: p_ocm_image_id IN NUMBER,
962: p_alignment IN VARCHAR2,
963: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
964: p_api_version IN NUMBER DEFAULT 1.0,
965: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
966: x_return_status OUT VARCHAR2,
967: x_msg_count OUT NUMBER,

Line 965: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

961: p_ocm_image_id IN NUMBER,
962: p_alignment IN VARCHAR2,
963: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
964: p_api_version IN NUMBER DEFAULT 1.0,
965: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
966: x_return_status OUT VARCHAR2,
967: x_msg_count OUT NUMBER,
968: x_msg_data OUT VARCHAR2
969: );

Line 985: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_true,

981: -----------------------------------------------------------------------
982: PROCEDURE erase_blob(
983: p_file_id IN NUMBER,
984: x_blob OUT BLOB,
985: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_true,
986: x_return_status OUT VARCHAR2,
987: x_msg_count OUT NUMBER,
988: x_msg_data OUT VARCHAR2
989: );