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.CZ_ORAAPPS_INTEGRATE dependencies on FND_PROGRAM

Line 98: IF NOT(fnd_program.executable_exists(executable_short_name=>p_short_name,

94: exec_exists EXCEPTION;
95: no_req_group EXCEPTION;
96:
97: BEGIN
98: IF NOT(fnd_program.executable_exists(executable_short_name=>p_short_name,
99: application => p_application)) THEN
100: fnd_program.executable(executable => p_name,
101: short_name => p_short_name,
102: application => p_application,

Line 100: fnd_program.executable(executable => p_name,

96:
97: BEGIN
98: IF NOT(fnd_program.executable_exists(executable_short_name=>p_short_name,
99: application => p_application)) THEN
100: fnd_program.executable(executable => p_name,
101: short_name => p_short_name,
102: application => p_application,
103: description => p_description,
104: execution_method => 'PL/SQL Stored Procedure',

Line 110: fnd_program.register(program => p_name,

106: ELSE
107: raise exec_exists;
108: END IF;
109: BEGIN
110: fnd_program.register(program => p_name,
111: application => p_application,
112: enabled => 'Y',
113: short_name => p_short_name,
114: description => p_description,

Line 129: IF fnd_program.request_group_exists(p_request_group, p_application)

125: -- so it can be seen in Apps UI.
126:
127: IF p_request_group IS NOT NULL THEN
128: BEGIN
129: IF fnd_program.request_group_exists(p_request_group, p_application)
130: THEN
131: fnd_program.add_to_group(p_short_name, p_application, p_request_group, p_application);
132: ELSE
133: raise no_req_group;

Line 131: fnd_program.add_to_group(p_short_name, p_application, p_request_group, p_application);

127: IF p_request_group IS NOT NULL THEN
128: BEGIN
129: IF fnd_program.request_group_exists(p_request_group, p_application)
130: THEN
131: fnd_program.add_to_group(p_short_name, p_application, p_request_group, p_application);
132: ELSE
133: raise no_req_group;
134: END IF;
135: END;

Line 158: fnd_program.delete_program(p_short_name,p_application);

154: PROCEDURE delete_spx_process
155: (p_short_name IN VARCHAR2,
156: p_application IN VARCHAR2) AS
157: BEGIN
158: fnd_program.delete_program(p_short_name,p_application);
159: fnd_program.delete_executable(p_short_name,p_application);
160: commit;
161: END;
162:

Line 159: fnd_program.delete_executable(p_short_name,p_application);

155: (p_short_name IN VARCHAR2,
156: p_application IN VARCHAR2) AS
157: BEGIN
158: fnd_program.delete_program(p_short_name,p_application);
159: fnd_program.delete_executable(p_short_name,p_application);
160: commit;
161: END;
162:
163:

Line 206: fnd_program.parameter(program_short_name=>'SPOEEXPSO',

202: 'CZ_EXPORT.SUBMIT_FOR_QUOTE_CP',
203: request_group,
204: cz_schema);
205:
206: fnd_program.parameter(program_short_name=>'SPOEEXPSO',
207: application=>application_name,
208: sequence=>1,
209: parameter=>'QUOTE_HDR_ID',
210: description=>'QUOTE ID',

Line 274: fnd_program.parameter(program_short_name=>'SPAREXPSC',

270: 'Export of Single Customer from SellingPoint to OE',
271: 'CZ_EXPORT.CUSTOMER_EXPORT_CP',
272: ar_request_group,
273: cz_schema);
274: fnd_program.parameter(program_short_name=>'SPAREXPSC',
275: application=>ar_application_name,
276: sequence=>1,
277: parameter=>'CUSTOMER_ID',
278: description=>'CUSTOMER_ID',

Line 323: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',

319: 'Populate Configuration Models',
320: 'CZ_ORAAPPS_INTEGRATE.POPULATEMODELS_CP',
321: request_group,
322: cz_schema);
323: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',
324: application=>application_name,
325: sequence=>1,
326: parameter=>'sORG_ID',
327: description=>'Organization Code',

Line 334: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',

330: description_size=>10,
331: concatenated_description_size=>50,
332: prompt=>'Organization Code');
333:
334: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',
335: application=>application_name,
336: sequence=>2,
337: parameter=>'dsORG_ID',
338: description=>'dummy value',

Line 348: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',

344: description_size=>10,
345: concatenated_description_size=>50,
346: prompt=>'dsORG_ID');
347:
348: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',
349: application=>application_name,
350: sequence=>3,
351: parameter=>'sFrom',
352: description=>'Model Inventory Item From',

Line 358: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',

354: display_size=>10,
355: description_size=>10,
356: concatenated_description_size=>50,
357: prompt=>'Model Inventory Item From');
358: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',
359: application=>application_name,
360: sequence=>4,
361: parameter=>'sTo',
362: description=>'Model Inventory Item To',

Line 368: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',

364: display_size=>10,
365: description_size=>10,
366: concatenated_description_size=>50,
367: prompt=>'Model Inventory Item To');
368: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',
369: application=>application_name,
370: sequence=>5,
371: parameter=>'sChild',
372: description=>'Reference existing child models when available?',

Line 393: fnd_program.parameter(program_short_name=>'CZAPPIMPRFCM',

389: 'CZ_ORAAPPS_INTEGRATE.REFRESHSINGLEMODEL_CP',
390: request_group,
391: cz_schema);
392:
393: fnd_program.parameter(program_short_name=>'CZAPPIMPRFCM',
394: application=>application_name,
395: sequence=>1,
396: parameter=>'sFolder_Id',
397: description=>'Folder',

Line 405: fnd_program.parameter(program_short_name=>'CZAPPIMPRFCM',

401: concatenated_description_size=>50,
402: prompt=>'Folder'
403: );
404:
405: fnd_program.parameter(program_short_name=>'CZAPPIMPRFCM',
406: application=>application_name,
407: sequence=>2,
408: parameter=>'sModel_Id',
409: description=>'Configuration Model',

Line 417: fnd_program.parameter(program_short_name=>'CZAPPIMPRFCM',

413: concatenated_description_size=>50,
414: prompt=>'Configuration Model Id'
415: );
416:
417: fnd_program.parameter(program_short_name=>'CZAPPIMPRFCM',
418: application=>application_name,
419: sequence=>3,
420: parameter=>'sChild',
421: description=>'Reference existing child models when available?',

Line 443: fnd_program.parameter(program_short_name=>'CZAPPIMPRMCM',

439: 'CZ_ORAAPPS_INTEGRATE.REMOVEMODEL_CP',
440: request_group,
441: cz_schema);
442:
443: fnd_program.parameter(program_short_name=>'CZAPPIMPRMCM',
444: application=>application_name,
445: sequence=>1,
446: parameter=>'sFolder_Id',
447: description=>'Folder',

Line 455: fnd_program.parameter(program_short_name=>'CZAPPIMPRMCM',

451: concatenated_description_size=>50,
452: prompt=>'Folder'
453: );
454:
455: fnd_program.parameter(program_short_name=>'CZAPPIMPRMCM',
456: application=>application_name,
457: sequence=>2,
458: parameter=>'sModel_Id',
459: description=>'Configuration Model',

Line 467: fnd_program.parameter(program_short_name=>'CZAPPIMPRMCM',

463: concatenated_description_size=>50,
464: prompt=>'Configuration Model Id'
465: );
466:
467: fnd_program.parameter(program_short_name=>'CZAPPIMPRMCM',
468: application=>application_name,
469: sequence=>3,
470: parameter=>'sImportEnabled',
471: description=>'Import Enabled (Y/N)?',

Line 517: fnd_program.parameter(program_short_name=>'CZBOMSIM',

513: 'CZ_ORAAPPS_INTEGRATE.check_model_similarity_cp',
514: request_group,
515: cz_schema);
516:
517: fnd_program.parameter(program_short_name=>'CZBOMSIM',
518: application=>application_name,
519: sequence=>1,
520: parameter=>'P_TARGET_INSTANCE',
521: description=>'Target Instance',

Line 529: fnd_program.parameter(program_short_name=>'CZBOMSIM',

525: concatenated_description_size=>50,
526: prompt=>'Target Instance');
527:
528:
529: fnd_program.parameter(program_short_name=>'CZBOMSIM',
530: application=>application_name,
531: sequence=>2,
532: parameter=>'P_FOLDER_ID',
533: description=>'Folder',

Line 541: fnd_program.parameter(program_short_name=>'CZBOMSIM',

537: concatenated_description_size=>50,
538: prompt=>'Folder'
539: );
540:
541: fnd_program.parameter(program_short_name=>'CZBOMSIM',
542: application=>application_name,
543: sequence=>3,
544: parameter=>'P_MODEL_ID',
545: description=>'List Of Models',

Line 567: fnd_program.parameter(program_short_name=>'CZALLBOMSIM',

563: 'CZ_ORAAPPS_INTEGRATE.check_all_models_similarity_cp',
564: request_group,
565: cz_schema);
566:
567: fnd_program.parameter(program_short_name=>'CZALLBOMSIM',
568: application=>application_name,
569: sequence=>1,
570: parameter=>'P_TARGET_INSTANCE',
571: description=>'Target Instance',

Line 607: fnd_program.delete_program('CZBOMSIM',application_name);

603: (application_name IN VARCHAR2 -- default 'Oracle Configurator'
604: ) AS
605: BEGIN
606: BEGIN
607: fnd_program.delete_program('CZBOMSIM',application_name);
608: fnd_program.delete_executable('CZBOMSIM',application_name);
609: EXCEPTION
610: WHEN NO_DATA_FOUND THEN
611: LOG_REPORT('Error : < CZBOMSIM > does not exist.');

Line 608: fnd_program.delete_executable('CZBOMSIM',application_name);

604: ) AS
605: BEGIN
606: BEGIN
607: fnd_program.delete_program('CZBOMSIM',application_name);
608: fnd_program.delete_executable('CZBOMSIM',application_name);
609: EXCEPTION
610: WHEN NO_DATA_FOUND THEN
611: LOG_REPORT('Error : < CZBOMSIM > does not exist.');
612: WHEN OTHERS THEN

Line 617: fnd_program.delete_program('CZALLBOMSIM',application_name);

613: LOG_REPORT('Error : < CZBOMSIM > :'||SQLERRM);
614: END;
615:
616: BEGIN
617: fnd_program.delete_program('CZALLBOMSIM',application_name);
618: fnd_program.delete_executable('CZALLBOMSIM',application_name);
619: EXCEPTION
620: WHEN NO_DATA_FOUND THEN
621: LOG_REPORT('Error : < CZALLBOMSIM > does not exist.');

Line 618: fnd_program.delete_executable('CZALLBOMSIM',application_name);

614: END;
615:
616: BEGIN
617: fnd_program.delete_program('CZALLBOMSIM',application_name);
618: fnd_program.delete_executable('CZALLBOMSIM',application_name);
619: EXCEPTION
620: WHEN NO_DATA_FOUND THEN
621: LOG_REPORT('Error : < CZALLBOMSIM > does not exist.');
622: WHEN OTHERS THEN

Line 627: fnd_program.delete_program('CZALLBOMSYNC',application_name);

623: LOG_REPORT('Error : < CZALLBOMSIM > :'||SQLERRM);
624: END;
625:
626: BEGIN
627: fnd_program.delete_program('CZALLBOMSYNC',application_name);
628: fnd_program.delete_executable('CZALLBOMSYNC',application_name);
629: EXCEPTION
630: WHEN NO_DATA_FOUND THEN
631: LOG_REPORT('Error : < CZALLBOMSYNC > does not exist.');

Line 628: fnd_program.delete_executable('CZALLBOMSYNC',application_name);

624: END;
625:
626: BEGIN
627: fnd_program.delete_program('CZALLBOMSYNC',application_name);
628: fnd_program.delete_executable('CZALLBOMSYNC',application_name);
629: EXCEPTION
630: WHEN NO_DATA_FOUND THEN
631: LOG_REPORT('Error : < CZALLBOMSYNC > does not exist.');
632: WHEN OTHERS THEN

Line 656: fnd_program.parameter(program_short_name=>'CZREPOP',

652: 'CZ_ORAAPPS_INTEGRATE.Repopulate_cp',
653: request_group,
654: cz_schema);
655:
656: fnd_program.parameter(program_short_name=>'CZREPOP',
657: application=>application_name,
658: sequence=>1,
659: parameter=>'sFolder_Id',
660: description=>'Folder',

Line 667: fnd_program.parameter(program_short_name=>'CZREPOP',

663: description_size=>20,
664: concatenated_description_size=>50,
665: prompt=>'Folder');
666:
667: fnd_program.parameter(program_short_name=>'CZREPOP',
668: application=>application_name,
669: sequence=>2,
670: parameter=>'sModel_Id',
671: description=>'Configuration Model',

Line 693: fnd_program.parameter(program_short_name=>'CZREPGS',

689: 'CZ_ORAAPPS_INTEGRATE.GETSETTING',
690: request_group,
691: cz_schema);
692:
693: fnd_program.parameter(program_short_name=>'CZREPGS',
694: application=>application_name,
695: sequence=>1,
696: parameter=>'LIKE_SECTION_NAME',
697: description=>'SECTION NAME',

Line 705: fnd_program.parameter(program_short_name=>'CZREPGS',

701: display_size=>20,
702: description_size=>20,
703: concatenated_description_size=>50,
704: prompt=>'SECTION NAME');
705: fnd_program.parameter(program_short_name=>'CZREPGS',
706: application=>application_name,
707: sequence=>2,
708: parameter=>'LIKE_SETTING_ID',
709: description=>'SETTING_ID',

Line 731: fnd_program.parameter(program_short_name=>'CZREPIN',

727: 'CZ_ORAAPPS_INTEGRATE.ASSIGNSETTING',
728: request_group,
729: cz_schema);
730:
731: fnd_program.parameter(program_short_name=>'CZREPIN',
732: application=>application_name,
733: sequence=>1,
734: parameter=>'SECTION_NAME',
735: description=>'SECTION NAME',

Line 741: fnd_program.parameter(program_short_name=>'CZREPIN',

737: display_size=>20,
738: description_size=>20,
739: concatenated_description_size=>50,
740: prompt=>'SECTION_NAME');
741: fnd_program.parameter(program_short_name=>'CZREPIN',
742: application=>application_name,
743: sequence=>2,
744: parameter=>'SETTING_ID',
745: description=>'SETTING_ID',

Line 751: fnd_program.parameter(program_short_name=>'CZREPIN',

747: display_size=>20,
748: description_size=>20,
749: concatenated_description_size=>50,
750: prompt=>'SETTING_ID');
751: fnd_program.parameter(program_short_name=>'CZREPIN',
752: application=>application_name,
753: sequence=>3,
754: parameter=>'VALUE',
755: description=>'VALUE',

Line 761: fnd_program.parameter(program_short_name=>'CZREPIN',

757: display_size=>20,
758: description_size=>20,
759: concatenated_description_size=>50,
760: prompt=>'VALUE');
761: fnd_program.parameter(program_short_name=>'CZREPIN',
762: application=>application_name,
763: sequence=>4,
764: parameter=>'TYPE',
765: description=>'TYPE',

Line 771: fnd_program.parameter(program_short_name=>'CZREPIN',

767: display_size=>20,
768: description_size=>20,
769: concatenated_description_size=>50,
770: prompt=>'TYPE');
771: fnd_program.parameter(program_short_name=>'CZREPIN',
772: application=>application_name,
773: sequence=>5,
774: parameter=>'DESCRIPTION',
775: description=>'DESCRIPTION',

Line 796: fnd_program.parameter(program_short_name=>'CZREPGIMP',

792: 'CZ_ORAAPPS_INTEGRATE.GETTABLEIMPORT',
793: request_group,
794: cz_schema);
795:
796: fnd_program.parameter(program_short_name=>'CZREPGIMP',
797: application=>application_name,
798: sequence=>1,
799: parameter=>'LIKE_DST_TABLE_NAME',
800: description=>'TABLE_NAME',

Line 808: fnd_program.parameter(program_short_name=>'CZREPGIMP',

804: display_size=>20,
805: description_size=>20,
806: concatenated_description_size=>20,
807: prompt=>'TABLE NAME');
808: fnd_program.parameter(program_short_name=>'CZREPGIMP',
809: application=>application_name,
810: sequence=>2,
811: parameter=>'IMPORT_GROUP',
812: description=>'Import Group',

Line 834: fnd_program.parameter(program_short_name=>'CZREPSIMP',

830: 'CZ_ORAAPPS_INTEGRATE.SETTABLEIMPORT',
831: request_group,
832: cz_schema);
833:
834: fnd_program.parameter(program_short_name=>'CZREPSIMP',
835: application=>application_name,
836: sequence=>1,
837: parameter=>'DST_TABLE_NAME',
838: description=>'DST_TABLE_NAME',

Line 844: fnd_program.parameter(program_short_name=>'CZREPSIMP',

840: display_size=>20,
841: description_size=>20,
842: concatenated_description_size=>50,
843: prompt=>'Destination Table Name');
844: fnd_program.parameter(program_short_name=>'CZREPSIMP',
845: application=>application_name,
846: sequence=>2,
847: parameter=>'IMPORT_GROUP',
848: description=>'Import Group',

Line 854: fnd_program.parameter(program_short_name=>'CZREPSIMP',

850: display_size=>20,
851: description_size=>20,
852: concatenated_description_size=>50,
853: prompt=>'Import Group');
854: fnd_program.parameter(program_short_name=>'CZREPSIMP',
855: application=>application_name,
856: sequence=>3,
857: parameter=>'ENABLEIMPORT',
858: description=>'Enable Import',

Line 892: fnd_program.parameter(program_short_name=>'CZPUBLISHSINGLE',

888: 'Export a Single Publication',
889: 'CZ_PB_MGR.publish_single_model_cp',
890: request_group,
891: cz_schema);
892: fnd_program.parameter(program_short_name=>'CZPUBLISHSINGLE',
893: application=>application_name,
894: sequence=>1,
895: parameter=>'PublicationId',
896: description=>'Publication',

Line 918: fnd_program.delete_program('SPREPGS',application_name);

914: (application_name IN VARCHAR2 -- default 'System Administration'
915: ) AS
916: BEGIN
917: BEGIN
918: fnd_program.delete_program('SPREPGS',application_name);
919: fnd_program.delete_executable('SPREPGS',application_name);
920: EXCEPTION
921: WHEN NO_DATA_FOUND THEN
922: LOG_REPORT('Error : < SPREPGS > does not exist.');

Line 919: fnd_program.delete_executable('SPREPGS',application_name);

915: ) AS
916: BEGIN
917: BEGIN
918: fnd_program.delete_program('SPREPGS',application_name);
919: fnd_program.delete_executable('SPREPGS',application_name);
920: EXCEPTION
921: WHEN NO_DATA_FOUND THEN
922: LOG_REPORT('Error : < SPREPGS > does not exist.');
923: WHEN OTHERS THEN

Line 928: fnd_program.delete_program('SPREPIN',application_name);

924: LOG_REPORT('Error : < SPREPGS > :'||SQLERRM);
925: END;
926:
927: BEGIN
928: fnd_program.delete_program('SPREPIN',application_name);
929: fnd_program.delete_executable('SPREPIN',application_name);
930: EXCEPTION
931: WHEN NO_DATA_FOUND THEN
932: LOG_REPORT('Error : < SPREPIN > does not exist.');

Line 929: fnd_program.delete_executable('SPREPIN',application_name);

925: END;
926:
927: BEGIN
928: fnd_program.delete_program('SPREPIN',application_name);
929: fnd_program.delete_executable('SPREPIN',application_name);
930: EXCEPTION
931: WHEN NO_DATA_FOUND THEN
932: LOG_REPORT('Error : < SPREPIN > does not exist.');
933: WHEN OTHERS THEN

Line 938: fnd_program.delete_program('SPREPGIMP',application_name);

934: LOG_REPORT('Error : < SPREPIN > :'||SQLERRM);
935: END;
936:
937: BEGIN
938: fnd_program.delete_program('SPREPGIMP',application_name);
939: fnd_program.delete_executable('SPREPGIMP',application_name);
940: EXCEPTION
941: WHEN NO_DATA_FOUND THEN
942: LOG_REPORT('Error : < SPREPGIMP > does not exist.');

Line 939: fnd_program.delete_executable('SPREPGIMP',application_name);

935: END;
936:
937: BEGIN
938: fnd_program.delete_program('SPREPGIMP',application_name);
939: fnd_program.delete_executable('SPREPGIMP',application_name);
940: EXCEPTION
941: WHEN NO_DATA_FOUND THEN
942: LOG_REPORT('Error : < SPREPGIMP > does not exist.');
943: WHEN OTHERS THEN

Line 948: fnd_program.delete_program('SPREPSIMP',application_name);

944: LOG_REPORT('Error : < SPREPGIMP > :'||SQLERRM);
945: END;
946:
947: BEGIN
948: fnd_program.delete_program('SPREPSIMP',application_name);
949: fnd_program.delete_executable('SPREPSIMP',application_name);
950: EXCEPTION
951: WHEN NO_DATA_FOUND THEN
952: LOG_REPORT('Error : < SPREPSIMP > does not exist.');

Line 949: fnd_program.delete_executable('SPREPSIMP',application_name);

945: END;
946:
947: BEGIN
948: fnd_program.delete_program('SPREPSIMP',application_name);
949: fnd_program.delete_executable('SPREPSIMP',application_name);
950: EXCEPTION
951: WHEN NO_DATA_FOUND THEN
952: LOG_REPORT('Error : < SPREPSIMP > does not exist.');
953: WHEN OTHERS THEN

Line 958: fnd_program.delete_program('SPCREATELNK',application_name);

954: LOG_REPORT('Error : < SPREPSIMP > :'||SQLERRM);
955: END;
956:
957: BEGIN
958: fnd_program.delete_program('SPCREATELNK',application_name);
959: fnd_program.delete_executable('SPCREATELNK',application_name);
960: EXCEPTION
961: WHEN NO_DATA_FOUND THEN
962: LOG_REPORT('Error : < SPCREATELNK > does not exist.');

Line 959: fnd_program.delete_executable('SPCREATELNK',application_name);

955: END;
956:
957: BEGIN
958: fnd_program.delete_program('SPCREATELNK',application_name);
959: fnd_program.delete_executable('SPCREATELNK',application_name);
960: EXCEPTION
961: WHEN NO_DATA_FOUND THEN
962: LOG_REPORT('Error : < SPCREATELNK > does not exist.');
963: WHEN OTHERS THEN

Line 968: fnd_program.delete_program('SPPUBLISHMODEL',application_name);

964: LOG_REPORT('Error : < SPCREATELNK > :'||SQLERRM);
965: END;
966:
967: BEGIN
968: fnd_program.delete_program('SPPUBLISHMODEL',application_name);
969: fnd_program.delete_executable('SPPUBLISHMODEL',application_name);
970: EXCEPTION
971: WHEN NO_DATA_FOUND THEN
972: LOG_REPORT('Error : < SPPUBLISHMODEL > does not exist.');

Line 969: fnd_program.delete_executable('SPPUBLISHMODEL',application_name);

965: END;
966:
967: BEGIN
968: fnd_program.delete_program('SPPUBLISHMODEL',application_name);
969: fnd_program.delete_executable('SPPUBLISHMODEL',application_name);
970: EXCEPTION
971: WHEN NO_DATA_FOUND THEN
972: LOG_REPORT('Error : < SPPUBLISHMODEL > does not exist.');
973: WHEN OTHERS THEN

Line 978: fnd_program.delete_program('SPPOPULATESRV',application_name);

974: LOG_REPORT('Error : < SPPUBLISHMODEL > :'||SQLERRM);
975: END;
976:
977: BEGIN
978: fnd_program.delete_program('SPPOPULATESRV',application_name);
979: fnd_program.delete_executable('SPPOPULATESRV',application_name);
980: EXCEPTION
981: WHEN NO_DATA_FOUND THEN
982: LOG_REPORT('Error : < SPPOPULATESRV > does not exist.');

Line 979: fnd_program.delete_executable('SPPOPULATESRV',application_name);

975: END;
976:
977: BEGIN
978: fnd_program.delete_program('SPPOPULATESRV',application_name);
979: fnd_program.delete_executable('SPPOPULATESRV',application_name);
980: EXCEPTION
981: WHEN NO_DATA_FOUND THEN
982: LOG_REPORT('Error : < SPPOPULATESRV > does not exist.');
983: WHEN OTHERS THEN

Line 1002: fnd_program.delete_program('SPOEEXP',application_name);

998: ) AS
999: ar_application_name VARCHAR2(50):='Oracle Receivables';
1000: BEGIN
1001: BEGIN
1002: fnd_program.delete_program('SPOEEXP',application_name);
1003: fnd_program.delete_executable('SPOEEXP',application_name);
1004: EXCEPTION
1005: WHEN NO_DATA_FOUND THEN
1006: LOG_REPORT('Error : < SPOEEXP > does not exist.');

Line 1003: fnd_program.delete_executable('SPOEEXP',application_name);

999: ar_application_name VARCHAR2(50):='Oracle Receivables';
1000: BEGIN
1001: BEGIN
1002: fnd_program.delete_program('SPOEEXP',application_name);
1003: fnd_program.delete_executable('SPOEEXP',application_name);
1004: EXCEPTION
1005: WHEN NO_DATA_FOUND THEN
1006: LOG_REPORT('Error : < SPOEEXP > does not exist.');
1007: WHEN OTHERS THEN

Line 1012: fnd_program.delete_program('SPOEEXPUS',application_name);

1008: LOG_REPORT('Error : < SPOEEXP > :'||SQLERRM);
1009: END;
1010:
1011: BEGIN
1012: fnd_program.delete_program('SPOEEXPUS',application_name);
1013: fnd_program.delete_executable('SPOEEXPUS',application_name);
1014: EXCEPTION
1015: WHEN NO_DATA_FOUND THEN
1016: LOG_REPORT('Error : < SPOEEXPUS > does not exist.');

Line 1013: fnd_program.delete_executable('SPOEEXPUS',application_name);

1009: END;
1010:
1011: BEGIN
1012: fnd_program.delete_program('SPOEEXPUS',application_name);
1013: fnd_program.delete_executable('SPOEEXPUS',application_name);
1014: EXCEPTION
1015: WHEN NO_DATA_FOUND THEN
1016: LOG_REPORT('Error : < SPOEEXPUS > does not exist.');
1017: WHEN OTHERS THEN

Line 1024: fnd_program.delete_program('SPAREXP',ar_application_name);

1020:
1021:
1022: /*
1023: BEGIN
1024: fnd_program.delete_program('SPAREXP',ar_application_name);
1025: fnd_program.delete_executable('SPAREXP',ar_application_name);
1026: EXCEPTION
1027: WHEN NO_DATA_FOUND THEN
1028: LOG_REPORT('Error : < SPAREXP > does not exist.');

Line 1025: fnd_program.delete_executable('SPAREXP',ar_application_name);

1021:
1022: /*
1023: BEGIN
1024: fnd_program.delete_program('SPAREXP',ar_application_name);
1025: fnd_program.delete_executable('SPAREXP',ar_application_name);
1026: EXCEPTION
1027: WHEN NO_DATA_FOUND THEN
1028: LOG_REPORT('Error : < SPAREXP > does not exist.');
1029: WHEN OTHERS THEN

Line 1034: fnd_program.delete_program('SPAREXPUS',ar_application_name);

1030: LOG_REPORT('Error : < SPAREXP > :'||SQLERRM);
1031: END;
1032:
1033: BEGIN
1034: fnd_program.delete_program('SPAREXPUS',ar_application_name);
1035: fnd_program.delete_executable('SPAREXPUS',ar_application_name);
1036: EXCEPTION
1037: WHEN NO_DATA_FOUND THEN
1038: LOG_REPORT('Error : < SPAREXPUS > does not exist.');

Line 1035: fnd_program.delete_executable('SPAREXPUS',ar_application_name);

1031: END;
1032:
1033: BEGIN
1034: fnd_program.delete_program('SPAREXPUS',ar_application_name);
1035: fnd_program.delete_executable('SPAREXPUS',ar_application_name);
1036: EXCEPTION
1037: WHEN NO_DATA_FOUND THEN
1038: LOG_REPORT('Error : < SPAREXPUS > does not exist.');
1039: WHEN OTHERS THEN

Line 1044: fnd_program.delete_program('SPAREXPSC',ar_application_name);

1040: LOG_REPORT('Error : < SPAREXPUS > :'||SQLERRM);
1041: END;
1042:
1043: BEGIN
1044: fnd_program.delete_program('SPAREXPSC',ar_application_name);
1045: fnd_program.delete_executable('SPAREXPSC',ar_application_name);
1046: EXCEPTION
1047: WHEN NO_DATA_FOUND THEN
1048: LOG_REPORT('Error : < SPAREXPSC > does not exist.');

Line 1045: fnd_program.delete_executable('SPAREXPSC',ar_application_name);

1041: END;
1042:
1043: BEGIN
1044: fnd_program.delete_program('SPAREXPSC',ar_application_name);
1045: fnd_program.delete_executable('SPAREXPSC',ar_application_name);
1046: EXCEPTION
1047: WHEN NO_DATA_FOUND THEN
1048: LOG_REPORT('Error : < SPAREXPSC > does not exist.');
1049: WHEN OTHERS THEN

Line 1054: fnd_program.delete_program('SPOEEXPSO',application_name);

1050: LOG_REPORT('Error : < SPAREXPSC > :'||SQLERRM);
1051: END;
1052:
1053: BEGIN
1054: fnd_program.delete_program('SPOEEXPSO',application_name);
1055: fnd_program.delete_executable('SPOEEXPSO',application_name);
1056: EXCEPTION
1057: WHEN NO_DATA_FOUND THEN
1058: LOG_REPORT('Error : < SPOEEXPSO > does not exist.');

Line 1055: fnd_program.delete_executable('SPOEEXPSO',application_name);

1051: END;
1052:
1053: BEGIN
1054: fnd_program.delete_program('SPOEEXPSO',application_name);
1055: fnd_program.delete_executable('SPOEEXPSO',application_name);
1056: EXCEPTION
1057: WHEN NO_DATA_FOUND THEN
1058: LOG_REPORT('Error : < SPOEEXPSO > does not exist.');
1059: WHEN OTHERS THEN

Line 1077: fnd_program.delete_program('SPAPPIMP','System Administration');

1073: (application_name IN VARCHAR2 -- default 'Oracle Bills of Material'
1074: ) AS
1075: BEGIN
1076: BEGIN
1077: fnd_program.delete_program('SPAPPIMP','System Administration');
1078: fnd_program.delete_executable('SPAPPIMP','System Administrationdel');
1079: EXCEPTION
1080: WHEN NO_DATA_FOUND THEN
1081: LOG_REPORT('Error : < SPAPPIMP > does not exist.');

Line 1078: fnd_program.delete_executable('SPAPPIMP','System Administrationdel');

1074: ) AS
1075: BEGIN
1076: BEGIN
1077: fnd_program.delete_program('SPAPPIMP','System Administration');
1078: fnd_program.delete_executable('SPAPPIMP','System Administrationdel');
1079: EXCEPTION
1080: WHEN NO_DATA_FOUND THEN
1081: LOG_REPORT('Error : < SPAPPIMP > does not exist.');
1082: WHEN OTHERS THEN

Line 1086: fnd_program.delete_program('SPAPPIMPPCM',application_name);

1082: WHEN OTHERS THEN
1083: LOG_REPORT('Error : < SPAPPIMP > :'||SQLERRM);
1084: END;
1085: BEGIN
1086: fnd_program.delete_program('SPAPPIMPPCM',application_name);
1087: fnd_program.delete_executable('SPAPPIMPPCM',application_name);
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND THEN
1090: LOG_REPORT('Error : < SPAPPIMPPCM > does not exist.');

Line 1087: fnd_program.delete_executable('SPAPPIMPPCM',application_name);

1083: LOG_REPORT('Error : < SPAPPIMP > :'||SQLERRM);
1084: END;
1085: BEGIN
1086: fnd_program.delete_program('SPAPPIMPPCM',application_name);
1087: fnd_program.delete_executable('SPAPPIMPPCM',application_name);
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND THEN
1090: LOG_REPORT('Error : < SPAPPIMPPCM > does not exist.');
1091: WHEN OTHERS THEN

Line 1096: fnd_program.delete_program('SPAPPIMPRFCM',application_name);

1092: LOG_REPORT('Error : < SPAPPIMPPCM > :'||SQLERRM);
1093: END;
1094:
1095: BEGIN
1096: fnd_program.delete_program('SPAPPIMPRFCM',application_name);
1097: fnd_program.delete_executable('SPAPPIMPRFCM',application_name);
1098: EXCEPTION
1099: WHEN NO_DATA_FOUND THEN
1100: LOG_REPORT('Error : < SPAPPIMPRFCM > does not exist.');

Line 1097: fnd_program.delete_executable('SPAPPIMPRFCM',application_name);

1093: END;
1094:
1095: BEGIN
1096: fnd_program.delete_program('SPAPPIMPRFCM',application_name);
1097: fnd_program.delete_executable('SPAPPIMPRFCM',application_name);
1098: EXCEPTION
1099: WHEN NO_DATA_FOUND THEN
1100: LOG_REPORT('Error : < SPAPPIMPRFCM > does not exist.');
1101: WHEN OTHERS THEN

Line 1106: fnd_program.delete_program('SPAPPIMPRMCM',application_name);

1102: LOG_REPORT('Error : < SPAPPIMPRFCM > :'||SQLERRM);
1103: END;
1104:
1105: BEGIN
1106: fnd_program.delete_program('SPAPPIMPRMCM',application_name);
1107: fnd_program.delete_executable('SPAPPIMPRMCM',application_name);
1108: EXCEPTION
1109: WHEN NO_DATA_FOUND THEN
1110: LOG_REPORT('Error : < SPAPPIMPRMCM > does not exist.');

Line 1107: fnd_program.delete_executable('SPAPPIMPRMCM',application_name);

1103: END;
1104:
1105: BEGIN
1106: fnd_program.delete_program('SPAPPIMPRMCM',application_name);
1107: fnd_program.delete_executable('SPAPPIMPRMCM',application_name);
1108: EXCEPTION
1109: WHEN NO_DATA_FOUND THEN
1110: LOG_REPORT('Error : < SPAPPIMPRMCM > does not exist.');
1111: WHEN OTHERS THEN

Line 2819: fnd_program.parameter(program_short_name=>'CZCREATELNK',

2815: 'Enable Remote Server for Configurator',
2816: 'CZ_ORAAPPS_INTEGRATE.CREATE_LINK_CP',
2817: request_group,
2818: cz_schema);
2819: fnd_program.parameter(program_short_name=>'CZCREATELNK',
2820: application=>application_name,
2821: sequence=>1,
2822: parameter=>'LOCAL_NAME',
2823: description=>'Local Name',

Line 2829: fnd_program.parameter(program_short_name=>'CZCREATELNK',

2825: display_size=>20,
2826: description_size=>20,
2827: concatenated_description_size=>50,
2828: prompt=>'Server Local name');
2829: fnd_program.parameter(program_short_name=>'CZCREATELNK',
2830: application=>application_name,
2831: sequence=>1,
2832: parameter=>'PASSWORD',
2833: description=>'Password',

Line 2854: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',

2850: 'Define Remote Server',
2851: 'CZ_ORAAPPS_INTEGRATE.POPULATE_CZ_SERVER_CP',
2852: request_group,
2853: cz_schema);
2854: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',
2855: application=>application_name,
2856: sequence=>1,
2857: parameter=>'LOCAL_NAME',
2858: description=>'Local Name',

Line 2864: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',

2860: display_size=>20,
2861: description_size=>20,
2862: concatenated_description_size=>50,
2863: prompt=>'Local name');
2864: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',
2865: application=>application_name,
2866: sequence=>2,
2867: parameter=>'HOSTNAME',
2868: description=>'Host Name',

Line 2874: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',

2870: display_size=>20,
2871: description_size=>20,
2872: concatenated_description_size=>50,
2873: prompt=>'Host name');
2874: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',
2875: application=>application_name,
2876: sequence=>3,
2877: parameter=>'DB_LISTENER_PORT',
2878: description=>'DB Listener Port',

Line 2884: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',

2880: display_size=>10,
2881: description_size=>10,
2882: concatenated_description_size=>10,
2883: prompt=>'DB Listener Port');
2884: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',
2885: application=>application_name,
2886: sequence=>4,
2887: parameter=>'INSTANCE_NAME',
2888: description=>'Instance Name',

Line 2894: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',

2890: display_size=>20,
2891: description_size=>20,
2892: concatenated_description_size=>50,
2893: prompt=>'Instance name');
2894: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',
2895: application=>application_name,
2896: sequence=>5,
2897: parameter=>'FNDNAM',
2898: description=>'FND Name',

Line 2904: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',

2900: display_size=>20,
2901: description_size=>20,
2902: concatenated_description_size=>50,
2903: prompt=>'Oracle Applications Schema Name (FNDNAM)');
2904: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',
2905: application=>application_name,
2906: sequence=>6,
2907: parameter=>'GLOBAL_IDENTITY',
2908: description=>'Global Identity',

Line 2914: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',

2910: display_size=>20,
2911: description_size=>20,
2912: concatenated_description_size=>50,
2913: prompt=>'Global Identity');
2914: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',
2915: application=>application_name,
2916: sequence=>7,
2917: parameter=>'NOTES',
2918: description=>'Notes',

Line 2924: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',

2920: display_size=>50,
2921: description_size=>50,
2922: concatenated_description_size=>50,
2923: prompt=>'Description');
2924: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',
2925: application=>application_name,
2926: sequence=>8,
2927: parameter=>'FND_LINK_NAME',
2928: description=>'FND Link Name',

Line 2934: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',

2930: display_size=>20,
2931: description_size=>20,
2932: concatenated_description_size=>50,
2933: prompt=>'FND Link Name');
2934: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',
2935: application=>application_name,
2936: sequence=>9,
2937: parameter=>'IMPORT_ENABLED',
2938: description=>'Import Enabled',

Line 2959: fnd_program.parameter(program_short_name=>'CZALTERSERVER',

2955: 'CZ_ORAAPPS_INTEGRATE.ALTER_CZ_SERVER_CP',
2956: request_group,
2957: cz_schema);
2958:
2959: fnd_program.parameter(program_short_name=>'CZALTERSERVER',
2960: application=>application_name,
2961: sequence=>1,
2962: parameter=>'LOCAL_NAME',
2963: description=>'Local Name',

Line 2969: fnd_program.parameter(program_short_name=>'CZALTERSERVER',

2965: display_size=>20,
2966: description_size=>20,
2967: concatenated_description_size=>50,
2968: prompt=>'Local name');
2969: fnd_program.parameter(program_short_name=>'CZALTERSERVER',
2970: application=>application_name,
2971: sequence=>2,
2972: parameter=>'HOSTNAME',
2973: description=>'Host Name',

Line 2979: fnd_program.parameter(program_short_name=>'CZALTERSERVER',

2975: display_size=>20,
2976: description_size=>20,
2977: concatenated_description_size=>50,
2978: prompt=>'Host name');
2979: fnd_program.parameter(program_short_name=>'CZALTERSERVER',
2980: application=>application_name,
2981: sequence=>3,
2982: parameter=>'DB_LISTENER_PORT',
2983: description=>'DB Listener Port',

Line 2989: fnd_program.parameter(program_short_name=>'CZALTERSERVER',

2985: display_size=>10,
2986: description_size=>10,
2987: concatenated_description_size=>10,
2988: prompt=>'DB Listener Port');
2989: fnd_program.parameter(program_short_name=>'CZALTERSERVER',
2990: application=>application_name,
2991: sequence=>4,
2992: parameter=>'INSTANCE_NAME',
2993: description=>'Instance Name',

Line 2999: fnd_program.parameter(program_short_name=>'CZALTERSERVER',

2995: display_size=>20,
2996: description_size=>20,
2997: concatenated_description_size=>50,
2998: prompt=>'Instance name');
2999: fnd_program.parameter(program_short_name=>'CZALTERSERVER',
3000: application=>application_name,
3001: sequence=>5,
3002: parameter=>'FNDNAM',
3003: description=>'FND Name',

Line 3009: fnd_program.parameter(program_short_name=>'CZALTERSERVER',

3005: display_size=>20,
3006: description_size=>20,
3007: concatenated_description_size=>50,
3008: prompt=>'Oracle Applications Schema Name (FNDNAM)');
3009: fnd_program.parameter(program_short_name=>'CZALTERSERVER',
3010: application=>application_name,
3011: sequence=>6,
3012: parameter=>'GLOBAL_IDENTITY',
3013: description=>'Global Identity',

Line 3019: fnd_program.parameter(program_short_name=>'CZALTERSERVER',

3015: display_size=>20,
3016: description_size=>20,
3017: concatenated_description_size=>50,
3018: prompt=>'Global Identity');
3019: fnd_program.parameter(program_short_name=>'CZALTERSERVER',
3020: application=>application_name,
3021: sequence=>7,
3022: parameter=>'NOTES',
3023: description=>'Notes',

Line 3029: fnd_program.parameter(program_short_name=>'CZALTERSERVER',

3025: display_size=>50,
3026: description_size=>50,
3027: concatenated_description_size=>50,
3028: prompt=>'Description');
3029: fnd_program.parameter(program_short_name=>'CZALTERSERVER',
3030: application=>application_name,
3031: sequence=>8,
3032: parameter=>'FND_LINK_NAME',
3033: description=>'FND Link Name',

Line 3039: fnd_program.parameter(program_short_name=>'CZALTERSERVER',

3035: display_size=>20,
3036: description_size=>20,
3037: concatenated_description_size=>50,
3038: prompt=>'FND Link Name');
3039: fnd_program.parameter(program_short_name=>'CZALTERSERVER',
3040: application=>application_name,
3041: sequence=>9,
3042: parameter=>'IMPORT_ENABLED',
3043: description=>'Import Enabled',