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.BIM_I_LEAD_MGMT_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 621: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

617: --
618: -- End of comments
619: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
620: x_custom_sql OUT NOCOPY VARCHAR2,
621: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
622: IS
623: l_query_rec bis_map_rec;
624: l_current_asof_date varchar2(80) := null;
625: l_previous_asof_date varchar2(80) := null;

Line 643: l_custom_rec BIS_QUERY_ATTRIBUTES;

639: l_previous_date date := NULL;
640: l_current_date_str varchar2(80) := NULL;
641: l_previous_date_str varchar2(80) := NULL;
642: l_error_msg varchar2(4000) := NULL;
643: l_custom_rec BIS_QUERY_ATTRIBUTES;
644: l_category_id VARCHAR2(10) := NULL;
645: l_curr_page_time_id NUMBER ;
646: l_view_by varchar2(4000);
647: l_compare_date date := NULL;

Line 734: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

730: AND b.effective_time_id=c.time_id
731: AND b.effective_period_type_id=c.period_type_id ';
732: l_qry16_res := 'AND b.salesrep_id = ';
733:
734: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
735: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
736:
737: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,
738: p_period_type => l_period_type,

Line 1091: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1087:
1088:
1089: PROCEDURE GET_LEAD_AGE_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
1090: x_custom_sql OUT NOCOPY VARCHAR2,
1091: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1092: IS
1093: l_period_type varchar2(80) := NULL;
1094: l_record_type varchar2(80) := NULL;
1095: l_org_sg varchar2(80) := NULL;

Line 1105: l_custom_rec BIS_QUERY_ATTRIBUTES;

1101: l_query varchar2(4000) := NULL;
1102: l_error_msg varchar2(4000) := NULL;
1103: l_previous_date DATE := NULL;
1104: l_bis_date CONSTANT DATE := trunc(sysdate);
1105: l_custom_rec BIS_QUERY_ATTRIBUTES;
1106: l_category_id VARCHAR2(10) := NULL;
1107: l_curr_page_time_id NUMBER ;
1108: l_prev_page_time_id NUMBER;
1109: l_view_by VARCHAR2(4000);

Line 1118: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1114: l_view_id varchar2(5000);
1115: l_close_rs VARCHAR2(500);
1116: l_context VARCHAR2(5000);
1117: BEGIN
1118: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1119: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1120: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,
1121: p_period_type => l_period_type,
1122: p_record_type => l_record_type,

Line 1270: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1266: --
1267:
1268: PROCEDURE GET_LEAD_ACT_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
1269: x_custom_sql OUT NOCOPY VARCHAR2,
1270: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1271: IS
1272: l_current_asof_date varchar2(80) := null;
1273: l_previous_asof_date varchar2(80) := null;
1274: l_time_period varchar2(80) := NULL;

Line 1286: l_custom_rec BIS_QUERY_ATTRIBUTES;

1282: l_prior_as_of_date DATE := NULL;
1283: l_page_period_type varchar2(80) := NULL;
1284: l_query varchar2(10000) := NULL;
1285: l_error_msg varchar2(4000);
1286: l_custom_rec BIS_QUERY_ATTRIBUTES;
1287: l_category_id VARCHAR2(10) := NULL;
1288: l_curr_page_time_id NUMBER ;
1289: l_view_by VARCHAR2(4000);
1290: l_url_str VARCHAR2(1000);

Line 1349: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1345: l_col3_a := '0';
1346: l_col3_b := '0';
1347: l_col3_c := '0';
1348: l_col3_d := '0';
1349: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1350: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1351:
1352: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,
1353: p_period_type => l_period_type,

Line 3122: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

3118:
3119:
3120: PROCEDURE GET_LEAD_CONV_P_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
3121: x_custom_sql OUT NOCOPY VARCHAR2,
3122: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
3123: IS
3124: l_current_asof_date varchar2(80) := null;
3125: l_previous_asof_date varchar2(80) := null;
3126: l_time_period varchar2(80) := NULL;

Line 3137: l_custom_rec BIS_QUERY_ATTRIBUTES;

3133: l_as_of_date DATE := NULL;
3134: l_prior_as_of_date DATE := NULL;
3135: l_page_period_type varchar2(80) := NULL;
3136: l_error_msg varchar2(4000);
3137: l_custom_rec BIS_QUERY_ATTRIBUTES;
3138: l_category_id VARCHAR2(10) := NULL;
3139: l_curr_page_time_id NUMBER ;
3140: l_view_by VARCHAR2(4000);
3141: l_resource_id VARCHAR2(20);

Line 3209: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

3205: l_col3_b := '0';
3206: l_col3_c := '0';
3207: l_col3_e := '0';
3208: l_col3_f := '0';
3209: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
3210: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
3211:
3212: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,
3213: p_period_type => l_period_type,

Line 4673: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

4669: END;
4670:
4671: PROCEDURE GET_LEAD_CONV_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
4672: x_custom_sql OUT NOCOPY VARCHAR2,
4673: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
4674: IS
4675: l_current_asof_date varchar2(80) := null;
4676: l_previous_asof_date varchar2(80) := null;
4677: l_time_period varchar2(80) := NULL;

Line 4688: l_custom_rec BIS_QUERY_ATTRIBUTES;

4684: l_as_of_date DATE := NULL;
4685: l_prior_as_of_date DATE := NULL;
4686: l_page_period_type varchar2(80) := NULL;
4687: l_error_msg varchar2(4000);
4688: l_custom_rec BIS_QUERY_ATTRIBUTES;
4689: l_category_id VARCHAR2(10) := NULL;
4690: l_curr_page_time_id NUMBER ;
4691: l_view_by VARCHAR2(4000);
4692: l_resource_id VARCHAR2(20);

Line 4772: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

4768: l_col3_e := '0';
4769: l_col3_f := '0';
4770: l_col3_g := '0';
4771: l_col3_h := '0';
4772: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
4773: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
4774:
4775: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,
4776: p_period_type => l_period_type,

Line 7886: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

7882: --
7883: -- End of comments
7884: PROCEDURE GET_LEAD_AGING_QU_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
7885: x_custom_sql OUT NOCOPY VARCHAR2,
7886: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7887: IS
7888: l_current_asof_date varchar2(80) := null;
7889: l_previous_asof_date varchar2(80) := null;
7890: l_time_period varchar2(80) := NULL;

Line 7902: l_custom_rec BIS_QUERY_ATTRIBUTES;

7898: l_prior_as_of_date DATE := NULL;
7899: l_page_period_type varchar2(80) := NULL;
7900: l_query varchar2(4000) := NULL;
7901: l_error_msg varchar2(4000) := NULL;
7902: l_custom_rec BIS_QUERY_ATTRIBUTES;
7903: l_category_id VARCHAR2(10) := NULL;
7904: l_curr_page_time_id NUMBER ;
7905: l_view_by VARCHAR2(4000);
7906: l_resource_id VARCHAR2(20);

Line 7915: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

7911: l_close_rs VARCHAR2(500);
7912: l_context VARCHAR2(5000);
7913: BEGIN
7914:
7915: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
7916: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
7917:
7918: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,
7919: p_period_type => l_period_type,

Line 8054: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

8050: -- End of comments
8051:
8052: PROCEDURE GET_LEAD_QUALITY_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
8053: x_custom_sql OUT NOCOPY VARCHAR2,
8054: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
8055: IS
8056: l_current_asof_date varchar2(80) := null;
8057: l_previous_asof_date varchar2(80) := null;
8058: l_time_period varchar2(80) := NULL;

Line 8070: l_custom_rec BIS_QUERY_ATTRIBUTES;

8066: l_prior_as_of_date DATE := NULL;
8067: l_page_period_type varchar2(80) := NULL;
8068: l_query varchar2(10000) := NULL;
8069: l_error_msg varchar2(4000);
8070: l_custom_rec BIS_QUERY_ATTRIBUTES;
8071: l_category_id VARCHAR2(10) := NULL;
8072: l_curr_page_time_id NUMBER ;
8073: l_view_by VARCHAR2(4000);
8074: l_url_str VARCHAR2(1000);

Line 8118: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

8114:
8115: BEGIN
8116: l_col3_a := '0';
8117: l_col3_b := '0';
8118: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
8119: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
8120:
8121: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,
8122: p_period_type => l_period_type,

Line 9226: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

9222:
9223:
9224: PROCEDURE GET_LEAD_AGING_SG_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
9225: x_custom_sql OUT NOCOPY VARCHAR2,
9226: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
9227: IS
9228: l_current_asof_date varchar2(80) := null;
9229: l_previous_asof_date varchar2(80) := null;
9230: l_time_period varchar2(80) := NULL;

Line 9242: l_custom_rec BIS_QUERY_ATTRIBUTES;

9238: l_prior_as_of_date DATE := NULL;
9239: l_page_period_type varchar2(80) := NULL;
9240: l_query varchar2(15000) := NULL;
9241: l_error_msg varchar2(4000) := NULL;
9242: l_custom_rec BIS_QUERY_ATTRIBUTES;
9243: l_category_id VARCHAR2(10) := NULL;
9244: l_curr_page_time_id NUMBER ;
9245: l_view_by VARCHAR2(4000);
9246: l_resource_id VARCHAR2(20);

Line 9298: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

9294: BEGIN
9295:
9296: l_col3_a := '0';
9297: l_col3_b := '0';
9298: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
9299: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
9300:
9301: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,
9302: p_period_type => l_period_type,

Line 10215: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

10211: -- End of comments
10212:
10213: PROCEDURE GET_LEAD_OPP_CHART_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
10214: x_custom_sql OUT NOCOPY VARCHAR2,
10215: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
10216: IS
10217: l_current_asof_date varchar2(80) := null;
10218: l_previous_asof_date varchar2(80) := null;
10219: l_time_period varchar2(80) := NULL;

Line 10238: l_custom_rec BIS_QUERY_ATTRIBUTES;

10234: l_prev_end_date date := NULL;
10235: l_query varchar2(32767);
10236: l_error varchar2(4000);
10237: l_series_name varchar2(4000);
10238: l_custom_rec BIS_QUERY_ATTRIBUTES;
10239: l_category_id VARCHAR2(10) := NULL;
10240: l_curr_page_time_id NUMBER ;
10241: l_view_by VARCHAR2(4000);
10242: l_resource_id VARCHAR2(20);

Line 10254: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

10250: l_context VARCHAR2(5000);
10251:
10252: BEGIN
10253:
10254: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
10255: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
10256:
10257: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,
10258: p_period_type => l_period_type,

Line 11569: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

11565: END;
11566:
11567: PROCEDURE GET_LEAD_CAMP_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
11568: x_custom_sql OUT NOCOPY VARCHAR2,
11569: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
11570: IS
11571: l_current_asof_date varchar2(80) := null;
11572: l_previous_asof_date varchar2(80) := null;
11573: l_time_period varchar2(80) := NULL;

Line 11584: l_custom_rec BIS_QUERY_ATTRIBUTES;

11580: l_prior_as_of_date DATE := NULL;
11581: l_page_period_type varchar2(80) := NULL;
11582: l_query varchar2(10000) := NULL;
11583: l_error_msg varchar2(4000);
11584: l_custom_rec BIS_QUERY_ATTRIBUTES;
11585: l_category_id VARCHAR2(10) := NULL;
11586: l_curr_page_time_id NUMBER ;
11587: l_view_by VARCHAR2(4000);
11588: l_url_str VARCHAR2(1000) := null;

Line 11620: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

11616: l_close_rs VARCHAR2(500);
11617: l_context VARCHAR2(5000);
11618:
11619: BEGIN
11620: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
11621:
11622: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
11623:
11624: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,

Line 11842: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

11838:
11839: /*
11840: PROCEDURE GET_LEAD_DETAIL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
11841: x_custom_sql OUT NOCOPY VARCHAR2,
11842: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
11843: IS
11844:
11845:
11846:

Line 11885: l_custom_rec BIS_QUERY_ATTRIBUTES;

11881: l_previous_date date := NULL;
11882: l_current_date_str varchar2(80) := NULL;
11883: l_previous_date_str varchar2(80) := NULL;
11884: l_error_msg varchar2(4000) := NULL;
11885: l_custom_rec BIS_QUERY_ATTRIBUTES;
11886: l_category_id VARCHAR2(10) := NULL;
11887: l_curr_page_time_id NUMBER ;
11888: l_compare_date date := NULL;
11889: l_seq_date date := NULL;

Line 11916: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

11912:
11913:
11914: BEGIN
11915:
11916: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
11917: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
11918:
11919:
11920:

Line 12359: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

12355:
12356:
12357: PROCEDURE GET_LEAD_DETAIL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
12358: x_custom_sql OUT NOCOPY VARCHAR2,
12359: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
12360: IS
12361:
12362:
12363:

Line 12402: l_custom_rec BIS_QUERY_ATTRIBUTES;

12398: l_previous_date date := NULL;
12399: l_current_date_str varchar2(80) := NULL;
12400: l_previous_date_str varchar2(80) := NULL;
12401: l_error_msg varchar2(4000) := NULL;
12402: l_custom_rec BIS_QUERY_ATTRIBUTES;
12403: l_category_id VARCHAR2(10) := NULL;
12404: l_curr_page_time_id NUMBER ;
12405: l_compare_date date := NULL;
12406: l_seq_date date := NULL;

Line 12433: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

12429:
12430:
12431: BEGIN
12432:
12433: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
12434: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
12435:
12436: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,
12437: p_period_type => l_period_type,