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.AS_OPPORTUNITY_PUB_W3 dependencies on AS_OPPORTUNITY_PUB

Line 1: package body as_opportunity_pub_w3 as

1: package body as_opportunity_pub_w3 as
2: /* $Header: asxwop3b.pls 120.1 2005/08/04 03:06 appldev ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 80: ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;

76: , x_msg_data out nocopy VARCHAR2
77: )
78:
79: as
80: ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;
81: ddp_profile_tbl as_utility_pub.profile_tbl_type;
82: ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;
83: ddindx binary_integer; indx binary_integer;
84: begin

Line 82: ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;

78:
79: as
80: ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;
81: ddp_profile_tbl as_utility_pub.profile_tbl_type;
82: ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;
83: ddindx binary_integer; indx binary_integer;
84: begin
85:
86: -- copy data to the local IN or IN-OUT args, if any

Line 92: as_opportunity_pub_w.rosetta_table_copy_in_p26(ddp_competitor_tbl, p5_a0

88:
89:
90:
91:
92: as_opportunity_pub_w.rosetta_table_copy_in_p26(ddp_competitor_tbl, p5_a0
93: , p5_a1
94: , p5_a2
95: , p5_a3
96: , p5_a4

Line 146: as_opportunity_pub.update_competitors(p_api_version_number,

142:
143:
144:
145: -- here's the delegated call to the old PL/SQL routine
146: as_opportunity_pub.update_competitors(p_api_version_number,
147: p_init_msg_list,
148: p_commit,
149: p_validation_level,
150: p_identity_salesforce_id,

Line 174: as_opportunity_pub_w.rosetta_table_copy_out_p29(ddx_competitor_out_tbl, p11_a0

170:
171:
172:
173:
174: as_opportunity_pub_w.rosetta_table_copy_out_p29(ddx_competitor_out_tbl, p11_a0
175: , p11_a1
176: );
177:
178:

Line 240: ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;

236: , x_msg_data out nocopy VARCHAR2
237: )
238:
239: as
240: ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;
241: ddp_profile_tbl as_utility_pub.profile_tbl_type;
242: ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;
243: ddindx binary_integer; indx binary_integer;
244: begin

Line 242: ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;

238:
239: as
240: ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;
241: ddp_profile_tbl as_utility_pub.profile_tbl_type;
242: ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;
243: ddindx binary_integer; indx binary_integer;
244: begin
245:
246: -- copy data to the local IN or IN-OUT args, if any

Line 252: as_opportunity_pub_w.rosetta_table_copy_in_p26(ddp_competitor_tbl, p5_a0

248:
249:
250:
251:
252: as_opportunity_pub_w.rosetta_table_copy_in_p26(ddp_competitor_tbl, p5_a0
253: , p5_a1
254: , p5_a2
255: , p5_a3
256: , p5_a4

Line 306: as_opportunity_pub.delete_competitors(p_api_version_number,

302:
303:
304:
305: -- here's the delegated call to the old PL/SQL routine
306: as_opportunity_pub.delete_competitors(p_api_version_number,
307: p_init_msg_list,
308: p_commit,
309: p_validation_level,
310: p_identity_salesforce_id,

Line 334: as_opportunity_pub_w.rosetta_table_copy_out_p29(ddx_competitor_out_tbl, p11_a0

330:
331:
332:
333:
334: as_opportunity_pub_w.rosetta_table_copy_out_p29(ddx_competitor_out_tbl, p11_a0
335: , p11_a1
336: );
337:
338:

Line 391: ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;

387: , x_msg_data out nocopy VARCHAR2
388: )
389:
390: as
391: ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;
392: ddp_profile_tbl as_utility_pub.profile_tbl_type;
393: ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;
394: ddindx binary_integer; indx binary_integer;
395: begin

Line 393: ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;

389:
390: as
391: ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;
392: ddp_profile_tbl as_utility_pub.profile_tbl_type;
393: ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;
394: ddindx binary_integer; indx binary_integer;
395: begin
396:
397: -- copy data to the local IN or IN-OUT args, if any

Line 403: as_opportunity_pub_w.rosetta_table_copy_in_p44(ddp_competitor_prod_tbl, p5_a0

399:
400:
401:
402:
403: as_opportunity_pub_w.rosetta_table_copy_in_p44(ddp_competitor_prod_tbl, p5_a0
404: , p5_a1
405: , p5_a2
406: , p5_a3
407: , p5_a4

Line 448: as_opportunity_pub.create_competitor_prods(p_api_version_number,

444:
445:
446:
447: -- here's the delegated call to the old PL/SQL routine
448: as_opportunity_pub.create_competitor_prods(p_api_version_number,
449: p_init_msg_list,
450: p_commit,
451: p_validation_level,
452: p_identity_salesforce_id,

Line 476: as_opportunity_pub_w.rosetta_table_copy_out_p47(ddx_competitor_prod_out_tbl, p11_a0

472:
473:
474:
475:
476: as_opportunity_pub_w.rosetta_table_copy_out_p47(ddx_competitor_prod_out_tbl, p11_a0
477: , p11_a1
478: );
479:
480:

Line 533: ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;

529: , x_msg_data out nocopy VARCHAR2
530: )
531:
532: as
533: ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;
534: ddp_profile_tbl as_utility_pub.profile_tbl_type;
535: ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;
536: ddindx binary_integer; indx binary_integer;
537: begin

Line 535: ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;

531:
532: as
533: ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;
534: ddp_profile_tbl as_utility_pub.profile_tbl_type;
535: ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;
536: ddindx binary_integer; indx binary_integer;
537: begin
538:
539: -- copy data to the local IN or IN-OUT args, if any

Line 545: as_opportunity_pub_w.rosetta_table_copy_in_p44(ddp_competitor_prod_tbl, p5_a0

541:
542:
543:
544:
545: as_opportunity_pub_w.rosetta_table_copy_in_p44(ddp_competitor_prod_tbl, p5_a0
546: , p5_a1
547: , p5_a2
548: , p5_a3
549: , p5_a4

Line 590: as_opportunity_pub.update_competitor_prods(p_api_version_number,

586:
587:
588:
589: -- here's the delegated call to the old PL/SQL routine
590: as_opportunity_pub.update_competitor_prods(p_api_version_number,
591: p_init_msg_list,
592: p_commit,
593: p_validation_level,
594: p_identity_salesforce_id,

Line 618: as_opportunity_pub_w.rosetta_table_copy_out_p47(ddx_competitor_prod_out_tbl, p11_a0

614:
615:
616:
617:
618: as_opportunity_pub_w.rosetta_table_copy_out_p47(ddx_competitor_prod_out_tbl, p11_a0
619: , p11_a1
620: );
621:
622:

Line 675: ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;

671: , x_msg_data out nocopy VARCHAR2
672: )
673:
674: as
675: ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;
676: ddp_profile_tbl as_utility_pub.profile_tbl_type;
677: ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;
678: ddindx binary_integer; indx binary_integer;
679: begin

Line 677: ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;

673:
674: as
675: ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;
676: ddp_profile_tbl as_utility_pub.profile_tbl_type;
677: ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;
678: ddindx binary_integer; indx binary_integer;
679: begin
680:
681: -- copy data to the local IN or IN-OUT args, if any

Line 687: as_opportunity_pub_w.rosetta_table_copy_in_p44(ddp_competitor_prod_tbl, p5_a0

683:
684:
685:
686:
687: as_opportunity_pub_w.rosetta_table_copy_in_p44(ddp_competitor_prod_tbl, p5_a0
688: , p5_a1
689: , p5_a2
690: , p5_a3
691: , p5_a4

Line 732: as_opportunity_pub.delete_competitor_prods(p_api_version_number,

728:
729:
730:
731: -- here's the delegated call to the old PL/SQL routine
732: as_opportunity_pub.delete_competitor_prods(p_api_version_number,
733: p_init_msg_list,
734: p_commit,
735: p_validation_level,
736: p_identity_salesforce_id,

Line 760: as_opportunity_pub_w.rosetta_table_copy_out_p47(ddx_competitor_prod_out_tbl, p11_a0

756:
757:
758:
759:
760: as_opportunity_pub_w.rosetta_table_copy_out_p47(ddx_competitor_prod_out_tbl, p11_a0
761: , p11_a1
762: );
763:
764:

Line 817: ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;

813: , x_msg_data out nocopy VARCHAR2
814: )
815:
816: as
817: ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;
818: ddp_profile_tbl as_utility_pub.profile_tbl_type;
819: ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;
820: ddindx binary_integer; indx binary_integer;
821: begin

Line 819: ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;

815:
816: as
817: ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;
818: ddp_profile_tbl as_utility_pub.profile_tbl_type;
819: ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;
820: ddindx binary_integer; indx binary_integer;
821: begin
822:
823: -- copy data to the local IN or IN-OUT args, if any

Line 829: as_opportunity_pub_w.rosetta_table_copy_in_p50(ddp_decision_factor_tbl, p5_a0

825:
826:
827:
828:
829: as_opportunity_pub_w.rosetta_table_copy_in_p50(ddp_decision_factor_tbl, p5_a0
830: , p5_a1
831: , p5_a2
832: , p5_a3
833: , p5_a4

Line 874: as_opportunity_pub.create_decision_factors(p_api_version_number,

870:
871:
872:
873: -- here's the delegated call to the old PL/SQL routine
874: as_opportunity_pub.create_decision_factors(p_api_version_number,
875: p_init_msg_list,
876: p_commit,
877: p_validation_level,
878: p_identity_salesforce_id,

Line 902: as_opportunity_pub_w.rosetta_table_copy_out_p53(ddx_decision_factor_out_tbl, p11_a0

898:
899:
900:
901:
902: as_opportunity_pub_w.rosetta_table_copy_out_p53(ddx_decision_factor_out_tbl, p11_a0
903: , p11_a1
904: );
905:
906:

Line 959: ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;

955: , x_msg_data out nocopy VARCHAR2
956: )
957:
958: as
959: ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;
960: ddp_profile_tbl as_utility_pub.profile_tbl_type;
961: ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;
962: ddindx binary_integer; indx binary_integer;
963: begin

Line 961: ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;

957:
958: as
959: ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;
960: ddp_profile_tbl as_utility_pub.profile_tbl_type;
961: ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;
962: ddindx binary_integer; indx binary_integer;
963: begin
964:
965: -- copy data to the local IN or IN-OUT args, if any

Line 971: as_opportunity_pub_w.rosetta_table_copy_in_p50(ddp_decision_factor_tbl, p5_a0

967:
968:
969:
970:
971: as_opportunity_pub_w.rosetta_table_copy_in_p50(ddp_decision_factor_tbl, p5_a0
972: , p5_a1
973: , p5_a2
974: , p5_a3
975: , p5_a4

Line 1016: as_opportunity_pub.update_decision_factors(p_api_version_number,

1012:
1013:
1014:
1015: -- here's the delegated call to the old PL/SQL routine
1016: as_opportunity_pub.update_decision_factors(p_api_version_number,
1017: p_init_msg_list,
1018: p_commit,
1019: p_validation_level,
1020: p_identity_salesforce_id,

Line 1044: as_opportunity_pub_w.rosetta_table_copy_out_p53(ddx_decision_factor_out_tbl, p11_a0

1040:
1041:
1042:
1043:
1044: as_opportunity_pub_w.rosetta_table_copy_out_p53(ddx_decision_factor_out_tbl, p11_a0
1045: , p11_a1
1046: );
1047:
1048:

Line 1101: ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;

1097: , x_msg_data out nocopy VARCHAR2
1098: )
1099:
1100: as
1101: ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;
1102: ddp_profile_tbl as_utility_pub.profile_tbl_type;
1103: ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;
1104: ddindx binary_integer; indx binary_integer;
1105: begin

Line 1103: ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;

1099:
1100: as
1101: ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;
1102: ddp_profile_tbl as_utility_pub.profile_tbl_type;
1103: ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;
1104: ddindx binary_integer; indx binary_integer;
1105: begin
1106:
1107: -- copy data to the local IN or IN-OUT args, if any

Line 1113: as_opportunity_pub_w.rosetta_table_copy_in_p50(ddp_decision_factor_tbl, p5_a0

1109:
1110:
1111:
1112:
1113: as_opportunity_pub_w.rosetta_table_copy_in_p50(ddp_decision_factor_tbl, p5_a0
1114: , p5_a1
1115: , p5_a2
1116: , p5_a3
1117: , p5_a4

Line 1158: as_opportunity_pub.delete_decision_factors(p_api_version_number,

1154:
1155:
1156:
1157: -- here's the delegated call to the old PL/SQL routine
1158: as_opportunity_pub.delete_decision_factors(p_api_version_number,
1159: p_init_msg_list,
1160: p_commit,
1161: p_validation_level,
1162: p_identity_salesforce_id,

Line 1186: as_opportunity_pub_w.rosetta_table_copy_out_p53(ddx_decision_factor_out_tbl, p11_a0

1182:
1183:
1184:
1185:
1186: as_opportunity_pub_w.rosetta_table_copy_out_p53(ddx_decision_factor_out_tbl, p11_a0
1187: , p11_a1
1188: );
1189:
1190:

Line 1194: end as_opportunity_pub_w3;

1190:
1191:
1192: end;
1193:
1194: end as_opportunity_pub_w3;