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.OZF_BUDGETAPPROVAL_PVT dependencies on FND_DSQL

Line 838: FND_DSQL.init;

834: x_budget_prod := FALSE;
835: x_exclude_prod := FALSE;
836: SAVEPOINT denorm_product_for_one_budget;
837:
838: FND_DSQL.init;
839: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
840: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
841: -- Get all product qualifiers for 'FUND'
842: OPEN c_get_products(p_budget_id, 'FUND', 'N');

Line 839: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

835: x_exclude_prod := FALSE;
836: SAVEPOINT denorm_product_for_one_budget;
837:
838: FND_DSQL.init;
839: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
840: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
841: -- Get all product qualifiers for 'FUND'
842: OPEN c_get_products(p_budget_id, 'FUND', 'N');
843: LOOP

Line 840: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');

836: SAVEPOINT denorm_product_for_one_budget;
837:
838: FND_DSQL.init;
839: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
840: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
841: -- Get all product qualifiers for 'FUND'
842: OPEN c_get_products(p_budget_id, 'FUND', 'N');
843: LOOP
844: FETCH c_get_products INTO l_attr_value,l_excluded_flag,l_attribute;

Line 851: FND_DSQL.add_text('(');

847: x_budget_prod := TRUE;
848: END IF;
849:
850: IF c_get_products%ROWCOUNT = 1 THEN -- for first row.
851: FND_DSQL.add_text('(');
852: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
853: ( p_context => 'ITEM',
854: p_attribute => l_attribute,
855: p_attr_value_from => l_attr_value,

Line 860: FND_DSQL.add_text(')');

856: p_attr_value_to => NULL,
857: p_comparison => NULL,
858: p_type => 'PROD'
859: );
860: FND_DSQL.add_text(')');
861: ELSE
862: FND_DSQL.add_text('UNION (');
863: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
864: ( p_context => 'ITEM',

Line 862: FND_DSQL.add_text('UNION (');

858: p_type => 'PROD'
859: );
860: FND_DSQL.add_text(')');
861: ELSE
862: FND_DSQL.add_text('UNION (');
863: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
864: ( p_context => 'ITEM',
865: p_attribute => l_attribute,
866: p_attr_value_from => l_attr_value,

Line 871: FND_DSQL.add_text(')');

867: p_attr_value_to => NULL,
868: p_comparison => NULL,
869: p_type => 'PROD'
870: );
871: FND_DSQL.add_text(')');
872: END IF;
873:
874: END LOOP;
875:

Line 877: FND_DSQL.add_text(')');

873:
874: END LOOP;
875:
876: CLOSE c_get_products;
877: FND_DSQL.add_text(')');
878:
879: IF x_budget_prod THEN
880:
881: l_denorm_csr := DBMS_SQL.open_cursor;

Line 882: FND_DSQL.set_cursor(l_denorm_csr);

878:
879: IF x_budget_prod THEN
880:
881: l_denorm_csr := DBMS_SQL.open_cursor;
882: FND_DSQL.set_cursor(l_denorm_csr);
883:
884: l_stmt_denorm := FND_DSQL.get_text(FALSE);
885: --dbms_output.put_line('budget query:' || l_stmt_denorm);
886: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 884: l_stmt_denorm := FND_DSQL.get_text(FALSE);

880:
881: l_denorm_csr := DBMS_SQL.open_cursor;
882: FND_DSQL.set_cursor(l_denorm_csr);
883:
884: l_stmt_denorm := FND_DSQL.get_text(FALSE);
885: --dbms_output.put_line('budget query:' || l_stmt_denorm);
886: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
887: FND_DSQL.do_binds;
888: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 887: FND_DSQL.do_binds;

883:
884: l_stmt_denorm := FND_DSQL.get_text(FALSE);
885: --dbms_output.put_line('budget query:' || l_stmt_denorm);
886: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
887: FND_DSQL.do_binds;
888: l_ignore := DBMS_SQL.execute(l_denorm_csr);
889: END IF;
890:
891: FND_DSQL.init;

Line 891: FND_DSQL.init;

887: FND_DSQL.do_binds;
888: l_ignore := DBMS_SQL.execute(l_denorm_csr);
889: END IF;
890:
891: FND_DSQL.init;
892: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
893: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
894: -- for exclude product of FUND.
895:

Line 892: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

888: l_ignore := DBMS_SQL.execute(l_denorm_csr);
889: END IF;
890:
891: FND_DSQL.init;
892: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
893: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
894: -- for exclude product of FUND.
895:
896: OPEN c_get_products(p_budget_id,'FUND','Y');

Line 893: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');

889: END IF;
890:
891: FND_DSQL.init;
892: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
893: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
894: -- for exclude product of FUND.
895:
896: OPEN c_get_products(p_budget_id,'FUND','Y');
897: LOOP

Line 906: FND_DSQL.add_text('(');

902: END IF;
903:
904: IF c_get_products%ROWCOUNT = 1 THEN
905: -- l_exclude_sql := '(' || l_temp_sql || ')';
906: FND_DSQL.add_text('(');
907: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
908: ( p_context => 'ITEM',
909: p_attribute => l_attribute,
910: p_attr_value_from => l_attr_value,

Line 915: FND_DSQL.add_text(')');

911: p_attr_value_to => NULL,
912: p_comparison => NULL,
913: p_type => 'PROD'
914: );
915: FND_DSQL.add_text(')');
916: ELSE
917: --l_exclude_sql := l_exclude_sql || ' UNION (' || l_temp_sql || ')';
918: FND_DSQL.add_text('UNION (');
919: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 918: FND_DSQL.add_text('UNION (');

914: );
915: FND_DSQL.add_text(')');
916: ELSE
917: --l_exclude_sql := l_exclude_sql || ' UNION (' || l_temp_sql || ')';
918: FND_DSQL.add_text('UNION (');
919: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
920: ( p_context => 'ITEM',
921: p_attribute => l_attribute,
922: p_attr_value_from => l_attr_value,

Line 927: FND_DSQL.add_text(')');

923: p_attr_value_to => NULL,
924: p_comparison => NULL,
925: p_type => 'PROD'
926: );
927: FND_DSQL.add_text(')');
928: END IF;
929:
930: END LOOP;
931: CLOSE c_get_products;

Line 932: FND_DSQL.add_text(')');

928: END IF;
929:
930: END LOOP;
931: CLOSE c_get_products;
932: FND_DSQL.add_text(')');
933:
934: IF x_exclude_prod THEN
935: l_denorm_csr := DBMS_SQL.open_cursor;
936: FND_DSQL.set_cursor(l_denorm_csr);

Line 936: FND_DSQL.set_cursor(l_denorm_csr);

932: FND_DSQL.add_text(')');
933:
934: IF x_exclude_prod THEN
935: l_denorm_csr := DBMS_SQL.open_cursor;
936: FND_DSQL.set_cursor(l_denorm_csr);
937: l_stmt_denorm := FND_DSQL.get_text(FALSE);
938: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
939: FND_DSQL.do_binds;
940: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 937: l_stmt_denorm := FND_DSQL.get_text(FALSE);

933:
934: IF x_exclude_prod THEN
935: l_denorm_csr := DBMS_SQL.open_cursor;
936: FND_DSQL.set_cursor(l_denorm_csr);
937: l_stmt_denorm := FND_DSQL.get_text(FALSE);
938: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
939: FND_DSQL.do_binds;
940: l_ignore := DBMS_SQL.execute(l_denorm_csr);
941: END IF;

Line 939: FND_DSQL.do_binds;

935: l_denorm_csr := DBMS_SQL.open_cursor;
936: FND_DSQL.set_cursor(l_denorm_csr);
937: l_stmt_denorm := FND_DSQL.get_text(FALSE);
938: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
939: FND_DSQL.do_binds;
940: l_ignore := DBMS_SQL.execute(l_denorm_csr);
941: END IF;
942:
943: EXCEPTION

Line 992: FND_DSQL.init;

988: x_budget_mark := FALSE;
989: x_exclude_mark := FALSE;
990: SAVEPOINT denorm_market_for_one_budget;
991:
992: FND_DSQL.init;
993: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
994: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
995:
996: OPEN c_get_budget_market_qualifiers('N');

Line 993: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

989: x_exclude_mark := FALSE;
990: SAVEPOINT denorm_market_for_one_budget;
991:
992: FND_DSQL.init;
993: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
994: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
995:
996: OPEN c_get_budget_market_qualifiers('N');
997:

Line 994: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');

990: SAVEPOINT denorm_market_for_one_budget;
991:
992: FND_DSQL.init;
993: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
994: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
995:
996: OPEN c_get_budget_market_qualifiers('N');
997:
998: -- Get all market qualifiers for 'FUND'

Line 1037: FND_DSQL.add_text('(');

1033: l_attr_value := l_segment_id;
1034:
1035: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
1036: -- l_budget_product_sql := '(' || l_temp_sql || ')';
1037: FND_DSQL.add_text('(');
1038: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1039: ( p_context => l_context,
1040: p_attribute => l_attribute,
1041: p_attr_value_from => l_attr_value,

Line 1046: FND_DSQL.add_text(')');

1042: p_attr_value_to => NULL,
1043: p_comparison => '=',
1044: p_type => 'ELIG'
1045: );
1046: FND_DSQL.add_text(')');
1047: ELSE
1048: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
1049: FND_DSQL.add_text('UNION (');
1050: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 1049: FND_DSQL.add_text('UNION (');

1045: );
1046: FND_DSQL.add_text(')');
1047: ELSE
1048: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
1049: FND_DSQL.add_text('UNION (');
1050: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1051: ( p_context => l_context,
1052: p_attribute => l_attribute,
1053: p_attr_value_from => l_attr_value,

Line 1058: FND_DSQL.add_text(')');

1054: p_attr_value_to => NULL,
1055: p_comparison => '=',
1056: p_type => 'ELIG'
1057: );
1058: FND_DSQL.add_text(')');
1059: END IF;
1060: ----dbms_output.put_line('budget:' || l_temp_sql );
1061:
1062: END LOOP;

Line 1064: FND_DSQL.add_text(')');

1060: ----dbms_output.put_line('budget:' || l_temp_sql );
1061:
1062: END LOOP;
1063: CLOSE c_get_budget_market_qualifiers;
1064: FND_DSQL.add_text(')');
1065:
1066: IF x_budget_mark THEN
1067: l_denorm_csr := DBMS_SQL.open_cursor;
1068: FND_DSQL.set_cursor(l_denorm_csr);

Line 1068: FND_DSQL.set_cursor(l_denorm_csr);

1064: FND_DSQL.add_text(')');
1065:
1066: IF x_budget_mark THEN
1067: l_denorm_csr := DBMS_SQL.open_cursor;
1068: FND_DSQL.set_cursor(l_denorm_csr);
1069: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1070: -- l_budget_market_sql := l_stmt_denorm;
1071: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1072: FND_DSQL.do_binds;

Line 1069: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1065:
1066: IF x_budget_mark THEN
1067: l_denorm_csr := DBMS_SQL.open_cursor;
1068: FND_DSQL.set_cursor(l_denorm_csr);
1069: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1070: -- l_budget_market_sql := l_stmt_denorm;
1071: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1072: FND_DSQL.do_binds;
1073: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1072: FND_DSQL.do_binds;

1068: FND_DSQL.set_cursor(l_denorm_csr);
1069: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1070: -- l_budget_market_sql := l_stmt_denorm;
1071: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1072: FND_DSQL.do_binds;
1073: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1074: --dbms_output.put_line(l_ignore);
1075: END IF;
1076:

Line 1077: FND_DSQL.init;

1073: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1074: --dbms_output.put_line(l_ignore);
1075: END IF;
1076:
1077: FND_DSQL.init;
1078: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1079: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
1080:
1081: OPEN c_get_budget_market_qualifiers('Y');

Line 1078: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1074: --dbms_output.put_line(l_ignore);
1075: END IF;
1076:
1077: FND_DSQL.init;
1078: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1079: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
1080:
1081: OPEN c_get_budget_market_qualifiers('Y');
1082: -- Get all excluded market qualifiers for 'FUND'

Line 1079: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');

1075: END IF;
1076:
1077: FND_DSQL.init;
1078: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1079: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
1080:
1081: OPEN c_get_budget_market_qualifiers('Y');
1082: -- Get all excluded market qualifiers for 'FUND'
1083: LOOP

Line 1121: FND_DSQL.add_text('(');

1117: l_attr_value := l_segment_id;
1118:
1119: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
1120: -- l_budget_product_sql := '(' || l_temp_sql || ')';
1121: FND_DSQL.add_text('(');
1122: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1123: ( p_context => l_context,
1124: p_attribute => l_attribute,
1125: p_attr_value_from => l_attr_value,

Line 1130: FND_DSQL.add_text(')');

1126: p_attr_value_to => NULL,
1127: p_comparison => '=',
1128: p_type => 'ELIG'
1129: );
1130: FND_DSQL.add_text(')');
1131: ELSE
1132: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
1133: FND_DSQL.add_text('UNION (');
1134: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 1133: FND_DSQL.add_text('UNION (');

1129: );
1130: FND_DSQL.add_text(')');
1131: ELSE
1132: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
1133: FND_DSQL.add_text('UNION (');
1134: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1135: ( p_context => l_context,
1136: p_attribute => l_attribute,
1137: p_attr_value_from => l_attr_value,

Line 1142: FND_DSQL.add_text(')');

1138: p_attr_value_to => NULL,
1139: p_comparison => '=',
1140: p_type => 'ELIG'
1141: );
1142: FND_DSQL.add_text(')');
1143: END IF;
1144:
1145: END LOOP;
1146: CLOSE c_get_budget_market_qualifiers;

Line 1147: FND_DSQL.add_text(')');

1143: END IF;
1144:
1145: END LOOP;
1146: CLOSE c_get_budget_market_qualifiers;
1147: FND_DSQL.add_text(')');
1148: IF x_exclude_mark THEN
1149: l_denorm_csr := DBMS_SQL.open_cursor;
1150: FND_DSQL.set_cursor(l_denorm_csr);
1151: l_stmt_denorm := FND_DSQL.get_text(FALSE);

Line 1150: FND_DSQL.set_cursor(l_denorm_csr);

1146: CLOSE c_get_budget_market_qualifiers;
1147: FND_DSQL.add_text(')');
1148: IF x_exclude_mark THEN
1149: l_denorm_csr := DBMS_SQL.open_cursor;
1150: FND_DSQL.set_cursor(l_denorm_csr);
1151: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1152: --dbms_output.put_line('Budget exclude query:' || l_stmt_denorm);
1153: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1154: FND_DSQL.do_binds;

Line 1151: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1147: FND_DSQL.add_text(')');
1148: IF x_exclude_mark THEN
1149: l_denorm_csr := DBMS_SQL.open_cursor;
1150: FND_DSQL.set_cursor(l_denorm_csr);
1151: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1152: --dbms_output.put_line('Budget exclude query:' || l_stmt_denorm);
1153: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1154: FND_DSQL.do_binds;
1155: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1154: FND_DSQL.do_binds;

1150: FND_DSQL.set_cursor(l_denorm_csr);
1151: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1152: --dbms_output.put_line('Budget exclude query:' || l_stmt_denorm);
1153: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1154: FND_DSQL.do_binds;
1155: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1156: --dbms_output.put_line(l_ignore);
1157: END IF;
1158:

Line 1251: FND_DSQL.init;

1247: l_exclude_only := TRUE;
1248: END IF;
1249:
1250:
1251: FND_DSQL.init;
1252: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1253: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1254: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1255: OPEN c_get_products(p_object_id,'OFFR','N');

Line 1252: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1248: END IF;
1249:
1250:
1251: FND_DSQL.init;
1252: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1253: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1254: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1255: OPEN c_get_products(p_object_id,'OFFR','N');
1256: LOOP

Line 1253: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );

1249:
1250:
1251: FND_DSQL.init;
1252: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1253: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1254: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1255: OPEN c_get_products(p_object_id,'OFFR','N');
1256: LOOP
1257: FETCH c_get_products INTO l_attr_value,l_excluded_flag,l_attribute;

Line 1265: FND_DSQL.add_text('(');

1261: END IF;
1262:
1263: IF c_get_products%ROWCOUNT = 1 THEN
1264: -- l_offer_product_sql := '(' || l_temp_sql || ')';
1265: FND_DSQL.add_text('(');
1266: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1267: ( p_context => 'ITEM',
1268: p_attribute => l_attribute,
1269: p_attr_value_from => l_attr_value,

Line 1274: FND_DSQL.add_text(')');

1270: p_attr_value_to => NULL,
1271: p_comparison => NULL,
1272: p_type => 'PROD'
1273: );
1274: FND_DSQL.add_text(')');
1275: ELSE
1276: --l_offer_product_sql := l_offer_product_sql || ' UNION (' || l_temp_sql || ')';
1277: FND_DSQL.add_text('UNION (');
1278: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 1277: FND_DSQL.add_text('UNION (');

1273: );
1274: FND_DSQL.add_text(')');
1275: ELSE
1276: --l_offer_product_sql := l_offer_product_sql || ' UNION (' || l_temp_sql || ')';
1277: FND_DSQL.add_text('UNION (');
1278: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1279: ( p_context => 'ITEM',
1280: p_attribute => l_attribute,
1281: p_attr_value_from => l_attr_value,

Line 1286: FND_DSQL.add_text(')');

1282: p_attr_value_to => NULL,
1283: p_comparison => NULL,
1284: p_type => 'PROD'
1285: );
1286: FND_DSQL.add_text(')');
1287: END IF;
1288: END LOOP;
1289: CLOSE c_get_products;
1290:

Line 1311: FND_DSQL.add_text(')');

1307: RAISE fnd_api.G_EXC_ERROR;
1308: END IF;
1309:
1310: END IF;
1311: FND_DSQL.add_text(')');
1312:
1313: IF l_offer_product_sql IS NULL AND l_offer_prod = FALSE THEN
1314: x_return_status := fnd_api.g_ret_sts_success;
1315: x_valid_flag := fnd_api.g_false;

Line 1321: FND_DSQL.set_cursor(l_denorm_csr);

1317: END IF;
1318:
1319: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1320: l_denorm_csr := DBMS_SQL.open_cursor;
1321: FND_DSQL.set_cursor(l_denorm_csr);
1322: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1323: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1324: FND_DSQL.do_binds;
1325: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1322: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1318:
1319: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1320: l_denorm_csr := DBMS_SQL.open_cursor;
1321: FND_DSQL.set_cursor(l_denorm_csr);
1322: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1323: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1324: FND_DSQL.do_binds;
1325: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1326: --dbms_output.put_line(l_ignore);

Line 1324: FND_DSQL.do_binds;

1320: l_denorm_csr := DBMS_SQL.open_cursor;
1321: FND_DSQL.set_cursor(l_denorm_csr);
1322: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1323: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1324: FND_DSQL.do_binds;
1325: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1326: --dbms_output.put_line(l_ignore);
1327: END IF;
1328:

Line 1449: FND_DSQL.init;

1445: x_valid_flag := fnd_api.G_TRUE;
1446:
1447: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1448:
1449: FND_DSQL.init;
1450: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1451: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
1452: -- Get all product qualifiers for 'FUND'
1453: OPEN c_get_budget_products('N');

Line 1450: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1446:
1447: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1448:
1449: FND_DSQL.init;
1450: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1451: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
1452: -- Get all product qualifiers for 'FUND'
1453: OPEN c_get_budget_products('N');
1454: LOOP

Line 1451: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');

1447: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1448:
1449: FND_DSQL.init;
1450: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1451: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
1452: -- Get all product qualifiers for 'FUND'
1453: OPEN c_get_budget_products('N');
1454: LOOP
1455: FETCH c_get_budget_products INTO l_attr_value,l_excluded_flag,l_attribute;

Line 1463: FND_DSQL.add_text('(');

1459: l_budget_prod := TRUE;
1460: END IF;
1461:
1462: IF c_get_budget_products%ROWCOUNT = 1 THEN -- for first row.
1463: FND_DSQL.add_text('(');
1464: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1465: ( p_context => 'ITEM',
1466: p_attribute => l_attribute,
1467: p_attr_value_from => l_attr_value,

Line 1472: FND_DSQL.add_text(')');

1468: p_attr_value_to => NULL,
1469: p_comparison => NULL,
1470: p_type => 'PROD'
1471: );
1472: FND_DSQL.add_text(')');
1473: ELSE
1474: FND_DSQL.add_text('UNION (');
1475: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1476: ( p_context => 'ITEM',

Line 1474: FND_DSQL.add_text('UNION (');

1470: p_type => 'PROD'
1471: );
1472: FND_DSQL.add_text(')');
1473: ELSE
1474: FND_DSQL.add_text('UNION (');
1475: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1476: ( p_context => 'ITEM',
1477: p_attribute => l_attribute,
1478: p_attr_value_from => l_attr_value,

Line 1483: FND_DSQL.add_text(')');

1479: p_attr_value_to => NULL,
1480: p_comparison => NULL,
1481: p_type => 'PROD'
1482: );
1483: FND_DSQL.add_text(')');
1484: END IF;
1485: --dbms_output.put_line('validate_product_by_all_lines: budget:');
1486: --dbms_output.put_line('validate_product_by_all_lines: budget:' || l_temp_sql);
1487:

Line 1490: FND_DSQL.add_text(')');

1486: --dbms_output.put_line('validate_product_by_all_lines: budget:' || l_temp_sql);
1487:
1488: END LOOP;
1489: CLOSE c_get_budget_products;
1490: FND_DSQL.add_text(')');
1491:
1492: IF l_budget_prod THEN
1493: l_denorm_csr := DBMS_SQL.open_cursor;
1494: FND_DSQL.set_cursor(l_denorm_csr);

Line 1494: FND_DSQL.set_cursor(l_denorm_csr);

1490: FND_DSQL.add_text(')');
1491:
1492: IF l_budget_prod THEN
1493: l_denorm_csr := DBMS_SQL.open_cursor;
1494: FND_DSQL.set_cursor(l_denorm_csr);
1495: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1496: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1497: FND_DSQL.do_binds;
1498: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1495: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1491:
1492: IF l_budget_prod THEN
1493: l_denorm_csr := DBMS_SQL.open_cursor;
1494: FND_DSQL.set_cursor(l_denorm_csr);
1495: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1496: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1497: FND_DSQL.do_binds;
1498: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1499: --dbms_output.put_line(l_ignore);

Line 1497: FND_DSQL.do_binds;

1493: l_denorm_csr := DBMS_SQL.open_cursor;
1494: FND_DSQL.set_cursor(l_denorm_csr);
1495: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1496: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1497: FND_DSQL.do_binds;
1498: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1499: --dbms_output.put_line(l_ignore);
1500: END IF;
1501:

Line 1502: FND_DSQL.init;

1498: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1499: --dbms_output.put_line(l_ignore);
1500: END IF;
1501:
1502: FND_DSQL.init;
1503: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1504: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
1505: -- for exclude product of FUND.
1506:

Line 1503: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1499: --dbms_output.put_line(l_ignore);
1500: END IF;
1501:
1502: FND_DSQL.init;
1503: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1504: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
1505: -- for exclude product of FUND.
1506:
1507: OPEN c_get_budget_products('Y');

Line 1504: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');

1500: END IF;
1501:
1502: FND_DSQL.init;
1503: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1504: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
1505: -- for exclude product of FUND.
1506:
1507: OPEN c_get_budget_products('Y');
1508: LOOP

Line 1518: FND_DSQL.add_text('(');

1514: END IF;
1515:
1516: IF c_get_budget_products%ROWCOUNT = 1 THEN
1517: -- l_exclude_sql := '(' || l_temp_sql || ')';
1518: FND_DSQL.add_text('(');
1519: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1520: ( p_context => 'ITEM',
1521: p_attribute => l_attribute,
1522: p_attr_value_from => l_attr_value,

Line 1527: FND_DSQL.add_text(')');

1523: p_attr_value_to => NULL,
1524: p_comparison => NULL,
1525: p_type => 'PROD'
1526: );
1527: FND_DSQL.add_text(')');
1528: ELSE
1529: --l_exclude_sql := l_exclude_sql || ' UNION (' || l_temp_sql || ')';
1530: FND_DSQL.add_text('UNION (');
1531: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 1530: FND_DSQL.add_text('UNION (');

1526: );
1527: FND_DSQL.add_text(')');
1528: ELSE
1529: --l_exclude_sql := l_exclude_sql || ' UNION (' || l_temp_sql || ')';
1530: FND_DSQL.add_text('UNION (');
1531: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1532: ( p_context => 'ITEM',
1533: p_attribute => l_attribute,
1534: p_attr_value_from => l_attr_value,

Line 1539: FND_DSQL.add_text(')');

1535: p_attr_value_to => NULL,
1536: p_comparison => NULL,
1537: p_type => 'PROD'
1538: );
1539: FND_DSQL.add_text(')');
1540: END IF;
1541:
1542: END LOOP;
1543: CLOSE c_get_budget_products;

Line 1544: FND_DSQL.add_text(')');

1540: END IF;
1541:
1542: END LOOP;
1543: CLOSE c_get_budget_products;
1544: FND_DSQL.add_text(')');
1545:
1546: IF l_exclude_prod THEN
1547: l_denorm_csr := DBMS_SQL.open_cursor;
1548: FND_DSQL.set_cursor(l_denorm_csr);

Line 1548: FND_DSQL.set_cursor(l_denorm_csr);

1544: FND_DSQL.add_text(')');
1545:
1546: IF l_exclude_prod THEN
1547: l_denorm_csr := DBMS_SQL.open_cursor;
1548: FND_DSQL.set_cursor(l_denorm_csr);
1549: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1550: --dbms_output.put_line('validate_product_by_all_lines: in budget exclude');
1551: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1552: FND_DSQL.do_binds;

Line 1549: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1545:
1546: IF l_exclude_prod THEN
1547: l_denorm_csr := DBMS_SQL.open_cursor;
1548: FND_DSQL.set_cursor(l_denorm_csr);
1549: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1550: --dbms_output.put_line('validate_product_by_all_lines: in budget exclude');
1551: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1552: FND_DSQL.do_binds;
1553: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1552: FND_DSQL.do_binds;

1548: FND_DSQL.set_cursor(l_denorm_csr);
1549: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1550: --dbms_output.put_line('validate_product_by_all_lines: in budget exclude');
1551: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1552: FND_DSQL.do_binds;
1553: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1554: --dbms_output.put_line(l_ignore);
1555: END IF;
1556: -- not product eligibility for budget, validation is true.

Line 1567: FND_DSQL.init;

1563: IF l_budget_prod = FALSE AND l_exclude_prod = TRUE THEN
1564: l_exclude_only := TRUE;
1565: END IF;
1566:
1567: FND_DSQL.init;
1568: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1569: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1570: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1571: OPEN c_get_offer_products;

Line 1568: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1564: l_exclude_only := TRUE;
1565: END IF;
1566:
1567: FND_DSQL.init;
1568: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1569: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1570: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1571: OPEN c_get_offer_products;
1572: LOOP

Line 1569: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );

1565: END IF;
1566:
1567: FND_DSQL.init;
1568: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1569: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1570: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1571: OPEN c_get_offer_products;
1572: LOOP
1573: FETCH c_get_offer_products INTO l_attr_value,l_excluded_flag,l_attribute;

Line 1581: FND_DSQL.add_text('(');

1577: END IF;
1578:
1579: IF c_get_offer_products%ROWCOUNT = 1 THEN
1580: -- l_offer_product_sql := '(' || l_temp_sql || ')';
1581: FND_DSQL.add_text('(');
1582: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1583: ( p_context => 'ITEM',
1584: p_attribute => l_attribute,
1585: p_attr_value_from => l_attr_value,

Line 1590: FND_DSQL.add_text(')');

1586: p_attr_value_to => NULL,
1587: p_comparison => NULL,
1588: p_type => 'PROD'
1589: );
1590: FND_DSQL.add_text(')');
1591: ELSE
1592: --l_offer_product_sql := l_offer_product_sql || ' UNION (' || l_temp_sql || ')';
1593: FND_DSQL.add_text('UNION (');
1594: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 1593: FND_DSQL.add_text('UNION (');

1589: );
1590: FND_DSQL.add_text(')');
1591: ELSE
1592: --l_offer_product_sql := l_offer_product_sql || ' UNION (' || l_temp_sql || ')';
1593: FND_DSQL.add_text('UNION (');
1594: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1595: ( p_context => 'ITEM',
1596: p_attribute => l_attribute,
1597: p_attr_value_from => l_attr_value,

Line 1602: FND_DSQL.add_text(')');

1598: p_attr_value_to => NULL,
1599: p_comparison => NULL,
1600: p_type => 'PROD'
1601: );
1602: FND_DSQL.add_text(')');
1603: END IF;
1604: END LOOP;
1605: CLOSE c_get_offer_products;
1606:

Line 1625: FND_DSQL.add_text(')');

1621: x_return_status := l_return_status;
1622: RAISE fnd_api.G_EXC_ERROR;
1623: END IF;
1624: END IF;
1625: FND_DSQL.add_text(')');
1626:
1627: IF l_offer_product_sql IS NULL AND l_offer_prod = FALSE THEN
1628: x_return_status := fnd_api.g_ret_sts_success;
1629: x_valid_flag := fnd_api.g_false;

Line 1635: FND_DSQL.set_cursor(l_denorm_csr);

1631: END IF;
1632:
1633: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1634: l_denorm_csr := DBMS_SQL.open_cursor;
1635: FND_DSQL.set_cursor(l_denorm_csr);
1636: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1637: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1638: FND_DSQL.do_binds;
1639: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1636: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1632:
1633: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1634: l_denorm_csr := DBMS_SQL.open_cursor;
1635: FND_DSQL.set_cursor(l_denorm_csr);
1636: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1637: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1638: FND_DSQL.do_binds;
1639: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1640: --dbms_output.put_line(l_ignore);

Line 1638: FND_DSQL.do_binds;

1634: l_denorm_csr := DBMS_SQL.open_cursor;
1635: FND_DSQL.set_cursor(l_denorm_csr);
1636: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1637: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1638: FND_DSQL.do_binds;
1639: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1640: --dbms_output.put_line(l_ignore);
1641: END IF;
1642:

Line 1783: FND_DSQL.init;

1779: OPEN c_get_offer_customer;
1780: FETCH c_get_offer_customer INTO l_offer_type, l_offer_qualifier_id;
1781: CLOSE c_get_offer_customer;
1782:
1783: FND_DSQL.init;
1784: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1785: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
1786:
1787: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN

Line 1784: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1780: FETCH c_get_offer_customer INTO l_offer_type, l_offer_qualifier_id;
1781: CLOSE c_get_offer_customer;
1782:
1783: FND_DSQL.init;
1784: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1785: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
1786:
1787: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1788: -- for lumpsum and scandata, market eligibility can be only one customer

Line 1785: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );

1781: CLOSE c_get_offer_customer;
1782:
1783: FND_DSQL.init;
1784: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1785: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
1786:
1787: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1788: -- for lumpsum and scandata, market eligibility can be only one customer
1789: IF l_offer_qualifier_id IS NULL THEN

Line 1827: FND_DSQL.add_text(')');

1823: x_return_status := l_return_status;
1824: RAISE fnd_api.G_EXC_ERROR;
1825: END IF;
1826: END IF;
1827: FND_DSQL.add_text(')');
1828:
1829: IF l_offer_market_sql IS NULL AND l_offer_mark = FALSE THEN
1830: x_return_status := fnd_api.g_ret_sts_success;
1831: x_valid_flag := fnd_api.g_false;

Line 1835: FND_DSQL.set_cursor(l_denorm_csr);

1831: x_valid_flag := fnd_api.g_false;
1832: RETURN;
1833: ELSE
1834: l_denorm_csr := DBMS_SQL.open_cursor;
1835: FND_DSQL.set_cursor(l_denorm_csr);
1836: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1837: --dbms_output.put_line('offer query: '|| l_stmt_denorm);
1838: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1839: l_offer_market_sql := l_stmt_denorm;

Line 1836: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1832: RETURN;
1833: ELSE
1834: l_denorm_csr := DBMS_SQL.open_cursor;
1835: FND_DSQL.set_cursor(l_denorm_csr);
1836: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1837: --dbms_output.put_line('offer query: '|| l_stmt_denorm);
1838: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1839: l_offer_market_sql := l_stmt_denorm;
1840: FND_DSQL.do_binds;

Line 1840: FND_DSQL.do_binds;

1836: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1837: --dbms_output.put_line('offer query: '|| l_stmt_denorm);
1838: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1839: l_offer_market_sql := l_stmt_denorm;
1840: FND_DSQL.do_binds;
1841: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1842: --dbms_output.put_line(l_ignore);
1843: END IF;
1844:

Line 1968: FND_DSQL.init;

1964: --set_budget_org(p_budget_id => p_actbudget_id);
1965:
1966: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1967:
1968: FND_DSQL.init;
1969: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1970: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
1971:
1972: OPEN c_get_budget_market_qualifiers('N');

Line 1969: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1965:
1966: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1967:
1968: FND_DSQL.init;
1969: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1970: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
1971:
1972: OPEN c_get_budget_market_qualifiers('N');
1973:

Line 1970: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');

1966: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1967:
1968: FND_DSQL.init;
1969: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1970: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
1971:
1972: OPEN c_get_budget_market_qualifiers('N');
1973:
1974: -- Get all market qualifiers for 'FUND'

Line 2012: FND_DSQL.add_text('(');

2008: l_attr_value := l_segment_id;
2009:
2010: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
2011: -- l_budget_product_sql := '(' || l_temp_sql || ')';
2012: FND_DSQL.add_text('(');
2013: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2014: ( p_context => l_context,
2015: p_attribute => l_attribute,
2016: p_attr_value_from => l_attr_value,

Line 2021: FND_DSQL.add_text(')');

2017: p_attr_value_to => NULL,
2018: p_comparison => '=',
2019: p_type => 'ELIG'
2020: );
2021: FND_DSQL.add_text(')');
2022: ELSE
2023: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
2024: FND_DSQL.add_text('UNION (');
2025: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 2024: FND_DSQL.add_text('UNION (');

2020: );
2021: FND_DSQL.add_text(')');
2022: ELSE
2023: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
2024: FND_DSQL.add_text('UNION (');
2025: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2026: ( p_context => l_context,
2027: p_attribute => l_attribute,
2028: p_attr_value_from => l_attr_value,

Line 2033: FND_DSQL.add_text(')');

2029: p_attr_value_to => NULL,
2030: p_comparison => '=',
2031: p_type => 'ELIG'
2032: );
2033: FND_DSQL.add_text(')');
2034: END IF;
2035: --dbms_output.put_line('validate_market_by_all_lines: budget:' || l_temp_sql );
2036:
2037: END LOOP;

Line 2039: FND_DSQL.add_text(')');

2035: --dbms_output.put_line('validate_market_by_all_lines: budget:' || l_temp_sql );
2036:
2037: END LOOP;
2038: CLOSE c_get_budget_market_qualifiers;
2039: FND_DSQL.add_text(')');
2040:
2041: IF l_budget_mark THEN
2042: l_denorm_csr := DBMS_SQL.open_cursor;
2043: FND_DSQL.set_cursor(l_denorm_csr);

Line 2043: FND_DSQL.set_cursor(l_denorm_csr);

2039: FND_DSQL.add_text(')');
2040:
2041: IF l_budget_mark THEN
2042: l_denorm_csr := DBMS_SQL.open_cursor;
2043: FND_DSQL.set_cursor(l_denorm_csr);
2044: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2045: l_budget_market_sql := l_stmt_denorm;
2046: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2047: FND_DSQL.do_binds;

Line 2044: l_stmt_denorm := FND_DSQL.get_text(FALSE);

2040:
2041: IF l_budget_mark THEN
2042: l_denorm_csr := DBMS_SQL.open_cursor;
2043: FND_DSQL.set_cursor(l_denorm_csr);
2044: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2045: l_budget_market_sql := l_stmt_denorm;
2046: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2047: FND_DSQL.do_binds;
2048: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 2047: FND_DSQL.do_binds;

2043: FND_DSQL.set_cursor(l_denorm_csr);
2044: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2045: l_budget_market_sql := l_stmt_denorm;
2046: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2047: FND_DSQL.do_binds;
2048: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2049: --dbms_output.put_line(l_ignore);
2050: END IF;
2051:

Line 2052: FND_DSQL.init;

2048: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2049: --dbms_output.put_line(l_ignore);
2050: END IF;
2051:
2052: FND_DSQL.init;
2053: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2054: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
2055:
2056: OPEN c_get_budget_market_qualifiers('Y');

Line 2053: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

2049: --dbms_output.put_line(l_ignore);
2050: END IF;
2051:
2052: FND_DSQL.init;
2053: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2054: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
2055:
2056: OPEN c_get_budget_market_qualifiers('Y');
2057: -- Get all excluded market qualifiers for 'FUND'

Line 2054: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');

2050: END IF;
2051:
2052: FND_DSQL.init;
2053: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2054: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
2055:
2056: OPEN c_get_budget_market_qualifiers('Y');
2057: -- Get all excluded market qualifiers for 'FUND'
2058: LOOP

Line 2095: FND_DSQL.add_text('(');

2091: l_attr_value := l_segment_id;
2092:
2093: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
2094: -- l_budget_product_sql := '(' || l_temp_sql || ')';
2095: FND_DSQL.add_text('(');
2096: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2097: ( p_context => l_context,
2098: p_attribute => l_attribute,
2099: p_attr_value_from => l_attr_value,

Line 2104: FND_DSQL.add_text(')');

2100: p_attr_value_to => NULL,
2101: p_comparison => '=',
2102: p_type => 'ELIG'
2103: );
2104: FND_DSQL.add_text(')');
2105: ELSE
2106: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
2107: FND_DSQL.add_text('UNION (');
2108: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 2107: FND_DSQL.add_text('UNION (');

2103: );
2104: FND_DSQL.add_text(')');
2105: ELSE
2106: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
2107: FND_DSQL.add_text('UNION (');
2108: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2109: ( p_context => l_context,
2110: p_attribute => l_attribute,
2111: p_attr_value_from => l_attr_value,

Line 2116: FND_DSQL.add_text(')');

2112: p_attr_value_to => NULL,
2113: p_comparison => '=',
2114: p_type => 'ELIG'
2115: );
2116: FND_DSQL.add_text(')');
2117: END IF;
2118:
2119: END LOOP;
2120: CLOSE c_get_budget_market_qualifiers;

Line 2121: FND_DSQL.add_text(')');

2117: END IF;
2118:
2119: END LOOP;
2120: CLOSE c_get_budget_market_qualifiers;
2121: FND_DSQL.add_text(')');
2122:
2123: IF l_exclude_mark THEN
2124: l_denorm_csr := DBMS_SQL.open_cursor;
2125: FND_DSQL.set_cursor(l_denorm_csr);

Line 2125: FND_DSQL.set_cursor(l_denorm_csr);

2121: FND_DSQL.add_text(')');
2122:
2123: IF l_exclude_mark THEN
2124: l_denorm_csr := DBMS_SQL.open_cursor;
2125: FND_DSQL.set_cursor(l_denorm_csr);
2126: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2127: --dbms_output.put_line('validate_market_by_all_lines: Budget exclude query:' || l_stmt_denorm);
2128: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2129: FND_DSQL.do_binds;

Line 2126: l_stmt_denorm := FND_DSQL.get_text(FALSE);

2122:
2123: IF l_exclude_mark THEN
2124: l_denorm_csr := DBMS_SQL.open_cursor;
2125: FND_DSQL.set_cursor(l_denorm_csr);
2126: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2127: --dbms_output.put_line('validate_market_by_all_lines: Budget exclude query:' || l_stmt_denorm);
2128: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2129: FND_DSQL.do_binds;
2130: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 2129: FND_DSQL.do_binds;

2125: FND_DSQL.set_cursor(l_denorm_csr);
2126: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2127: --dbms_output.put_line('validate_market_by_all_lines: Budget exclude query:' || l_stmt_denorm);
2128: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2129: FND_DSQL.do_binds;
2130: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2131: --dbms_output.put_line(l_ignore);
2132: END IF;
2133: -- not product eligibility for budget, validation is true.

Line 2151: FND_DSQL.init;

2147: OPEN c_get_offer_customer;
2148: FETCH c_get_offer_customer INTO l_offer_type, l_offer_qualifier_id;
2149: CLOSE c_get_offer_customer;
2150:
2151: FND_DSQL.init;
2152: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2153: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
2154:
2155: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN

Line 2152: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

2148: FETCH c_get_offer_customer INTO l_offer_type, l_offer_qualifier_id;
2149: CLOSE c_get_offer_customer;
2150:
2151: FND_DSQL.init;
2152: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2153: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
2154:
2155: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
2156: -- for lumpsum and scandata, market eligibility can be only one customer

Line 2153: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );

2149: CLOSE c_get_offer_customer;
2150:
2151: FND_DSQL.init;
2152: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2153: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
2154:
2155: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
2156: -- for lumpsum and scandata, market eligibility can be only one customer
2157: IF l_offer_qualifier_id IS NULL THEN

Line 2196: FND_DSQL.add_text(')');

2192: x_return_status := l_return_status;
2193: RAISE fnd_api.G_EXC_ERROR;
2194: END IF;
2195: END IF;
2196: FND_DSQL.add_text(')');
2197:
2198: IF l_offer_market_sql IS NULL AND l_offer_mark = FALSE THEN
2199: x_return_status := fnd_api.g_ret_sts_success;
2200: x_valid_flag := fnd_api.g_false;

Line 2204: FND_DSQL.set_cursor(l_denorm_csr);

2200: x_valid_flag := fnd_api.g_false;
2201: RETURN;
2202: ELSE
2203: l_denorm_csr := DBMS_SQL.open_cursor;
2204: FND_DSQL.set_cursor(l_denorm_csr);
2205: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2206: --dbms_output.put_line('validate_market_by_all_lines: offer query: '|| l_stmt_denorm);
2207: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2208: l_offer_market_sql := l_stmt_denorm;

Line 2205: l_stmt_denorm := FND_DSQL.get_text(FALSE);

2201: RETURN;
2202: ELSE
2203: l_denorm_csr := DBMS_SQL.open_cursor;
2204: FND_DSQL.set_cursor(l_denorm_csr);
2205: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2206: --dbms_output.put_line('validate_market_by_all_lines: offer query: '|| l_stmt_denorm);
2207: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2208: l_offer_market_sql := l_stmt_denorm;
2209: FND_DSQL.do_binds;

Line 2209: FND_DSQL.do_binds;

2205: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2206: --dbms_output.put_line('validate_market_by_all_lines: offer query: '|| l_stmt_denorm);
2207: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2208: l_offer_market_sql := l_stmt_denorm;
2209: FND_DSQL.do_binds;
2210: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2211: --dbms_output.put_line(l_ignore);
2212: END IF;
2213: