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_PMV_PARAMETERS_PUB

Line 735: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
739: p_record_type => l_record_type,

Line 984: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;

980:
981: x_custom_sql := l_query;
982: x_custom_output.EXTEND;
983:
984: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
985: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
986: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
987: x_custom_output.EXTEND;
988: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;

Line 986: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

982: x_custom_output.EXTEND;
983:
984: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
985: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
986: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
987: x_custom_output.EXTEND;
988: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;
989: */
990:

Line 993: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

989: */
990:
991: l_custom_rec.attribute_name := ':l_record_type';
992: l_custom_rec.attribute_value := l_record_type;
993: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
994: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
995: x_custom_output.EXTEND;
996: x_custom_output(1) := l_custom_rec;
997:

Line 994: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

990:
991: l_custom_rec.attribute_name := ':l_record_type';
992: l_custom_rec.attribute_value := l_record_type;
993: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
994: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
995: x_custom_output.EXTEND;
996: x_custom_output(1) := l_custom_rec;
997:
998: l_custom_rec.attribute_name := ':l_time_id';

Line 1000: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

996: x_custom_output(1) := l_custom_rec;
997:
998: l_custom_rec.attribute_name := ':l_time_id';
999: l_custom_rec.attribute_value := l_curr_page_time_id;
1000: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1001: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1002: x_custom_output.EXTEND;
1003: x_custom_output(2) := l_custom_rec;
1004:

Line 1001: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

997:
998: l_custom_rec.attribute_name := ':l_time_id';
999: l_custom_rec.attribute_value := l_curr_page_time_id;
1000: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1001: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1002: x_custom_output.EXTEND;
1003: x_custom_output(2) := l_custom_rec;
1004:
1005: l_custom_rec.attribute_name := ':l_period_type_id';

Line 1007: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1003: x_custom_output(2) := l_custom_rec;
1004:
1005: l_custom_rec.attribute_name := ':l_period_type_id';
1006: l_custom_rec.attribute_value := l_period_type;
1007: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1008: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1009: x_custom_output.EXTEND;
1010: x_custom_output(3) := l_custom_rec;
1011:

Line 1008: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1004:
1005: l_custom_rec.attribute_name := ':l_period_type_id';
1006: l_custom_rec.attribute_value := l_period_type;
1007: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1008: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1009: x_custom_output.EXTEND;
1010: x_custom_output(3) := l_custom_rec;
1011:
1012: l_custom_rec.attribute_name := ':l_period_type';

Line 1014: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1010: x_custom_output(3) := l_custom_rec;
1011:
1012: l_custom_rec.attribute_name := ':l_period_type';
1013: l_custom_rec.attribute_value := l_period_type;
1014: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1015: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1016: x_custom_output.EXTEND;
1017: x_custom_output(4) := l_custom_rec;
1018:

Line 1015: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1011:
1012: l_custom_rec.attribute_name := ':l_period_type';
1013: l_custom_rec.attribute_value := l_period_type;
1014: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1015: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1016: x_custom_output.EXTEND;
1017: x_custom_output(4) := l_custom_rec;
1018:
1019: l_custom_rec.attribute_name := ':l_prev_time_id';

Line 1021: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1017: x_custom_output(4) := l_custom_rec;
1018:
1019: l_custom_rec.attribute_name := ':l_prev_time_id';
1020: l_custom_rec.attribute_value := l_prev_page_time_id;
1021: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1022: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1023: x_custom_output.EXTEND;
1024: x_custom_output(5) := l_custom_rec;
1025:

Line 1022: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1018:
1019: l_custom_rec.attribute_name := ':l_prev_time_id';
1020: l_custom_rec.attribute_value := l_prev_page_time_id;
1021: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1022: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1023: x_custom_output.EXTEND;
1024: x_custom_output(5) := l_custom_rec;
1025:
1026: l_custom_rec.attribute_name := ':l_group_id';

Line 1028: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1024: x_custom_output(5) := l_custom_rec;
1025:
1026: l_custom_rec.attribute_name := ':l_group_id';
1027: l_custom_rec.attribute_value := l_org_sg;
1028: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1029: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1030: x_custom_output.EXTEND;
1031: x_custom_output(6) := l_custom_rec;
1032:

Line 1029: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1025:
1026: l_custom_rec.attribute_name := ':l_group_id';
1027: l_custom_rec.attribute_value := l_org_sg;
1028: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1029: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1030: x_custom_output.EXTEND;
1031: x_custom_output(6) := l_custom_rec;
1032:
1033: l_custom_rec.attribute_name := ':l_resource_id';

Line 1035: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1031: x_custom_output(6) := l_custom_rec;
1032:
1033: l_custom_rec.attribute_name := ':l_resource_id';
1034: l_custom_rec.attribute_value := l_resource_id;
1035: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1036: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1037: x_custom_output.EXTEND;
1038: x_custom_output(7) := l_custom_rec;
1039:

Line 1036: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1032:
1033: l_custom_rec.attribute_name := ':l_resource_id';
1034: l_custom_rec.attribute_value := l_resource_id;
1035: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1036: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1037: x_custom_output.EXTEND;
1038: x_custom_output(7) := l_custom_rec;
1039:
1040:

Line 1119: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
1123: p_sg_id => l_org_sg,

Line 1225: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;

1221:
1222: x_custom_sql := l_query;
1223: x_custom_output.EXTEND;
1224:
1225: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
1226: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
1227: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1228: x_custom_output.EXTEND;
1229: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;

Line 1227: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

1223: x_custom_output.EXTEND;
1224:
1225: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
1226: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
1227: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1228: x_custom_output.EXTEND;
1229: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;
1230: */
1231:

Line 1234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1230: */
1231:
1232: l_custom_rec.attribute_name := ':l_previous_date';
1233: l_custom_rec.attribute_value := TO_CHAR(l_previous_date,'MM-DD-YYYY');
1234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1236: x_custom_output.EXTEND;
1237: x_custom_output(1) := l_custom_rec;
1238:

Line 1235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1231:
1232: l_custom_rec.attribute_name := ':l_previous_date';
1233: l_custom_rec.attribute_value := TO_CHAR(l_previous_date,'MM-DD-YYYY');
1234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1236: x_custom_output.EXTEND;
1237: x_custom_output(1) := l_custom_rec;
1238:
1239: l_custom_rec.attribute_name := ':l_group_id';

Line 1241: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1237: x_custom_output(1) := l_custom_rec;
1238:
1239: l_custom_rec.attribute_name := ':l_group_id';
1240: l_custom_rec.attribute_value := l_org_sg;
1241: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1242: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1243: x_custom_output.EXTEND;
1244: x_custom_output(2) := l_custom_rec;
1245:

Line 1242: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1238:
1239: l_custom_rec.attribute_name := ':l_group_id';
1240: l_custom_rec.attribute_value := l_org_sg;
1241: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1242: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1243: x_custom_output.EXTEND;
1244: x_custom_output(2) := l_custom_rec;
1245:
1246: l_custom_rec.attribute_name := ':l_resource_id';

Line 1248: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1244: x_custom_output(2) := l_custom_rec;
1245:
1246: l_custom_rec.attribute_name := ':l_resource_id';
1247: l_custom_rec.attribute_value := l_resource_id;
1248: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1249: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1250: x_custom_output.EXTEND;
1251: x_custom_output(3) := l_custom_rec;
1252:

Line 1249: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1245:
1246: l_custom_rec.attribute_name := ':l_resource_id';
1247: l_custom_rec.attribute_value := l_resource_id;
1248: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1249: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1250: x_custom_output.EXTEND;
1251: x_custom_output(3) := l_custom_rec;
1252:
1253:

Line 1350: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
1354: p_record_type => l_record_type,

Line 3057: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

3053: x_custom_sql := l_query;
3054:
3055: l_custom_rec.attribute_name := ':l_record_type';
3056: l_custom_rec.attribute_value := l_record_type;
3057: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3058: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3059: x_custom_output.EXTEND;
3060: x_custom_output(1) := l_custom_rec;
3061:

Line 3058: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

3054:
3055: l_custom_rec.attribute_name := ':l_record_type';
3056: l_custom_rec.attribute_value := l_record_type;
3057: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3058: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3059: x_custom_output.EXTEND;
3060: x_custom_output(1) := l_custom_rec;
3061:
3062: l_custom_rec.attribute_name := ':l_time_id';

Line 3064: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

3060: x_custom_output(1) := l_custom_rec;
3061:
3062: l_custom_rec.attribute_name := ':l_time_id';
3063: l_custom_rec.attribute_value := l_curr_page_time_id;
3064: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3065: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3066: x_custom_output.EXTEND;
3067: x_custom_output(2) := l_custom_rec;
3068:

Line 3065: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

3061:
3062: l_custom_rec.attribute_name := ':l_time_id';
3063: l_custom_rec.attribute_value := l_curr_page_time_id;
3064: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3065: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3066: x_custom_output.EXTEND;
3067: x_custom_output(2) := l_custom_rec;
3068:
3069: l_custom_rec.attribute_name := ':l_period_type_id';

Line 3071: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

3067: x_custom_output(2) := l_custom_rec;
3068:
3069: l_custom_rec.attribute_name := ':l_period_type_id';
3070: l_custom_rec.attribute_value := l_period_type;
3071: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3072: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3073: x_custom_output.EXTEND;
3074: x_custom_output(3) := l_custom_rec;
3075:

Line 3072: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

3068:
3069: l_custom_rec.attribute_name := ':l_period_type_id';
3070: l_custom_rec.attribute_value := l_period_type;
3071: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3072: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3073: x_custom_output.EXTEND;
3074: x_custom_output(3) := l_custom_rec;
3075:
3076: l_custom_rec.attribute_name := ':l_period_type';

Line 3078: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

3074: x_custom_output(3) := l_custom_rec;
3075:
3076: l_custom_rec.attribute_name := ':l_period_type';
3077: l_custom_rec.attribute_value := l_period_type;
3078: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3079: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3080: x_custom_output.EXTEND;
3081: x_custom_output(4) := l_custom_rec;
3082:

Line 3079: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

3075:
3076: l_custom_rec.attribute_name := ':l_period_type';
3077: l_custom_rec.attribute_value := l_period_type;
3078: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3079: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3080: x_custom_output.EXTEND;
3081: x_custom_output(4) := l_custom_rec;
3082:
3083: l_custom_rec.attribute_name := ':l_seq_date';

Line 3085: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

3081: x_custom_output(4) := l_custom_rec;
3082:
3083: l_custom_rec.attribute_name := ':l_seq_date';
3084: l_custom_rec.attribute_value := to_char(l_seq_date,'DD-MON-YY');
3085: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3086: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3087: x_custom_output.EXTEND;
3088: x_custom_output(5) := l_custom_rec;
3089:

Line 3086: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3082:
3083: l_custom_rec.attribute_name := ':l_seq_date';
3084: l_custom_rec.attribute_value := to_char(l_seq_date,'DD-MON-YY');
3085: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3086: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3087: x_custom_output.EXTEND;
3088: x_custom_output(5) := l_custom_rec;
3089:
3090: l_custom_rec.attribute_name := ':l_group_id';

Line 3092: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

3088: x_custom_output(5) := l_custom_rec;
3089:
3090: l_custom_rec.attribute_name := ':l_group_id';
3091: l_custom_rec.attribute_value := l_org_sg;
3092: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3093: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3094: x_custom_output.EXTEND;
3095: x_custom_output(6) := l_custom_rec;
3096:

Line 3093: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

3089:
3090: l_custom_rec.attribute_name := ':l_group_id';
3091: l_custom_rec.attribute_value := l_org_sg;
3092: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3093: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3094: x_custom_output.EXTEND;
3095: x_custom_output(6) := l_custom_rec;
3096:
3097: l_custom_rec.attribute_name := ':l_resource_id';

Line 3099: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

3095: x_custom_output(6) := l_custom_rec;
3096:
3097: l_custom_rec.attribute_name := ':l_resource_id';
3098: l_custom_rec.attribute_value := l_resource_id;
3099: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3100: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3101: x_custom_output.EXTEND;
3102: x_custom_output(7) := l_custom_rec;
3103:

Line 3100: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

3096:
3097: l_custom_rec.attribute_name := ':l_resource_id';
3098: l_custom_rec.attribute_value := l_resource_id;
3099: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3100: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3101: x_custom_output.EXTEND;
3102: x_custom_output(7) := l_custom_rec;
3103:
3104:

Line 3107: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

3103:
3104:
3105: l_custom_rec.attribute_name := ':g_start_date';
3106: l_custom_rec.attribute_value := TO_CHAR(G_START_DATE,'MM-DD-YYYY');
3107: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3108: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3109: x_custom_output.EXTEND;
3110: x_custom_output(8) := l_custom_rec;
3111:

Line 3108: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3104:
3105: l_custom_rec.attribute_name := ':g_start_date';
3106: l_custom_rec.attribute_value := TO_CHAR(G_START_DATE,'MM-DD-YYYY');
3107: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3108: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3109: x_custom_output.EXTEND;
3110: x_custom_output(8) := l_custom_rec;
3111:
3112:

Line 3210: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
3214: p_record_type => l_record_type,

Line 4621: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;

4617: x_custom_sql := l_query||'&ORDER_BY_CLAUSE';
4618: END IF;
4619:
4620:
4621: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
4622: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
4623: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
4624: x_custom_output.EXTEND;
4625: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;

Line 4623: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

4619:
4620:
4621: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
4622: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
4623: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
4624: x_custom_output.EXTEND;
4625: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;
4626: */
4627:

Line 4630: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

4626: */
4627:
4628: l_custom_rec.attribute_name := ':l_record_type';
4629: l_custom_rec.attribute_value := l_record_type;
4630: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4631: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4632: x_custom_output.EXTEND;
4633: x_custom_output(1) := l_custom_rec;
4634:

Line 4631: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

4627:
4628: l_custom_rec.attribute_name := ':l_record_type';
4629: l_custom_rec.attribute_value := l_record_type;
4630: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4631: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4632: x_custom_output.EXTEND;
4633: x_custom_output(1) := l_custom_rec;
4634:
4635: l_custom_rec.attribute_name := ':l_time_id';

Line 4637: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

4633: x_custom_output(1) := l_custom_rec;
4634:
4635: l_custom_rec.attribute_name := ':l_time_id';
4636: l_custom_rec.attribute_value := l_curr_page_time_id;
4637: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4638: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4639: x_custom_output.EXTEND;
4640: x_custom_output(2) := l_custom_rec;
4641:

Line 4638: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

4634:
4635: l_custom_rec.attribute_name := ':l_time_id';
4636: l_custom_rec.attribute_value := l_curr_page_time_id;
4637: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4638: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4639: x_custom_output.EXTEND;
4640: x_custom_output(2) := l_custom_rec;
4641:
4642: l_custom_rec.attribute_name := ':l_period_type_id';

Line 4644: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

4640: x_custom_output(2) := l_custom_rec;
4641:
4642: l_custom_rec.attribute_name := ':l_period_type_id';
4643: l_custom_rec.attribute_value := l_period_type;
4644: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4645: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4646: x_custom_output.EXTEND;
4647: x_custom_output(3) := l_custom_rec;
4648:

Line 4645: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

4641:
4642: l_custom_rec.attribute_name := ':l_period_type_id';
4643: l_custom_rec.attribute_value := l_period_type;
4644: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4645: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4646: x_custom_output.EXTEND;
4647: x_custom_output(3) := l_custom_rec;
4648:
4649: l_custom_rec.attribute_name := ':l_group_id';

Line 4651: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

4647: x_custom_output(3) := l_custom_rec;
4648:
4649: l_custom_rec.attribute_name := ':l_group_id';
4650: l_custom_rec.attribute_value := l_org_sg;
4651: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4652: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4653: x_custom_output.EXTEND;
4654: x_custom_output(4) := l_custom_rec;
4655:

Line 4652: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

4648:
4649: l_custom_rec.attribute_name := ':l_group_id';
4650: l_custom_rec.attribute_value := l_org_sg;
4651: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4652: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4653: x_custom_output.EXTEND;
4654: x_custom_output(4) := l_custom_rec;
4655:
4656: l_custom_rec.attribute_name := ':l_resource_id';

Line 4658: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

4654: x_custom_output(4) := l_custom_rec;
4655:
4656: l_custom_rec.attribute_name := ':l_resource_id';
4657: l_custom_rec.attribute_value := l_resource_id;
4658: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4659: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4660: x_custom_output.EXTEND;
4661: x_custom_output(5) := l_custom_rec;
4662:

Line 4659: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

4655:
4656: l_custom_rec.attribute_name := ':l_resource_id';
4657: l_custom_rec.attribute_value := l_resource_id;
4658: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4659: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4660: x_custom_output.EXTEND;
4661: x_custom_output(5) := l_custom_rec;
4662:
4663:

Line 4773: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
4777: p_record_type => l_record_type,

Line 7814: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;

7810: x_custom_sql := l_query||'&ORDER_BY_CLAUSE';
7811:
7812: END IF;
7813:
7814: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
7815: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
7816: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
7817: x_custom_output.EXTEND;
7818: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;

Line 7816: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

7812: END IF;
7813:
7814: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
7815: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
7816: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
7817: x_custom_output.EXTEND;
7818: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;
7819: */
7820:

Line 7823: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

7819: */
7820:
7821: l_custom_rec.attribute_name := ':l_record_type';
7822: l_custom_rec.attribute_value := l_record_type;
7823: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7824: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7825: x_custom_output.EXTEND;
7826: x_custom_output(1) := l_custom_rec;
7827:

Line 7824: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

7820:
7821: l_custom_rec.attribute_name := ':l_record_type';
7822: l_custom_rec.attribute_value := l_record_type;
7823: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7824: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7825: x_custom_output.EXTEND;
7826: x_custom_output(1) := l_custom_rec;
7827:
7828: l_custom_rec.attribute_name := ':l_time_id';

Line 7830: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

7826: x_custom_output(1) := l_custom_rec;
7827:
7828: l_custom_rec.attribute_name := ':l_time_id';
7829: l_custom_rec.attribute_value := l_curr_page_time_id;
7830: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7831: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
7832: x_custom_output.EXTEND;
7833: x_custom_output(2) := l_custom_rec;
7834:

Line 7831: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

7827:
7828: l_custom_rec.attribute_name := ':l_time_id';
7829: l_custom_rec.attribute_value := l_curr_page_time_id;
7830: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7831: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
7832: x_custom_output.EXTEND;
7833: x_custom_output(2) := l_custom_rec;
7834:
7835: l_custom_rec.attribute_name := ':l_period_type_id';

Line 7837: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

7833: x_custom_output(2) := l_custom_rec;
7834:
7835: l_custom_rec.attribute_name := ':l_period_type_id';
7836: l_custom_rec.attribute_value := l_period_type;
7837: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7838: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7839: x_custom_output.EXTEND;
7840: x_custom_output(3) := l_custom_rec;
7841:

Line 7838: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

7834:
7835: l_custom_rec.attribute_name := ':l_period_type_id';
7836: l_custom_rec.attribute_value := l_period_type;
7837: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7838: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7839: x_custom_output.EXTEND;
7840: x_custom_output(3) := l_custom_rec;
7841:
7842: l_custom_rec.attribute_name := ':l_prev_time_id';

Line 7844: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

7840: x_custom_output(3) := l_custom_rec;
7841:
7842: l_custom_rec.attribute_name := ':l_prev_time_id';
7843: l_custom_rec.attribute_value := l_prev_page_time_id;
7844: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7845: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
7846: x_custom_output.EXTEND;
7847: x_custom_output(4) := l_custom_rec;
7848:

Line 7845: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

7841:
7842: l_custom_rec.attribute_name := ':l_prev_time_id';
7843: l_custom_rec.attribute_value := l_prev_page_time_id;
7844: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7845: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
7846: x_custom_output.EXTEND;
7847: x_custom_output(4) := l_custom_rec;
7848:
7849: l_custom_rec.attribute_name := ':l_group_id';

Line 7851: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

7847: x_custom_output(4) := l_custom_rec;
7848:
7849: l_custom_rec.attribute_name := ':l_group_id';
7850: l_custom_rec.attribute_value := l_org_sg;
7851: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7852: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
7853: x_custom_output.EXTEND;
7854: x_custom_output(5) := l_custom_rec;
7855:

Line 7852: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

7848:
7849: l_custom_rec.attribute_name := ':l_group_id';
7850: l_custom_rec.attribute_value := l_org_sg;
7851: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7852: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
7853: x_custom_output.EXTEND;
7854: x_custom_output(5) := l_custom_rec;
7855:
7856: l_custom_rec.attribute_name := ':l_resource_id';

Line 7858: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

7854: x_custom_output(5) := l_custom_rec;
7855:
7856: l_custom_rec.attribute_name := ':l_resource_id';
7857: l_custom_rec.attribute_value := l_resource_id;
7858: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7859: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
7860: x_custom_output.EXTEND;
7861: x_custom_output(6) := l_custom_rec;
7862:

Line 7859: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

7855:
7856: l_custom_rec.attribute_name := ':l_resource_id';
7857: l_custom_rec.attribute_value := l_resource_id;
7858: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7859: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
7860: x_custom_output.EXTEND;
7861: x_custom_output(6) := l_custom_rec;
7862:
7863: --test('GET_LEAD_ACT_SQL','QUERY','',l_query);

Line 7916: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
7920: p_record_type => l_record_type,

Line 8119: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
8123: p_record_type => l_record_type,

Line 9160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

9156: x_custom_sql := l_query;
9157:
9158: l_custom_rec.attribute_name := ':l_record_type';
9159: l_custom_rec.attribute_value := l_record_type;
9160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
9162: x_custom_output.EXTEND;
9163: x_custom_output(1) := l_custom_rec;
9164:

Line 9161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

9157:
9158: l_custom_rec.attribute_name := ':l_record_type';
9159: l_custom_rec.attribute_value := l_record_type;
9160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
9162: x_custom_output.EXTEND;
9163: x_custom_output(1) := l_custom_rec;
9164:
9165: l_custom_rec.attribute_name := ':l_time_id';

Line 9167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

9163: x_custom_output(1) := l_custom_rec;
9164:
9165: l_custom_rec.attribute_name := ':l_time_id';
9166: l_custom_rec.attribute_value := l_curr_page_time_id;
9167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
9169: x_custom_output.EXTEND;
9170: x_custom_output(2) := l_custom_rec;
9171:

Line 9168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

9164:
9165: l_custom_rec.attribute_name := ':l_time_id';
9166: l_custom_rec.attribute_value := l_curr_page_time_id;
9167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
9169: x_custom_output.EXTEND;
9170: x_custom_output(2) := l_custom_rec;
9171:
9172: l_custom_rec.attribute_name := ':l_period_type_id';

Line 9174: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

9170: x_custom_output(2) := l_custom_rec;
9171:
9172: l_custom_rec.attribute_name := ':l_period_type_id';
9173: l_custom_rec.attribute_value := l_period_type;
9174: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9175: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
9176: x_custom_output.EXTEND;
9177: x_custom_output(3) := l_custom_rec;
9178:

Line 9175: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

9171:
9172: l_custom_rec.attribute_name := ':l_period_type_id';
9173: l_custom_rec.attribute_value := l_period_type;
9174: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9175: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
9176: x_custom_output.EXTEND;
9177: x_custom_output(3) := l_custom_rec;
9178:
9179: l_custom_rec.attribute_name := ':l_period_type';

Line 9181: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

9177: x_custom_output(3) := l_custom_rec;
9178:
9179: l_custom_rec.attribute_name := ':l_period_type';
9180: l_custom_rec.attribute_value := l_period_type;
9181: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9182: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
9183: x_custom_output.EXTEND;
9184: x_custom_output(4) := l_custom_rec;
9185:

Line 9182: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

9178:
9179: l_custom_rec.attribute_name := ':l_period_type';
9180: l_custom_rec.attribute_value := l_period_type;
9181: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9182: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
9183: x_custom_output.EXTEND;
9184: x_custom_output(4) := l_custom_rec;
9185:
9186: l_custom_rec.attribute_name := ':l_group_id';

Line 9188: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

9184: x_custom_output(4) := l_custom_rec;
9185:
9186: l_custom_rec.attribute_name := ':l_group_id';
9187: l_custom_rec.attribute_value := l_org_sg;
9188: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9189: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
9190: x_custom_output.EXTEND;
9191: x_custom_output(5) := l_custom_rec;
9192:

Line 9189: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

9185:
9186: l_custom_rec.attribute_name := ':l_group_id';
9187: l_custom_rec.attribute_value := l_org_sg;
9188: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9189: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
9190: x_custom_output.EXTEND;
9191: x_custom_output(5) := l_custom_rec;
9192:
9193: l_custom_rec.attribute_name := ':l_resource_id';

Line 9195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

9191: x_custom_output(5) := l_custom_rec;
9192:
9193: l_custom_rec.attribute_name := ':l_resource_id';
9194: l_custom_rec.attribute_value := l_resource_id;
9195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
9197: x_custom_output.EXTEND;
9198: x_custom_output(6) := l_custom_rec;
9199:

Line 9196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

9192:
9193: l_custom_rec.attribute_name := ':l_resource_id';
9194: l_custom_rec.attribute_value := l_resource_id;
9195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
9196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
9197: x_custom_output.EXTEND;
9198: x_custom_output(6) := l_custom_rec;
9199:
9200: --test('GET_LEAD_QUALITY_SQL','QUERY','',l_query);

Line 9299: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
9303: p_record_type => l_record_type,

Line 10168: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;

10164:
10165: x_custom_sql := l_query;
10166: -- x_custom_output.EXTEND;
10167:
10168: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
10169: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
10170: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
10171: x_custom_output.EXTEND;
10172: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;

Line 10170: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

10166: -- x_custom_output.EXTEND;
10167:
10168: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
10169: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
10170: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
10171: x_custom_output.EXTEND;
10172: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;
10173: */
10174:

Line 10177: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

10173: */
10174:
10175: l_custom_rec.attribute_name := ':l_group_id';
10176: l_custom_rec.attribute_value := l_org_sg;
10177: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
10178: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
10179: x_custom_output.EXTEND;
10180: x_custom_output(1) := l_custom_rec;
10181:

Line 10178: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

10174:
10175: l_custom_rec.attribute_name := ':l_group_id';
10176: l_custom_rec.attribute_value := l_org_sg;
10177: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
10178: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
10179: x_custom_output.EXTEND;
10180: x_custom_output(1) := l_custom_rec;
10181:
10182: l_custom_rec.attribute_name := ':l_resource_id';

Line 10184: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

10180: x_custom_output(1) := l_custom_rec;
10181:
10182: l_custom_rec.attribute_name := ':l_resource_id';
10183: l_custom_rec.attribute_value := l_resource_id;
10184: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
10185: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
10186: x_custom_output.EXTEND;
10187: x_custom_output(2) := l_custom_rec;
10188:

Line 10185: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

10181:
10182: l_custom_rec.attribute_name := ':l_resource_id';
10183: l_custom_rec.attribute_value := l_resource_id;
10184: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
10185: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
10186: x_custom_output.EXTEND;
10187: x_custom_output(2) := l_custom_rec;
10188:
10189: --test('GET_LEAD_AGING_SG_SQL','QUERY','',l_query);

Line 10255: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
10259: p_record_type => l_record_type,

Line 11504: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;

11500:
11501: x_custom_sql := l_query;
11502: x_custom_output.EXTEND;
11503:
11504: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
11505: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
11506: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
11507: x_custom_output.EXTEND;
11508: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;

Line 11506: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

11502: x_custom_output.EXTEND;
11503:
11504: /*l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_KEY;
11505: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
11506: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
11507: x_custom_output.EXTEND;
11508: x_custom_output(x_CUSTOM_OUTPUT.COUNT) := l_custom_rec;
11509: */
11510:

Line 11513: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11509: */
11510:
11511: l_custom_rec.attribute_name := ':l_record_type';
11512: l_custom_rec.attribute_value := l_record_type;
11513: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11514: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11515: x_custom_output.EXTEND;
11516: x_custom_output(1) := l_custom_rec;
11517:

Line 11514: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

11510:
11511: l_custom_rec.attribute_name := ':l_record_type';
11512: l_custom_rec.attribute_value := l_record_type;
11513: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11514: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11515: x_custom_output.EXTEND;
11516: x_custom_output(1) := l_custom_rec;
11517:
11518: l_custom_rec.attribute_name := ':l_period_type';

Line 11520: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11516: x_custom_output(1) := l_custom_rec;
11517:
11518: l_custom_rec.attribute_name := ':l_period_type';
11519: l_custom_rec.attribute_value := l_period_type;
11520: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11521: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11522: x_custom_output.EXTEND;
11523: x_custom_output(2) := l_custom_rec;
11524:

Line 11521: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

11517:
11518: l_custom_rec.attribute_name := ':l_period_type';
11519: l_custom_rec.attribute_value := l_period_type;
11520: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11521: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11522: x_custom_output.EXTEND;
11523: x_custom_output(2) := l_custom_rec;
11524:
11525: l_custom_rec.attribute_name := ':l_row_count';

Line 11527: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11523: x_custom_output(2) := l_custom_rec;
11524:
11525: l_custom_rec.attribute_name := ':l_row_count';
11526: l_custom_rec.attribute_value := l_row_count;
11527: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11528: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11529: x_custom_output.EXTEND;
11530: x_custom_output(3) := l_custom_rec;
11531:

Line 11528: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

11524:
11525: l_custom_rec.attribute_name := ':l_row_count';
11526: l_custom_rec.attribute_value := l_row_count;
11527: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11528: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11529: x_custom_output.EXTEND;
11530: x_custom_output(3) := l_custom_rec;
11531:
11532: l_custom_rec.attribute_name := ':l_time_id';

Line 11534: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11530: x_custom_output(3) := l_custom_rec;
11531:
11532: l_custom_rec.attribute_name := ':l_time_id';
11533: l_custom_rec.attribute_value := l_curr_page_time_id;
11534: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11535: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11536: x_custom_output.EXTEND;
11537: x_custom_output(4) := l_custom_rec;
11538:

Line 11535: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

11531:
11532: l_custom_rec.attribute_name := ':l_time_id';
11533: l_custom_rec.attribute_value := l_curr_page_time_id;
11534: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11535: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11536: x_custom_output.EXTEND;
11537: x_custom_output(4) := l_custom_rec;
11538:
11539: l_custom_rec.attribute_name := ':l_period_type_id';

Line 11541: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11537: x_custom_output(4) := l_custom_rec;
11538:
11539: l_custom_rec.attribute_name := ':l_period_type_id';
11540: l_custom_rec.attribute_value := l_period_type;
11541: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11542: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11543: x_custom_output.EXTEND;
11544: x_custom_output(5) := l_custom_rec;
11545:

Line 11542: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

11538:
11539: l_custom_rec.attribute_name := ':l_period_type_id';
11540: l_custom_rec.attribute_value := l_period_type;
11541: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11542: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11543: x_custom_output.EXTEND;
11544: x_custom_output(5) := l_custom_rec;
11545:
11546: l_custom_rec.attribute_name := ':l_group_id';

Line 11548: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11544: x_custom_output(5) := l_custom_rec;
11545:
11546: l_custom_rec.attribute_name := ':l_group_id';
11547: l_custom_rec.attribute_value := l_org_sg;
11548: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11549: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11550: x_custom_output.EXTEND;
11551: x_custom_output(6) := l_custom_rec;
11552:

Line 11549: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

11545:
11546: l_custom_rec.attribute_name := ':l_group_id';
11547: l_custom_rec.attribute_value := l_org_sg;
11548: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11549: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11550: x_custom_output.EXTEND;
11551: x_custom_output(6) := l_custom_rec;
11552:
11553: l_custom_rec.attribute_name := ':l_resource_id';

Line 11555: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11551: x_custom_output(6) := l_custom_rec;
11552:
11553: l_custom_rec.attribute_name := ':l_resource_id';
11554: l_custom_rec.attribute_value := l_resource_id;
11555: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11556: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11557: x_custom_output.EXTEND;
11558: x_custom_output(7) := l_custom_rec;
11559:

Line 11556: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

11552:
11553: l_custom_rec.attribute_name := ':l_resource_id';
11554: l_custom_rec.attribute_value := l_resource_id;
11555: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11556: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11557: x_custom_output.EXTEND;
11558: x_custom_output(7) := l_custom_rec;
11559:
11560: -- test('GET_LEAD_OPP_CHART_SQL','QUERY','',l_query);

Line 11622: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
11625: p_period_type => l_period_type,
11626: p_record_type => l_record_type,

Line 11778: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11774:
11775:
11776: l_custom_rec.attribute_name := ':l_record_type';
11777: l_custom_rec.attribute_value := l_record_type;
11778: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11779: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11780: x_custom_output.EXTEND;
11781: x_custom_output(1) := l_custom_rec;
11782:

Line 11779: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

11775:
11776: l_custom_rec.attribute_name := ':l_record_type';
11777: l_custom_rec.attribute_value := l_record_type;
11778: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11779: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11780: x_custom_output.EXTEND;
11781: x_custom_output(1) := l_custom_rec;
11782:
11783: l_custom_rec.attribute_name := ':l_time_id';

Line 11785: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11781: x_custom_output(1) := l_custom_rec;
11782:
11783: l_custom_rec.attribute_name := ':l_time_id';
11784: l_custom_rec.attribute_value := l_curr_page_time_id;
11785: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11786: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11787: x_custom_output.EXTEND;
11788: x_custom_output(2) := l_custom_rec;
11789:

Line 11786: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

11782:
11783: l_custom_rec.attribute_name := ':l_time_id';
11784: l_custom_rec.attribute_value := l_curr_page_time_id;
11785: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11786: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11787: x_custom_output.EXTEND;
11788: x_custom_output(2) := l_custom_rec;
11789:
11790: l_custom_rec.attribute_name := ':l_period_type_id';

Line 11792: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11788: x_custom_output(2) := l_custom_rec;
11789:
11790: l_custom_rec.attribute_name := ':l_period_type_id';
11791: l_custom_rec.attribute_value := l_period_type;
11792: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11793: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11794: x_custom_output.EXTEND;
11795: x_custom_output(3) := l_custom_rec;
11796:

Line 11793: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

11789:
11790: l_custom_rec.attribute_name := ':l_period_type_id';
11791: l_custom_rec.attribute_value := l_period_type;
11792: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11793: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11794: x_custom_output.EXTEND;
11795: x_custom_output(3) := l_custom_rec;
11796:
11797: l_custom_rec.attribute_name := ':l_period_type';

Line 11799: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11795: x_custom_output(3) := l_custom_rec;
11796:
11797: l_custom_rec.attribute_name := ':l_period_type';
11798: l_custom_rec.attribute_value := l_period_type;
11799: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11800: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11801: x_custom_output.EXTEND;
11802: x_custom_output(4) := l_custom_rec;
11803:

Line 11800: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

11796:
11797: l_custom_rec.attribute_name := ':l_period_type';
11798: l_custom_rec.attribute_value := l_period_type;
11799: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11800: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
11801: x_custom_output.EXTEND;
11802: x_custom_output(4) := l_custom_rec;
11803:
11804: l_custom_rec.attribute_name := ':l_seq_date';

Line 11806: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11802: x_custom_output(4) := l_custom_rec;
11803:
11804: l_custom_rec.attribute_name := ':l_seq_date';
11805: l_custom_rec.attribute_value := to_char(l_seq_date,'DD-MON-YY');
11806: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11807: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
11808: x_custom_output.EXTEND;
11809: x_custom_output(5) := l_custom_rec;
11810:

Line 11807: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

11803:
11804: l_custom_rec.attribute_name := ':l_seq_date';
11805: l_custom_rec.attribute_value := to_char(l_seq_date,'DD-MON-YY');
11806: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11807: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
11808: x_custom_output.EXTEND;
11809: x_custom_output(5) := l_custom_rec;
11810:
11811: l_custom_rec.attribute_name := ':l_group_id';

Line 11813: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11809: x_custom_output(5) := l_custom_rec;
11810:
11811: l_custom_rec.attribute_name := ':l_group_id';
11812: l_custom_rec.attribute_value := l_org_sg;
11813: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11814: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11815: x_custom_output.EXTEND;
11816: x_custom_output(6) := l_custom_rec;
11817:

Line 11814: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

11810:
11811: l_custom_rec.attribute_name := ':l_group_id';
11812: l_custom_rec.attribute_value := l_org_sg;
11813: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11814: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11815: x_custom_output.EXTEND;
11816: x_custom_output(6) := l_custom_rec;
11817:
11818: l_custom_rec.attribute_name := ':l_resource_id';

Line 11820: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11816: x_custom_output(6) := l_custom_rec;
11817:
11818: l_custom_rec.attribute_name := ':l_resource_id';
11819: l_custom_rec.attribute_value := l_resource_id;
11820: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11821: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11822: x_custom_output.EXTEND;
11823: x_custom_output(7) := l_custom_rec;
11824:

Line 11821: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

11817:
11818: l_custom_rec.attribute_name := ':l_resource_id';
11819: l_custom_rec.attribute_value := l_resource_id;
11820: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11821: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
11822: x_custom_output.EXTEND;
11823: x_custom_output(7) := l_custom_rec;
11824:
11825: l_custom_rec.attribute_name := ':g_start_date';

Line 11827: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

11823: x_custom_output(7) := l_custom_rec;
11824:
11825: l_custom_rec.attribute_name := ':g_start_date';
11826: l_custom_rec.attribute_value := TO_CHAR(G_START_DATE,'MM-DD-YYYY');
11827: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11828: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
11829: x_custom_output.EXTEND;
11830: x_custom_output(8) := l_custom_rec;
11831:

Line 11828: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

11824:
11825: l_custom_rec.attribute_name := ':g_start_date';
11826: l_custom_rec.attribute_value := TO_CHAR(G_START_DATE,'MM-DD-YYYY');
11827: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
11828: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
11829: x_custom_output.EXTEND;
11830: x_custom_output(8) := l_custom_rec;
11831:
11832: EXCEPTION

Line 11917: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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:
11921: get_page_params (p_page_parameter_tbl =>p_page_parameter_tbl,

Line 12270: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12266:
12267:
12268: l_custom_rec.attribute_name := ':l_category_id';
12269: l_custom_rec.attribute_value := l_category_id;
12270: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12271: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12272: x_custom_output.EXTEND;
12273: x_custom_output(1) := l_custom_rec;
12274:

Line 12271: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

12267:
12268: l_custom_rec.attribute_name := ':l_category_id';
12269: l_custom_rec.attribute_value := l_category_id;
12270: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12271: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12272: x_custom_output.EXTEND;
12273: x_custom_output(1) := l_custom_rec;
12274:
12275: l_custom_rec.attribute_name := ':l_group_id';

Line 12277: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12273: x_custom_output(1) := l_custom_rec;
12274:
12275: l_custom_rec.attribute_name := ':l_group_id';
12276: l_custom_rec.attribute_value := l_org_sg;
12277: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12278: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12279: x_custom_output.EXTEND;
12280: x_custom_output(2) := l_custom_rec;
12281:

Line 12278: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

12274:
12275: l_custom_rec.attribute_name := ':l_group_id';
12276: l_custom_rec.attribute_value := l_org_sg;
12277: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12278: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12279: x_custom_output.EXTEND;
12280: x_custom_output(2) := l_custom_rec;
12281:
12282: l_custom_rec.attribute_name := ':l_resource_id';

Line 12284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12280: x_custom_output(2) := l_custom_rec;
12281:
12282: l_custom_rec.attribute_name := ':l_resource_id';
12283: l_custom_rec.attribute_value := l_resource_id;
12284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12286: x_custom_output.EXTEND;
12287: x_custom_output(3) := l_custom_rec;
12288:

Line 12285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

12281:
12282: l_custom_rec.attribute_name := ':l_resource_id';
12283: l_custom_rec.attribute_value := l_resource_id;
12284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12286: x_custom_output.EXTEND;
12287: x_custom_output(3) := l_custom_rec;
12288:
12289:

Line 12292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12288:
12289:
12290: l_custom_rec.attribute_name := ':g_start_date';
12291: l_custom_rec.attribute_value := TO_CHAR(G_START_DATE,'MM-DD-YYYY');
12292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
12294: x_custom_output.EXTEND;
12295: x_custom_output(4) := l_custom_rec;
12296:

Line 12293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

12289:
12290: l_custom_rec.attribute_name := ':g_start_date';
12291: l_custom_rec.attribute_value := TO_CHAR(G_START_DATE,'MM-DD-YYYY');
12292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
12294: x_custom_output.EXTEND;
12295: x_custom_output(4) := l_custom_rec;
12296:
12297: l_custom_rec.attribute_name := ':l_last_ref_date';

Line 12300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12296:
12297: l_custom_rec.attribute_name := ':l_last_ref_date';
12298: l_custom_rec.attribute_value := l_last_refresh;
12299: -- l_custom_rec.attribute_value :=l_last_refresh;
12300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.date_BIND;
12302: x_custom_output.EXTEND;
12303: x_custom_output(5) := l_custom_rec;
12304:

Line 12301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.date_BIND;

12297: l_custom_rec.attribute_name := ':l_last_ref_date';
12298: l_custom_rec.attribute_value := l_last_refresh;
12299: -- l_custom_rec.attribute_value :=l_last_refresh;
12300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.date_BIND;
12302: x_custom_output.EXTEND;
12303: x_custom_output(5) := l_custom_rec;
12304:
12305: l_custom_rec.attribute_name := ':l_age_frm';

Line 12307: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12303: x_custom_output(5) := l_custom_rec;
12304:
12305: l_custom_rec.attribute_name := ':l_age_frm';
12306: l_custom_rec.attribute_value := l_age_frm;
12307: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12308: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12309: x_custom_output.EXTEND;
12310: x_custom_output(6) := l_custom_rec;
12311:

Line 12308: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

12304:
12305: l_custom_rec.attribute_name := ':l_age_frm';
12306: l_custom_rec.attribute_value := l_age_frm;
12307: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12308: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12309: x_custom_output.EXTEND;
12310: x_custom_output(6) := l_custom_rec;
12311:
12312: l_custom_rec.attribute_name := ':l_age_to';

Line 12314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12310: x_custom_output(6) := l_custom_rec;
12311:
12312: l_custom_rec.attribute_name := ':l_age_to';
12313: l_custom_rec.attribute_value := l_age_to;
12314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12316: x_custom_output.EXTEND;
12317: x_custom_output(7) := l_custom_rec;
12318:

Line 12315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

12311:
12312: l_custom_rec.attribute_name := ':l_age_to';
12313: l_custom_rec.attribute_value := l_age_to;
12314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12316: x_custom_output.EXTEND;
12317: x_custom_output(7) := l_custom_rec;
12318:
12319: l_custom_rec.attribute_name := ':l_rank';

Line 12321: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12317: x_custom_output(7) := l_custom_rec;
12318:
12319: l_custom_rec.attribute_name := ':l_rank';
12320: l_custom_rec.attribute_value := l_rank;
12321: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12322: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12323: x_custom_output.EXTEND;
12324: x_custom_output(8) := l_custom_rec;
12325:

Line 12322: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

12318:
12319: l_custom_rec.attribute_name := ':l_rank';
12320: l_custom_rec.attribute_value := l_rank;
12321: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12322: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12323: x_custom_output.EXTEND;
12324: x_custom_output(8) := l_custom_rec;
12325:
12326: l_custom_rec.attribute_name := ':l_close_rs';

Line 12328: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12324: x_custom_output(8) := l_custom_rec;
12325:
12326: l_custom_rec.attribute_name := ':l_close_rs';
12327: l_custom_rec.attribute_value := l_close_rs;
12328: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12330: x_custom_output.EXTEND;
12331: x_custom_output(9) := l_custom_rec;
12332:

Line 12329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

12325:
12326: l_custom_rec.attribute_name := ':l_close_rs';
12327: l_custom_rec.attribute_value := l_close_rs;
12328: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12330: x_custom_output.EXTEND;
12331: x_custom_output(9) := l_custom_rec;
12332:
12333: l_custom_rec.attribute_name := ':l_view_id';

Line 12335: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12331: x_custom_output(9) := l_custom_rec;
12332:
12333: l_custom_rec.attribute_name := ':l_view_id';
12334: l_custom_rec.attribute_value := ''''||l_view_id||'''';
12335: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12336: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12337: x_custom_output.EXTEND;
12338: x_custom_output(10) := l_custom_rec;
12339: --test('GET_LEAD_DETAIL_SQL','QUERY','',l_query);

Line 12336: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

12332:
12333: l_custom_rec.attribute_name := ':l_view_id';
12334: l_custom_rec.attribute_value := ''''||l_view_id||'''';
12335: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12336: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12337: x_custom_output.EXTEND;
12338: x_custom_output(10) := l_custom_rec;
12339: --test('GET_LEAD_DETAIL_SQL','QUERY','',l_query);
12340: EXCEPTION

Line 12434: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,
12438: p_record_type => l_record_type,

Line 12799: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12795:
12796:
12797: l_custom_rec.attribute_name := ':l_category_id';
12798: l_custom_rec.attribute_value := l_category_id;
12799: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12800: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12801: x_custom_output.EXTEND;
12802: x_custom_output(1) := l_custom_rec;
12803:

Line 12800: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

12796:
12797: l_custom_rec.attribute_name := ':l_category_id';
12798: l_custom_rec.attribute_value := l_category_id;
12799: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12800: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12801: x_custom_output.EXTEND;
12802: x_custom_output(1) := l_custom_rec;
12803:
12804: l_custom_rec.attribute_name := ':l_group_id';

Line 12806: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12802: x_custom_output(1) := l_custom_rec;
12803:
12804: l_custom_rec.attribute_name := ':l_group_id';
12805: l_custom_rec.attribute_value := l_org_sg;
12806: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12807: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12808: x_custom_output.EXTEND;
12809: x_custom_output(2) := l_custom_rec;
12810:

Line 12807: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

12803:
12804: l_custom_rec.attribute_name := ':l_group_id';
12805: l_custom_rec.attribute_value := l_org_sg;
12806: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12807: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12808: x_custom_output.EXTEND;
12809: x_custom_output(2) := l_custom_rec;
12810:
12811: l_custom_rec.attribute_name := ':l_resource_id';

Line 12813: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12809: x_custom_output(2) := l_custom_rec;
12810:
12811: l_custom_rec.attribute_name := ':l_resource_id';
12812: l_custom_rec.attribute_value := l_resource_id;
12813: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12814: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12815: x_custom_output.EXTEND;
12816: x_custom_output(3) := l_custom_rec;
12817:

Line 12814: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

12810:
12811: l_custom_rec.attribute_name := ':l_resource_id';
12812: l_custom_rec.attribute_value := l_resource_id;
12813: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12814: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12815: x_custom_output.EXTEND;
12816: x_custom_output(3) := l_custom_rec;
12817:
12818:

Line 12821: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12817:
12818:
12819: l_custom_rec.attribute_name := ':g_start_date';
12820: l_custom_rec.attribute_value := TO_CHAR(G_START_DATE,'MM-DD-YYYY');
12821: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12822: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
12823: x_custom_output.EXTEND;
12824: x_custom_output(4) := l_custom_rec;
12825:

Line 12822: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

12818:
12819: l_custom_rec.attribute_name := ':g_start_date';
12820: l_custom_rec.attribute_value := TO_CHAR(G_START_DATE,'MM-DD-YYYY');
12821: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12822: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
12823: x_custom_output.EXTEND;
12824: x_custom_output(4) := l_custom_rec;
12825:
12826: l_custom_rec.attribute_name := ':l_last_ref_date';

Line 12829: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12825:
12826: l_custom_rec.attribute_name := ':l_last_ref_date';
12827: l_custom_rec.attribute_value := l_last_refresh;
12828: -- l_custom_rec.attribute_value :=l_last_refresh;
12829: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12830: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.date_BIND;
12831: x_custom_output.EXTEND;
12832: x_custom_output(5) := l_custom_rec;
12833:

Line 12830: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.date_BIND;

12826: l_custom_rec.attribute_name := ':l_last_ref_date';
12827: l_custom_rec.attribute_value := l_last_refresh;
12828: -- l_custom_rec.attribute_value :=l_last_refresh;
12829: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12830: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.date_BIND;
12831: x_custom_output.EXTEND;
12832: x_custom_output(5) := l_custom_rec;
12833:
12834: l_custom_rec.attribute_name := ':l_age_frm';

Line 12836: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12832: x_custom_output(5) := l_custom_rec;
12833:
12834: l_custom_rec.attribute_name := ':l_age_frm';
12835: l_custom_rec.attribute_value := l_age_frm;
12836: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12837: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12838: x_custom_output.EXTEND;
12839: x_custom_output(6) := l_custom_rec;
12840:

Line 12837: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

12833:
12834: l_custom_rec.attribute_name := ':l_age_frm';
12835: l_custom_rec.attribute_value := l_age_frm;
12836: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12837: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12838: x_custom_output.EXTEND;
12839: x_custom_output(6) := l_custom_rec;
12840:
12841: l_custom_rec.attribute_name := ':l_age_to';

Line 12843: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12839: x_custom_output(6) := l_custom_rec;
12840:
12841: l_custom_rec.attribute_name := ':l_age_to';
12842: l_custom_rec.attribute_value := l_age_to;
12843: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12844: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12845: x_custom_output.EXTEND;
12846: x_custom_output(7) := l_custom_rec;
12847:

Line 12844: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

12840:
12841: l_custom_rec.attribute_name := ':l_age_to';
12842: l_custom_rec.attribute_value := l_age_to;
12843: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12844: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
12845: x_custom_output.EXTEND;
12846: x_custom_output(7) := l_custom_rec;
12847:
12848: l_custom_rec.attribute_name := ':l_rank';

Line 12850: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12846: x_custom_output(7) := l_custom_rec;
12847:
12848: l_custom_rec.attribute_name := ':l_rank';
12849: l_custom_rec.attribute_value := l_rank;
12850: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12851: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12852: x_custom_output.EXTEND;
12853: x_custom_output(8) := l_custom_rec;
12854:

Line 12851: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

12847:
12848: l_custom_rec.attribute_name := ':l_rank';
12849: l_custom_rec.attribute_value := l_rank;
12850: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12851: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12852: x_custom_output.EXTEND;
12853: x_custom_output(8) := l_custom_rec;
12854:
12855: l_custom_rec.attribute_name := ':l_close_rs';

Line 12857: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12853: x_custom_output(8) := l_custom_rec;
12854:
12855: l_custom_rec.attribute_name := ':l_close_rs';
12856: l_custom_rec.attribute_value := l_close_rs;
12857: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12858: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12859: x_custom_output.EXTEND;
12860: x_custom_output(9) := l_custom_rec;
12861:

Line 12858: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

12854:
12855: l_custom_rec.attribute_name := ':l_close_rs';
12856: l_custom_rec.attribute_value := l_close_rs;
12857: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12858: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12859: x_custom_output.EXTEND;
12860: x_custom_output(9) := l_custom_rec;
12861:
12862: l_custom_rec.attribute_name := ':l_view_id';

Line 12864: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

12860: x_custom_output(9) := l_custom_rec;
12861:
12862: l_custom_rec.attribute_name := ':l_view_id';
12863: l_custom_rec.attribute_value := ''''||l_view_id||'''';
12864: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12865: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12866: x_custom_output.EXTEND;
12867: x_custom_output(10) := l_custom_rec;
12868:

Line 12865: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

12861:
12862: l_custom_rec.attribute_name := ':l_view_id';
12863: l_custom_rec.attribute_value := ''''||l_view_id||'''';
12864: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
12865: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
12866: x_custom_output.EXTEND;
12867: x_custom_output(10) := l_custom_rec;
12868:
12869: